OraFAQ Forum: Backup & Recovery » Problem with RMAN

Home » RDBMS Server » Backup & Recovery » Problem with RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with RMAN [message #70611]

Sat, 06 July 2002 05:22

manla
Messages: 5
Registered: July 2002

Junior Member

Hi every body i have made a script under AIX for restoring my oracle database.

But when restoring i get this error:
Who can help ?

Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: SID(DBID=1070060421)
RMAN-06008: connected to recovery catalog database

RMAN> shutdown immediate;
2> startup mount;
3> run {
4> allocate channel t1 type 'sbt_tape';
5> restore database;
6> alter database open;
7> release channel t1;
8> }
9>
RMAN-06405: database closed
RMAN-06404: database dismounted
RMAN-06402: Oracle instance shut down

RMAN-06193: connected to target database (not started)
RMAN-06196: Oracle instance started
RMAN-06199: database mounted

Total System Global Area 129501308 bytes

Fixed Size 116860 bytes
Variable Size 63676416 bytes
Database Buffers 65536000 bytes
Redo Buffers 172032 bytes

RMAN-03022: compiling command: allocate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: allocate
RMAN-06004: ORACLE error from recovery catalog database: ORA-12571: TNS:packet writer failure

RMAN-06099: error occurred in source file: krmk.pc, line: 9397

Report message to a moderator

Re: Problem with RMAN [message #70613 is a reply to message #70611]

Sat, 06 July 2002 20:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

1. first check the Packages DBMS_RCVCAT  DBMS_RCVMAN are valid.
2. The error occured communicating via sqlnet 
   to the catalog database. Try: 
       rman target / nocatalog 
   Then run your script.
   Find out what broke the connection to the catalog. 
   Trace sqlnet to see where the error starts. 
   or
   run rman in debug mode.

Report message to a moderator

Re: Problem with RMAN [message #70616 is a reply to message #70611]

Mon, 08 July 2002 01:21

manla
Messages: 5
Registered: July 2002

Junior Member

Hello !!!
I should precise that I use a recovery catalog which is in the same database that th eone i am backuping.
And I can connect to my catalog and execute some rman commands such list backup, crosscheck ...
But don't u think that it's because I have sutted down the database that I cannot connect to anymore ?
I had red about disadvantage of having a catalog on the same database that the one to be backedp up ..but never read that it is not possible to restore ....
So how to troubleshoot it ?
I have checked the dbms_rcvcat and dbms_dcvrman pachages and they are valid.
any Idea ???

Report message to a moderator