Oracle database 11g. What is the easiest way to set up a full nightly database backup to a network drive (ie drive on another computer)?
+1
A:
Read the backup and recovery guide.
Don't just backup... Make sure you test your backup, regularly!!
Matthew Watson
2008-10-08 08:35:26
While this is true it doesn't really answer the question.
Leigh Riffel
2008-10-22 13:50:17
A:
If you have Grid Control setup the easiest way would be to use the web interface. The interface allows you to specify a unc path (\computer\share name). You will have to create a share on the remote computer.
If you don't have Grid Control you can create a script that uses RMAN. If you need script specifics it would be helpful to know what OS your database is on.
Leigh Riffel
2008-10-12 13:22:08
A:
You need a backup strategy. Once you have defined that you will see what options are available to suit your needs.
stevechol
2008-12-23 16:37:24
A:
mount the network drive, use rman to fully backup the db to the network drive. Rman can do it hot. Another method is to export full but you'll have to flush all writes and put the db into restricted mode so no user can make changes while you export to get a full consistent backup.
MichaelN
2009-03-10 16:04:50