Skip to Main Content

Oracle Database Discussions

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!

RMAN-03002: failure of crosscheck command at 04/01/2011 16:40:11 RMAN-06091

775855Apr 1 2011 — edited Apr 1 2011
Hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 29 2011
Added on Apr 1 2011
3 comments
2,983 views