cannot connect catalog - RMAN [message #540586] |
Tue, 24 January 2012 12:22 |
janakors
Messages: 232 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 #540595 is a reply to message #540589] |
Tue, 24 January 2012 12:53 |
janakors
Messages: 232 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 #540602 is a reply to message #540599] |
Tue, 24 January 2012 13:11 |
janakors
Messages: 232 Registered: September 2009
|
Senior Member |
|
|
Michel Cadot wrote on Tue, 24 January 2012 13:04Mahesh Rajendran wrote on Tue, 24 January 2012 19:31Quote:The listener supports no services
but why then it work for other scripts? they connect successfully?
??
Regards
janakors
|
|
|
|
|
|