Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EMERGENCY: List of files in Recovery Area not managed by the database

742854May 5 2010 — edited May 14 2010
Hi,

this is an emergency request....

I have this data guard set up. And i accidently dropped online redo logs, standby logs and the archive log except the current online redolog.
i actually ran to cleanup the whole directory which included the controlfile and the datafiles (was on the wrong location on ASM)
but the controlfile and the datafiles did not get deleted. i can still see them on the ASM.
and now when i am trying to restore the archive logs, but i keep getting error as shown below...

WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. This is most likely the result of a crash
during file creation.

so when i did the below i was getting error as:

RMAN> CATALOG RECOVERY AREA;

using target database control file instead of recovery catalog
searching for all files in the recovery area
no files found to be unknown to the database

List of files in Recovery Area not managed by the database
==========================================================
File Name: +DATA/afcpdg/controlfile/controlfile01.ctl
RMAN-07526: Reason: File is not an Oracle Managed File
File Name: +DATA/afcpdg/onlinelog/group_1.304.718194815
RMAN-07527: Reason: File was not created using DB_RECOVERY_FILE_DEST initialization parameter
.......
.......
.......
.......
number of files not managed by recovery area is 82, totaling 168.10GB


But i do see those data files that RMAN is complaining as shown above in the ASM.
I HOPE I DID NOT MESS UP THE CONTROLFILE and the DATFILES
CAN SOMEONE HELP ME FIX THIS MISTAKE THAT I DID.

Right now the data guard is running fine, the logs are getting shipped from primary and the getting applied at the DG.
And i am able to see all the redo logs got deleted.
But not sure how the deleted redo logs got created in the ASM (i did not create them manually)

Thanks.
Philip.

Edited by: user8898644 on May 5, 2010 8:52 AM

Edited by: user8898644 on May 5, 2010 9:16 AM

Edited by: user8898644 on May 5, 2010 11:43 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2010
Added on May 5 2010
4 comments
2,986 views