| Best way to backup a database [message #302112] |
Sat, 23 February 2008 12:15  |
jefkatz
Messages: 2
Registered: February 2008
|
Junior Member |
|
|
Hi,
what's the best way to backup (the quickest and the more efficient in term of storage capacity and time it consumes) to backup an Oracle database.
Is making a compressed archive from data files a good choice. Is it necessary to stop database when restoring (overwriting data files with previous version) ? Is there a risk if the database is not stopped and even if there's no activity on the database ?
Thanks a lot.
|
|
|
|
|
|
|
|
|
|
| Re: Best way to backup a database [message #304304 is a reply to message #302117] |
Tue, 04 March 2008 16:43  |
alanm
Messages: 284
Registered: March 2005
|
Senior Member |
|
|
hi,
What version database are you running.
the Oracle recommended way of backing up an oracle database is to use RMAN.
with 10g this also allows compression to be done in the rman statement. If you are using 9i then use an OS utility to compress the backup pieces.
regards
Alan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
