Home » RDBMS Server » Backup & Recovery » what are the different ways available for backup
what are the different ways available for backup [message #51427] Wed, 22 May 2002 10:42 Go to next message
ksr
Messages: 112
Registered: January 2002
Senior Member
Hi,

I want to know what are the different ways available for backup and what are the advantages and disadvantages of each, better with an explanation or examples.

Any help is appreciated.
Re: what are the different ways available for backup [message #51428 is a reply to message #51427] Wed, 22 May 2002 11:07 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
http://www.orafaq.net/faqdbabr.htm
Re: what are the different ways available for backup [message #51489 is a reply to message #51427] Fri, 24 May 2002 16:22 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
I have an application named Installgen which automates creating backup/recovery scripts along with creating the documentation for performing 15 different database recovery scenarios.

You may download a demo version of Installgen so that you may conveniently look at or modify the scripts on your own computer:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

Or you may choose to browse the individual output files via the web:
http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_win901.html

Here is a full-featured RMAN backup script I like to use for situations where I am not using a recovery catalog:
http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_29_.html
RMAN is preferred by Oracle over the Hot Backup method because it generates less redo in the database and you can also throttle the amount of I/O used by RMAN. (I have implemented this functionality on my scripts.) This means that if necessary, you can perform the RMAN backup while users are actively using the server without consuming all of the I/O bandwidth of the server. You will need to adjust the default I/O rate to a value which is suitable for your server.

Previous Topic: Restoring/Recovering Database
Next Topic: RMAN Log only Backup/Restore
Goto Forum:
  


Current Time: Tue May 21 09:39:07 CDT 2024