RMAN Backup Script with TSM Env setting

connect target /
connect catalog catuse/catuser@rmancatlogdb
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 180 DAYS;
run {
allocate channel c3 type 'SBT_TAPE' parms 'ENV=(TDPO_OPTFILE=C:\Program Files\tivoli\TSM\AgentOBA\tdpo_dbname.opt)';
backup database format 'DB_%d_%s_%p_%t' include current controlfile filesperset 12;
sql 'alter system archive log current';
change archivelog all crosscheck;
backup archivelog all format 'AL_%d_%s_%p_%t' filesperset 32;
backup current controlfile format '%d_%T_%t_%s_%p.ctl';
release channel c3;
}

TSM RMAN Backup Implementation & dircetory permissions issue.

TSM Implementation

We have started implementing RMAN Backup with Tivoli Storage Manager.
Things were set, TSM Client installation was done, TDPO file also was created and we have tried to run a test backup but backup fails with below error.

RMAN-03009: failure of allocate command on c1 channel at 01/23/2011
11:12:42
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
Linux-x86_64 Error: 106: Transport endpoint is already connected
Additional information: 7011
ORA-19511: Error received from media manager layer, error text:
SBT error = 7011, errno = 106, sbtopen: system error


Solution :

Wile trying to run backup TSM Client tries to update to file tdpoerror.log for which the “ORACLE” user need to have read Wright access to below location.

/usr/tivoli/tms/client/oracle/bin64/

Or

/opt/Tivoli/tms/client/oracle/bin64/

After oracle user have read write access to oracle for TSM client installation path.

Upgrade database 10.2.0.1 to 10.2.0.4 with 32 bit to 64 bit conversion

Upgrade database 10.2.0.1 to 10.2.0.4 with 32 bit to 64 bit conversion

While consolidating the database servers we had to move a database from 10.2.0.1 to 10.2.0.4 home. Here we have taken cold backup of the database on the source server and copied to target server and tried to upgrade resulted in below error, as the source database was in 32bit and target database home was in 64bit.

Error Message:

No errors.
CREATE OR REPLACE FUNCTION version_script
*
ERROR at line 1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [56319]


Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Reason:

The reason was we are upgrading a database from 10.2.0.1 32 Bit home to 10.2.0.4 64 Bit home. Oracle bit upgrade 32bit database 64 bit is not automatic.

Solution :

There is one more script to be executed before we run catupgrd.sql.
There are two ways.
1. run the script utlip.sql as below

a. sqlplus > @?/rdbms/admin/utlip.sql

2. Uncomment the below line in catupgrd.sql script
vi catupgrd.sql change:
==> @@&utlip_file
to:==> @@utlip.sql

and run catupgrd.sql
3. SQL> @?/rdbms/admin/catupgrd.sql

This should solve the issue.

In active.. It been a long time ther is no post on the blog

In active.. It been a long time there is no post on the blog

was bit busy.. will keep posting here after..