Hello.
We are oracle 9.2.0.4 AIX 5.2

I am testing out using RMAN. I AM using a recovery catalog. I am in
archivelog mode.
The test is:
1) Backup using rman, plus archivelog.
2) shutdown
3) delete the datafiles, but leave control files, online redos and archived
logs intact.
4) startup mount
5) restore database - works OK.
6) recover database gives me the error:
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 126 scn 993426 found to restore

I have checked the list backups and that log file is on the backups. There
are many archivelogs, both before sequence 126 and after. The change in
sequence 126 was applied to the database last week. That file is on disk,
owned by oracle with the proper permissions. The RECOVER should not even
need that at all!

I have tried doing another backup archivelog all, resyncing the catalog,
crosscheck archivelog , and these all check out OK.
But the recover command still gives me that error!

The kicker is, I then go into SQLPLUS as sysdba, issue a recover database,
it replays all archive logs (it doesn't even look for sequence 126 because
that was in the database well before the backup). It finishes fine, and I
can issue alter database open; and all is well.

Does anyone have any RMAN insight on this?
THANK YOU!

<<<<<>>>>>
Brian


Oracle LazyDBA home page