Home » RDBMS Server » Backup & Recovery » cannot connect catalog - RMAN (oracle 11.2.0.1 RAC of two nodes,solaris10)
cannot connect catalog - RMAN [message #540586] Tue, 24 January 2012 12:22 Go to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
hi,
we have a cluster of two nodes having oracle 11G R2 and another single instance server where RMAN is configured and this is backup server.i have created the service between the the target database and backup server and they are working fine i.e tnsping work fine at both sites.
Now i have physical backup scripts written at one of cluster node and scripts run at crontab. The backup include full_backup , archive backup etc.
Now all physical backups work fine that is connecting RMAN and then catalog and then complete the backup but the full_backup do not connect catalog and throw this error that it do not know the SID in the connect descriptor. the tnsping output (from target ) is as followed
 fedb112 # tnsping bkp

TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 14:11:45

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.x.x.x)(PORT = 1521))
 (CONNECT_DATA = (SERVER = DEDICATED) (ORACLE_SID = bkp1)))
OK (0 msec)


the full_backup script is as follwos
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
ORACLE_SID=grid112
PATH=$PATH:$ORACLE_HOME/bin
export PATH
export ORACLE_SID
export ORACLE_HOME
BACKUP_MEDIA=DISK
BACKUP_TYPE=FULL_DB_BKUP
TIMESTAMP=`date +%T-%m-%d-%Y`
LOG=/export/home/oracle/phydumps/${ORACLE_SID}_${BACKUP_TYPE}_${BACKUP_MEDIA}_${TIMESTAMP}.log
export LOG
export BACKUP_MEDIA
export BACKUP_TYPE
export TIMESTAMP
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog rcowner/rcowner@bkp
run
 {
 allocate channel c1 type disk 
format '/export/home/oracle/phydumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
 backup tag=full_backup incremental level 0 database;
release channel c1;
}
exit
EOF


in above scripts " connect catalog rcowner/rcowner@bkp " do not connect while i have other two scripts for incremental backup and archival backup, have the same code but they connect successfully and this one do not

now i run lsnrctl status at backup server , as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version 11.2.0.1.0 - Production
Start Date                24-JAN-2012 13:45:44
Uptime                    0 days 0 hr. 3 min. 59 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/11.2.0/dbhome_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.x.x.x)(PORT=1521)))
The listener supports no services
The command completed successfully



so kindly any on can guide why it do not connect to RMAN catalog and use control file instead for backup


kindly guide

Regards

janakors

[Updated on: Tue, 24 January 2012 12:40] by Moderator

Report message to a moderator

Re: cannot connect catalog - RMAN [message #540587 is a reply to message #540586] Tue, 24 January 2012 12:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
The listener supports no services

Re: cannot connect catalog - RMAN [message #540589 is a reply to message #540586] Tue, 24 January 2012 12:32 Go to previous messageGo to next message
BlackSwan
Messages: 26196
Registered: January 2009
Location: SoCal
Senior Member
>in above scripts " connect catalog rcowner/rcowner@bkp " do not connect
so why do you NOT show us the actual & complete error?

>while i have other two scripts for incremental backup and archival backup,
>have the same code but they connect successfully and this one do not
same code produces same results.
different results come from something being different.
Re: cannot connect catalog - RMAN [message #540595 is a reply to message #540589] Tue, 24 January 2012 12:53 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
@BlackSwan let me post the script which successfully connect the catalog and that is
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db
ORACLE_SID=grid112
PATH=$PATH:$ORACLE_HOME/bin
export PATH
export ORACLE_SID
export ORACLE_HOME
BACKUP_MEDIA=DISK
BACKUP_TYPE=ARCHIVE_BKUP
TIMESTAMP=`date +%T-%m-%d-%Y`
LOG=/export/home/oracle/phydumps/${ORACLE_SID}_${BACKUP_TYPE}_${BACKUP_MEDIA}_${TIMESTAMP}.log
export LOG
$ORACLE_HOME/bin/rman log=$LOG <<EOF
connect target /
connect catalog rcowner/rcowner@bkp
run
 {
 allocate channel c1 type disk format '/export/home/oracle/phydumps/${ORACLE_SID}_${BACKUP_TYPE}_${TIMESTAMP}_%p_%s.rman';
 backup tag=archive_backup archivelog from time 'sysdate-1' until time 'sysdate';
release channel c1;
}
exit
EOF



above is script archive backup and "connect catalog rcowner/rcowner@bkp " is exactly same as given in the script for full backup so this one connect the catalog successfully while the other not

so what is different now?

Regards
Janakors
Re: cannot connect catalog - RMAN [message #540599 is a reply to message #540595] Tue, 24 January 2012 13:04 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Mahesh Rajendran wrote on Tue, 24 January 2012 19:31
Quote:
The listener supports no services


Re: cannot connect catalog - RMAN [message #540602 is a reply to message #540599] Tue, 24 January 2012 13:11 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
Michel Cadot wrote on Tue, 24 January 2012 13:04
Mahesh Rajendran wrote on Tue, 24 January 2012 19:31
Quote:
The listener supports no services



but why then it work for other scripts? they connect successfully?
??

Regards

janakors
Re: cannot connect catalog - RMAN [message #540608 is a reply to message #540602] Tue, 24 January 2012 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 65848
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet it works or does not work for neither script at the same time!

Regards
Michel

[Updated on: Wed, 25 January 2012 05:56]

Report message to a moderator

Re: cannot connect catalog - RMAN [message #540670 is a reply to message #540608] Wed, 25 January 2012 05:03 Go to previous messageGo to next message
janakors
Messages: 180
Registered: September 2009
Senior Member
yes, you are correct as there is some issue with the listener

thank you Michel

Regards

janakors
Re: cannot connect catalog - RMAN [message #540736 is a reply to message #540670] Wed, 25 January 2012 08:33 Go to previous message
BlackSwan
Messages: 26196
Registered: January 2009
Location: SoCal
Senior Member
>yes, you are correct as there is some issue with the listener

There is an "issue"; but not with the listener.
Previous Topic: WARNING: archived log not deleted - must create more backups during a backup
Next Topic: How to recover unarchived data in case of media failure
Goto Forum:
  


Current Time: Fri Oct 19 12:28:43 CDT 2018