>> 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@(protected) on behalf of Dennis Williams Sent: Fri 8/19/2005 12:42 PM To: mccdba1@(protected) Cc: oracle-l@(protected) 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39"> <TITLE>RE: [Q] How RMAN restore control file from tape?</TITLE> </HEAD> <BODY> <!-- Converted from text/plain format -->
<P><FONT SIZE=2>>> Recovery of RMAN from just the control file,<BR> >> yet without a control file, is tricky.<BR> "tricky"...or maybe impossible.<BR> If you need a current "metadata backup index" (i.e. controlfile), but don't have any,<BR> to get a backup copy a current "metadata backup index" (i.e. controlfile), you are out of luck.<BR> <BR> <BR> >> I always took a control file backup separately from RMAN after the RMAN backup<BR> >> and ensured the control file was written to tape.<BR> Amen!...backup the "metadata backup index" (i.e. controlfile), after each backup.<BR> <BR> Chris Marquez<BR> Oracle DBA<BR> <BR> <BR> <BR> <BR> -- --Original Message-- --<BR> From: oracle-l-bounce@(protected) on behalf of Dennis Williams<BR> Sent: Fri 8/19/2005 12:42 PM<BR> To: mccdba1@(protected)<BR> Cc: oracle-l@(protected)<BR> Subject: Re: [Q] How RMAN restore control file from tape?<BR> <BR> MCC,<BR> <BR> >=RMAN-06172: no autobackup found or specified handle is<BR> > >not a valid copy or piece<BR> <BR> Just a guess here, but it looks as if you didn't back up the control file .<BR> I see autobackup off in your listing. At this point I would guess your<BR> choices are to either start over again and take another backup, or to go<BR> take a backup of the control file, move it over, and try the restore again.<BR> Recovery of RMAN from just the control file, yet without a control file, is<BR> tricky. Myself, I gave up and just always took a control file backup<BR> separately from RMAN after the RMAN backup, and ensured the control file was<BR> written to tape.<BR> Another point, you say you are extracting the backup from tape, yet all <BR> your listing mentions is tape. What gives?<BR> Dennis Williams<BR> <BR> </FONT> </P>
