Home » RDBMS Server » Backup & Recovery » Restoring/Recovering Database
Restoring/Recovering Database [message #51486] Fri, 24 May 2002 11:40 Go to next message
Sulaiman Gboyega N.
Messages: 17
Registered: April 2002
Junior Member
Hi All,

Please I need a tip on how I can achieve the following:

I run my database in archive log mode
I backup my database once a week (Full cold backup)
Then I back up archive log every night.

Supposing, I did the full backup on sunday, and my database crash on Wednesday. I need to restore my Backup, and then use the archive log of Monday-Wednesday to bring it up to date.

I found it fairly straight forward to carry out these backups but my problem is how can I restore the backup and apply these archive log?

Note: I am relatively new to ORACLE DBA so I will appreciate a fairly detail explanation.

Thanks a lot.

Regards,
Sulaiman

Report message to a moderator

Re: Restoring/Recovering - Installgen scripts for backups [message #51487 is a reply to message #51486] Fri, 24 May 2002 16:15 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.

Report message to a moderator

Previous Topic: Rman- Restore to a different host
Next Topic: what are the different ways available for backup
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 15:36:26 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.