Sunday, October 23, 2011

RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
Problem:


rman target / catalog rman1/rman1@rman debug trace c:\debug.trace

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 10 11:02:57 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN-06005: connected to target database: BMC1 (DBID=3542203146)
RMAN-06008: connected to recovery catalog database

RMAN> list backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set

RMAN>

AND FROM THE DEBUG FILE

DBGMISC: Finished cleanup at 10-JAN-11 [11:03:08.767]
DBGMISC: EXITED krmice [11:03:08.767] elapsed time [00:00:00:01.454]
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 01/10/2011 11:03:07
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20021: database not set
RMAN-06097: text of failing SQL statement: begin dbms_rcvman . translateArchivedLogSCNRange ( thread# => NULL , fromscn => 0 , toscn => 281474976710655 + 1 , pattern => NULL , statusMask => :statusMask , online => :online , duplicates => :duplicates , needstby => :getstby , onlyrdf => :onlyrdf ) ; end ;
RMAN-06099: error occurred in source file: krmk.pc, line: 21779
DBGMISC: ENTERED krmkursr [11:03:08.782]



Solution:




After bouncing the RMAN cataqlog database, issue resolved



Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: