Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > RMAN recovery q...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 16527 of 16855
Post > Topic >>

RMAN recovery question

by Chuck <skilover_nospam@[EMAIL PROTECTED] > May 7, 2008 at 03:41 PM

A cold backup was taken of a 10.2.0.3 database using rman. The database 
was shut down cleanly before the backup was started. When I tried to 
restore the backup a few days later, it would not let me open the 
database. It said that file 1 (system01.dbf) file needed further 
recovery. Why would a file need *any* recovery if it was a cold backup?

These are the rman commands used to do the restore.

startup force nomount;
restore controlfile from '$mediahandle';
alter database mount;
restore database from tag $tag;
alter database open resetlogs;

The $variables are shell variables that specify the appropriate 
information needed to restore the correct control file and backup sets. 
It's part of a script that's worked dozens of times before. Everything 
worked fine up to the "alter database open resetlogs;" where it started 
complaining about needing recovery on one of the files. There were no 
errors in either the backup or the restore.

TIA
 




 6 Posts in Topic:
RMAN recovery question
Chuck <skilover_nospam  2008-05-07 15:41:00 
Re: RMAN recovery question
gazzag <gareth@[EMAIL   2008-05-07 08:47:10 
Re: RMAN recovery question
Chuck <skilover_nospam  2008-05-07 17:14:35 
Re: RMAN recovery question
hpuxrac <johnbhurley@[  2008-05-07 10:11:30 
Re: RMAN recovery question
Chuck <skilover_nospam  2008-05-07 17:26:32 
Re: RMAN recovery question
joel garry <joel-garry  2008-05-07 11:44:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Sun Jul 6 0:06:37 CDT 2008.