Home » RDBMS Server » Backup & Recovery » rman restore (oracle 10g, solaris 9)
rman restore [message #589819] Thu, 11 July 2013 01:57 Go to next message
santosh arolla
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
Here i am haing a strang issue.

My rman backup runs every day nightly and it is a full backup daily.
we have backupset of two day of the full backups.

now we have a situation where we have to restore the database to a point 5 day days from now.

will i be able to restore the database to 5day back with todays full backup.
or do i need to have the back of the day when i want to restore.

Please help me out with this.
Re: rman restore [message #589821 is a reply to message #589819] Thu, 11 July 2013 02:22 Go to previous messageGo to next message
John Watson
Messages: 4553
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and PLEASE read How to use [code] tags and make your code easier to read

If you can't work this out for yourself, you can test it, and see what RMAN says. Like this:
RMAN> restore database until time 'sysdate - 5 ';

Re: rman restore [message #589822 is a reply to message #589821] Thu, 11 July 2013 02:41 Go to previous messageGo to next message
santosh arolla
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
Hi john
thanks for the reply.

in my case the issue is on production databse and it does not have standby.
it a huge database and i dont have resource to test it.
Re: rman restore [message #589823 is a reply to message #589822] Thu, 11 July 2013 02:46 Go to previous messageGo to next message
John Watson
Messages: 4553
Registered: January 2010
Location: Global Village
Senior Member
So do a test run, that will simply tell you if it is possible:
RMAN> restore database until time 'sysdate - 5 ' validate;

Starting restore at 11-JUL-13
using channel ORA_DISK_1

channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece C:\TMP\02OCJ40G_1_1.BSET
channel ORA_DISK_1: ORA-19870: error while restoring backup piece C:\TMP\02OCJ40G_1_1.BSET
ORA-19505: failed to identify file "C:\TMP\02OCJ40G_1_1.BSET"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

failover to previous backup

datafile 5 will be created automatically during restore operation
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/11/2013 08:45:09
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>
this sort of thing is all in the docs, you know.
Re: rman restore [message #589825 is a reply to message #589823] Thu, 11 July 2013 02:49 Go to previous message
santosh arolla
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
thanks john that was realy helpfull.
Previous Topic: Duplicate target database unable to open database
Next Topic: Online Redo - Different Destination
Goto Forum:
  


Current Time: Wed Sep 17 00:50:28 CDT 2014

Total time taken to generate the page: 0.16964 seconds