-
RMAN (missing .arc file)
I running the RMAN command below and getting the following error. I did
check and the .arc file it's refrerring to is not there. Would running a crosscheck command get rid of this problem, if not how can I rectify this issue.
SOLUTION
========
run {
crosscheck archivelog all;
}
PROBLEM
=======
rman <
connect target login/password
connect catalog login/password
show all;
sql "alter system archive log current";
backup filesperset 5 archivelog until time 'sysdate-2/24'
format $FILE_DEST_ARCH
delete input ;
resync catalog;
EOT
RMAN-00571: =========================================================
RMAN-00569: ==== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==============================================
RMAN-03002: failure of backup command at 11/29/2010 21:39:46
RMAN-06059: expected archived log not found, lost of archived log compromises re
coverability
ORA-19625: error identifying file /archive/ifdtest1/ifdtest1_1_1_736321408.arc
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
-
Alternative one:
Code:
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CHANGE ARCHIVELOG ALL CROSSCHECK;
Alternative two:
Code:
BACKUP
FORMAT ...etc...
ARCHIVELOG ALL DELETE INPUT SKIP INACCESSIBLE;
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
Originally Posted by LKBrwn_DBA
Alternative one:
Code:
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CHANGE ARCHIVELOG ALL CROSSCHECK;
Alternative two:
Code:
BACKUP
FORMAT ...etc...
ARCHIVELOG ALL DELETE INPUT SKIP INACCESSIBLE;
This will be a one time run correct?
run
{
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CHANGE ARCHIVELOG ALL CROSSCHECK;
}
-
Originally Posted by BeefStu
This will be a one time run correct?
run
{
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CHANGE ARCHIVELOG ALL CROSSCHECK;
}
Yes, it's a one time fix and works in 11g, not sure if it will work on lower versions.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|