I've see the exact same thing. Worked with oracle on it for 2 weeks and
couldn't resolve it.
Then we blew away the rman catalog and re-registered. That of course
resolved it.
-----Original Message-----
From: brian [mailto:oracledba-ezmlmshield-x79394452.[Email address protected]
Sent: Tuesday, December 28, 2004 5:51 PM
To: LazyDBA Discussion
Subject: RMAN recover error 06025
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
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
-----------------------------------------
Use of email is inherently insecure. Confidential information, including
account information, and personally identifiable information, should not be
transmitted via email, or email attachment. In no event shall Citizens or
any of its affiliates accept any responsibility for the loss, use or misuse
of any information including confidential information, which is sent to
Citizens or its affiliates via email, or email attachment. Citizens does
not guarantee the accuracy of any email or email attachment, that an email
will be received by Citizens or that Citizens will respond to any email.
This email message is confidential and/or privileged. It is to be used by
the intended recipient only. Use of the information contained in this
email by anyone other than the intended recipient is strictly prohibited.
If you have received this message in error, please notify the sender
immediately and promptly destroy any record of this email.
Oracle LazyDBA home page