RMAN-10003: unable to connect to target database

Recently one of the scheduled RMAN backup started failing, with following error stack.

RMAN> RUN
{
BACKUP AS BACKUPSET DEVICE TYPE SBT_TAPE
INCREMENTAL LEVEL=1 TAG ‘<TAG NAME>’ DATABASE;
}
Starting backup at 11/14/2011 01:25:18
using target database control file instead of recovery catalog
RMAN-00571: =================================================
RMAN-00569: ===== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: =================================================
RMAN-03002: failure of backup command at 11/14/2011 01:25:19
RMAN-12001: could not open channel ORA_SBT_TAPE_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied

After investigation found that, one of the DBA’s recreated the password file but did not change the channel configuration. Once the problem was narrowed down, it was a pretty straight forward fix.

RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE SBT_TAPE CLEAR;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE SBT_TAPE CLEAR;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE ‘SBT_TAPE’
CONNECT ‘sys/<pwd>’ FORMAT ‘%n_%I_%T_s%s_p%p_c%c’
PARMS ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;

RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE ‘SBT_TAPE’
CONNECT ‘sys/<pwd>’ FORMAT ‘%n_%I_%T_s%s_p%p_c%c’
PARMS ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;

Later the script executed without any errors.

RMAN> RUN
{
BACKUP AS BACKUPSET DEVICE TYPE SBT_TAPE
INCREMENTAL LEVEL=1 TAG ‘<TAG NAME>’ DATABASE;
}
Starting backup at 11/14/2011 01:35:58
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=22 instance=test01 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protection for Oracle: version 5.5.2.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=1530 instance=test01 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Data Protection for Oracle: version 5.5.2.0
channel ORA_SBT_TAPE_1: starting incremental level 1 datafile backup set
channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
…………….
…………….
…………….
…………….
channel ORA_SBT_TAPE_1: starting piece 1 at 11/14/2011 01:37:10
channel ORA_SBT_TAPE_1: finished piece 1 at 11/14/2011 01:37:25
piece handle=testxxx_xxxxxxxxx_zzzzzzzzzz_s2839_p1_c1 tag=<TAG NAME> comment=API Version 2.0,MMS Version 5.5.2.0
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
channel ORA_SBT_TAPE_2: finished piece 1 at 11/14/2011 01:39:25
piece handle=testxxx_xxxxxxxxx_zzzzzzzzzz_s2838_p1_c1 tag=<TAG NAME> comment=API Version 2.0,MMS Version 5.5.2.0
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:30
Finished backup at 11/14/2011 01:39:25
Starting Control File and SPFILE Autobackup at 11/14/2011 01:39:26
piece handle=testxxx_Fc-xxxxxxxxx_zzzzzzzzzz-00 comment=API Version 2.0,MMS Version 5.5.2.0
Finished Control File and SPFILE Autobackup at 11/14/2011 01:39:33
Advertisements
This entry was posted in Oracle Database Backup, Oracle Recovery Manager and tagged , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s