-
Hi:
I am having a problem with RMAN backups:
I issued the following command to backup all the archived logs:
backup
(archivelog all
delete input)
It fails with the following error:
RMAN-06089 archived log 'log file name' not found or out of sync with catalog.
The reason it fails is because I accidentally deleted the files from the Unix file system - but I guess there are still references to it within the database.
My question is - Is there a way for me to delete these references from the database. I don't really care about those archived log files anyway, but starting now I do want to backup all future archived log files.
Thanks,
Una.
-
Can you post your entire RMAN script?
Thanks.
David Knight
OCP DBA 8i, 9i, 10g
-
The script is as follows:
create script online_database_bkup {
# Hot database level 0 whole backup
allocate channel t1 type DISK;
backup
incremental level 0
skip inaccessible
tag hot_db_bk
# recommended format
format 'bk_%s_%p_%t'
(database);
sql 'alter system archive log current';
# backup all archive logs
backup
filesperset 20
format 'al_%s_%p_%t'
(archivelog all
delete input);
}
I run it using the following command:
run { execute script online_database_bkup; }
-
replace script online_database_bkup {
# Hot database level 0 whole backup
allocate channel t1 type DISK;
backup
incremental level 0
skip inaccessible
tag hot_db_bk
# recommended format
format 'bk_%s_%p_%t'
(database include current controlfile);
release channel t1;
sql 'alter system archive log current';
allocate channel t1 type DISK;
# backup all archive logs
backup
filesperset 20
format 'al_%s_%p_%t'
(archivelog all
delete input);
release channel t1;
}
This would fix you the problem
Sam
Thanx
Sam
Life is a journey, not a destination!
-
I tried the script with the modifications you suggested and it still fails...
-
What is your oracle and OS version, could you also give me all the errors you get?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
If the backup of archive logs done by rman fails for the reason some or one archive log file to be backed up is not available.. you may validate the archive logs by issuing change validate archive log all command from rman prompt and then back up the archive logs.
sonofsita
http://www.ordba.net
-
for the missing archive logs... u can do the following
connect target /
connect catalog rman/pwd@rmancatalog
run {
change archivelog from logseq = xxx until logseq =
yyy unavailable;
}
xxx and yyy are the logseg numbers, the one's you are missing.
-
Hi!
Complete resync your database with catalog:
rman>resync database
Then try your script. This should take care your problem
regards,
abhijit
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
|