OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » rman restore (oracle 10g, solaris 9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman restore [message #589819]

Thu, 11 July 2013 01:57

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.

Report message to a moderator

Re: rman restore [message #589821 is a reply to message #589819]

Thu, 11 July 2013 02:22

John Watson
Messages: 8804
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 ';

Report message to a moderator

Re: rman restore [message #589822 is a reply to message #589821]

Thu, 11 July 2013 02:41

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.

Report message to a moderator

Re: rman restore [message #589823 is a reply to message #589822]

Thu, 11 July 2013 02:46

John Watson
Messages: 8804
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.

Report message to a moderator

Re: rman restore [message #589825 is a reply to message #589823]

Thu, 11 July 2013 02:49

santosh arolla
Messages: 3
Registered: July 2013
Location: hyderabad

Junior Member

thanks john that was realy helpfull.

Report message to a moderator

Previous Topic:	Duplicate target database unable to open database
Next Topic:	Online Redo - Different Destination

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 26 23:18:50 CDT 2023