RMAN-03002: failure of crosscheck command at 04/01/2011 16:40:11 RMAN-06091
775855Apr 1 2011 — edited Apr 1 2011Hi
From last 2 days the backup for one of the database in the server stopped working. So I planned to run it manually by copying the code and pasting it. This is the code
run {
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
allocate channel t2 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
show all;
crosscheck archivelog all;
delete noprompt expired archivelog all;
#crosscheck database;
#delete noprompt expired database;
crosscheck backup of database;
delete noprompt expired backup;
report obsolete;
delete force noprompt obsolete;
report obsolete;
backup
incremental level 0
# cumulative
filesperset=10
tag backup_db_level_0
current controlfile
format 'dblevel0_%d.%s_%p_%t'
(database);
sql 'alter system archive log current';
backup
(archivelog all format 'dbarch_%d.%s_%p_%t'
delete input);
release channel t1;
release channel t2;
}
But I am getting an error. Its showing
specification does not match any archive log in the recovery catalog
released channel: t1
released channel: t2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of crosscheck command at 04/01/2011 16:40:11
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
The same code was run for the other databases in the same server. I didnt get above error. What i should do?
Thanks
Shiyas M