Home » RDBMS Server » Backup & Recovery » rman backup restoration (linux )
rman backup restoration [message #525065] Wed, 28 September 2011 12:34 Go to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Hi,

I got Saturday rman level 0 backup and sunday, monday, tuesday & Wednesday level 1 backup.

I got some issue and i have to restore the backup with minimum data loss.

Thus i request if you please suggest me path for restoration of the backup. We can restore 1st level 0 backup, but how to apply others level 1 backup on that.

Thanks

Jay vardhan
Re: rman backup restoration [message #525066 is a reply to message #525065] Wed, 28 September 2011 12:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
is/was DB have archive mode enabled.
which version of Oracle to 4 decimal places?

open Service Request with Oracle
Re: rman backup restoration [message #525067 is a reply to message #525065] Wed, 28 September 2011 12:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I got some issue and i have to restore the backup with minimum data loss.

You can do it with NO data loss.

Quote:
Thus i request if you please suggest me path for restoration of the backup. We can restore 1st level 0 backup, but how to apply others level 1 backup on that.

You have nothing to know or think just:
restore database;
recover database;

Of course, it you are using RMAN, and I don't see any reason you shouldn't.

Regards
Michel
Re: rman backup restoration [message #525068 is a reply to message #525067] Wed, 28 September 2011 12:58 Go to previous messageGo to next message
dba_7722
Messages: 197
Registered: August 2010
Location: Delhi
Senior Member

Thanks Michel,

Shall i need to apply level 1 backup one by one.. or it will restore backup at once ..??

Thanks
Re: rman backup restoration [message #525070 is a reply to message #525068] Wed, 28 September 2011 13:07 Go to previous message
Michel Cadot
Messages: 68043
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You do not need to apply anything, as I said, just execute the 2 commands I posted, RMAN does the rest, RMAN does know what it has to restore, RMAN does know what it has to recover (for most cases, if you want to know how to do it in all cases read Database Backup and Recovery Advanced User's Guide).

Regards
Michel
Previous Topic: not able to do 'alter database open resetlogs;'
Next Topic: Making a copy of existing Source tables for BI Reporting
Goto Forum:
  


Current Time: Wed Dec 01 22:40:18 CST 2021