RE: [Q] How RMAN restore control file from tape?
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <oracledba.williams@xxxxxxxxx>, <mccdba1@xxxxxxxxx>
- Date: Fri, 19 Aug 2005 14:20:39 -0400
>> 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@xxxxxxxxxxxxx on behalf of Dennis Williams
Sent: Fri 8/19/2005 12:42 PM
To: mccdba1@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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
Other related posts: