Paula - I don't see where anyone replied, so . . . In Oracle 8i, backing up
the control file with RMAN and then recovering that control file is a dicey
business. I recall that part of the problem is the point in the backup the
control file is backed, maybe not after the file backups. Anyway, I gave up
on that backup and just issue a separate statement after the RMAN backup. I
think in 9i this is much better and maybe RMAN backs the control file up
automatically. I think Robert Freeman's book has information about this, but
my copy is at work. I know, I know, I should have two copies, right? Sorry
this isn't much help, hopefully you've made more progress by now.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, May 30, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
methinks resync - could I be write? I had taken a tablespace offline and
had not resynched with catalog - kind of makes sense.
-----Original Message-----
Sent: Friday, May 30, 2003 5:34 PM
To: '[EMAIL PROTECTED]'
Guys,
Running Oracle 8.1.7
RMAN with automated backups - no problem
Wish to recover
recovered controlfile from backup then issued following:
MAN> run {execute script alloc_all_tapes;
> restore database;
> recover database noredo;
> execute script rel_all_tapes;}
It failed with:
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 173 found to restore
Yet, when I query the target database mounted and look for
1* select file#,ts#,status,name from v$datafile
SQL> i
2 where file#=173;
no rows selected
MAKES NO SENSE AT ALL!!! WHERE IS IT COMING FROM WITH FILE#173 - IF THE
MOUNTED TARGET DATABASE DOESN'T LIST 173 FROM V$DATAFILE OR
V$RECOVER_FILE!!!
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
