Home » RDBMS Server » Backup & Recovery » Unable to connect to RMAN
Unable to connect to RMAN [message #216518] Mon, 29 January 2007 01:07 Go to next message
Tai
Messages: 8
Registered: February 2002
Junior Member
Hello, I try to connect to rman but fail. The following is what I did. Can anyone give me a clues as why this happen? Thanks.

C:\>rman TARGET / CATALOG rman/rman@catdb

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 29 15:04:32 2007

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12560: TNS:protocol adapter error

C:\>
Re: Unable to connect to RMAN [message #216519 is a reply to message #216518] Mon, 29 January 2007 01:09 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi,
first start your oracle services.

c:\>net start OracleService<sid>
and try to connect RMAN
c:\>rman target=sys@tns_entry catalog=user/pwd@tns_entry


regards
Taj
Re: Unable to connect to RMAN [message #216520 is a reply to message #216519] Mon, 29 January 2007 01:16 Go to previous messageGo to next message
Tai
Messages: 8
Registered: February 2002
Junior Member
Hello Taj,

Thanks for replying, now I'm getting this error

C:\>rman CATALOG rman/password@catdb TARGET system/password@orcl

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 29 15:14:38 2007

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

connected to target database: ICMS (DBID=3600875865)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-00257: archiver error. Con
nect internal only, until freed.

C:\>
Re: Unable to connect to RMAN [message #216521 is a reply to message #216520] Mon, 29 January 2007 01:19 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
you database is not in archive log mode.
try to turn on ARCHIVE LOG MODE.
c:\>sqlplus "sys as sysdba"
password :

sql>shutdown immediate;
sql>startup mount;
sql>alter database archivelog;
sql>alter database open;


and also check archive log destination is not OUT OF SPACE
c:\>rman target=sys@tns_entry
RMAN>backup archivelog delete all input;
or
increase db_recovery_file_dest_size


regards
Taj

[Updated on: Mon, 29 January 2007 01:29]

Report message to a moderator

Previous Topic: backup for oracle 9i
Next Topic: How to config. Rman Tape Backup. ?
Goto Forum:
  


Current Time: Tue Nov 26 20:57:22 CST 2024