Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] How RMAN restore control file from tape?

RE: [Q] How RMAN restore control file from tape?

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Fri, 19 Aug 2005 14:20:39 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5F2D@ecogenemld50.Org.Collegeboard.local>


>> Recovery of RMAN from just the control file,
>> yet without a control file, is tricky.
"tricky"...or maybe impossible.
If you need a current "metadata backup index" (i.e. controlfile), but don't have any, to get a backup copy a current "metadata backup index" (i.e. controlfile), you are out of luck.

>> I always took a control file backup separately from RMAN after the RMAN backup
>> and ensured the control file was written to tape.
Amen!...backup the "metadata backup index" (i.e. controlfile), after each backup.

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Dennis Williams Sent: Fri 8/19/2005 12:42 PM
To: mccdba1_at_yahoo.com
Cc: oracle-l_at_freelists.org
Subject: Re: [Q] How RMAN restore control file from tape?  

MCC,  >=RMAN-06172: no autobackup found or specified handle is > >not a valid copy or piece

 Just a guess here, but it looks as if you didn't back up the control file. I see autobackup off in your listing. At this point I would guess your choices are to either start over again and take another backup, or to go take a backup of the control file, move it over, and try the restore again.  Recovery of RMAN from just the control file, yet without a control file, is tricky. Myself, I gave up and just always took a control file backup separately from RMAN after the RMAN backup, and ensured the control file was written to tape.
 Another point, you say you are extracting the backup from tape, yet all your listing mentions is tape. What gives?  Dennis Williams

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 19 2005 - 13:26:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US