RE: TSM/TDP backup of rman database nocatalog
- From: <Peter.Hitchman@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Sep 2005 09:32:53 +0100
Hi,
Since tdposync wants a rman catalog I assumed it would not work, I did some
Googling and found that this was confirmed by others but no solution to my
problem. Well I suppose when it asks for the connection information I could try
giving it the target database and see what happens. I'll update later.
Regards
Pete
-----Original Message-----
From: Marquez, Chris [mailto:cmarquez@xxxxxxxxxxxxxxxx]
Sent: 06 September 2005 16:42
To: Hitchman, Peter (TS UK); oracle-l@xxxxxxxxxxxxx
Subject: RE: TSM/TDP backup of rman database nocatalog
Peter,
"tdposync syncdb -tdpo_optfile=..."
These are my personal notes...I used it all the time.
The only (big) thing I am not sure about is that TDPO db wants to connect to an
Oracle db to complete this process...normally that would be the RMAN Catalog db
(you do not have)...could try connecting to the target db instead?
hth
Chris Marquez
Oracle DBA
====================================================
IBM-AIX - Tivoli
Procedure to SYNC Orphaned TDPO Backups (of RMAN-Oracle Data) by Tivoli:
====================================================
1.) Gather List of TDPO Backups Orphaned Tivoli TSM.
====================================================
====================================================
2.) Check RMAN Catalog For Backups Missing by Tivoli.
====================================================
---CONFIRM RMAN CATALOG IS HAS NO INFORMATION ON THE DELETED BACKUPS
---THIS SHOULD REALLY BE COMPLETED *BEFORE* A BACKUP IS REMOVED FROM TIVOLI!
SQLPLUS rman/RmAn_PaSsWoRd@rmandb
SQL>
select
b.NAME,
a.COMPLETION_TIME,
a.MEDIA,
a.STATUS,
a.HANDLE
from
rc_backup_piece a,
rc_database b
where a.DB_KEY = b.DB_KEY
--and HANDLE like 'MGTPROD2_arch_v%'
and HANDLE in
('orcl_arch_qsfr9rq4_1_1.bkp,13189659','orcl_arch_qtfr9rq4_1_1.bkp,13062045','orcl_arch_qufr9rv1_1_1.bkp,13189660','orcl_arch_r0frhta2_1_1.bkp,13189661','orcl_arch_r1frhta2_1_1.bkp,13062046','orcl_arch_r2frhtnm_1_1.bkp,13189662','orcl_arch_r3frhtoh_1_1.bkp,13062047','orcl_arch_r4frhu69_1_1.bkp,13062048','orcl_arch_rpfrig30_1_1.bkp,13398701','orcl_arch_rqfrig30_1_1.bkp,13062049','orcl_arch_rrfrig8a_1_1.bkp,13062050')
order by b.NAME, a.COMPLETION_TIME, a.STATUS
/
====================================================
3.) Set OS Environment.
====================================================
---SET OS USER ENVIRONMENT TO USE ORACLE EXECUTABLE (SQLPLUS).
oracle@a004 in /home/oracle : ORACLE_BASE=/a0004/app/oracle export ORACLE_BASE
oracle@a004 in /home/oracle : ORACLE_HOME=/a0004/app/oracle/product/817 export
ORACLE_HOME
oracle@a004 in /home/oracle : LD_LIBRARY_PATH=/a0004/app/oracle/product/817/lib
export LD_LIBRARY_PATH
oracle@a004 in /home/oracle : PATH=$PATH:$ORACLE_HOME/bin
a006:-(orcl6)-:/a0006/oracle/> env | grep ORACLE_BASE
ORACLE_BASE=/a0006/oracle
a006:-(orcl6)-:/a0006/oracle/> env | grep ORACLE_HOME
ORACLE_HOME=/a0006/oracle/product/920
a006:-(orcl6)-:/a0006/oracle/> env | grep LD_LIBRARY_PATH
LD_LIBRARY_PATH=/usr/dt/lib:/usr/lib/X11:/usr/lib:/usr/ccs/lib:/a0006/oracle/product/920/lib
a006:-(orcl6)-:/a0006/oracle/> env | grep PATH
PATH=/a0006/oracle/product/920/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java130/jre/bin:/usr/java130/bin:/usr/local/bin:/usr/dt/bin:/usr/ccs/bin:.:/a0006/oracle
a006:-(orcl6)-:/a0006/oracle/> env | grep SID
ORACLE_SID=orcl6
====================================================
4.) Run Tivoli "tdposync syncdb" FOR EVERY DATABASE
====================================================
---BEGIN TIVOLI-RMAN SYNCING PROCESS
---REQUIRES ORACLE RMAN CATALOG SCHEMA ID, PASSWORD, SQLNET CONNECTION, TDPO
CLIENT SIDE "tdpo.opt" FILE.
---REQUIRES THE USE OF DATABASE SPECIFIC "tdpo.opt" FILE *IF* UNIQUE "TDPO_FS"
ARE USED FOR EACH DATABASE AS RECOMMENDED BY TIVOLI).
---8i
oracle@a004 in /home/oracle : tdposync syncdb
-tdpo_optfile=/a0002/app/oracle/tivoli/cororcl_tdpo.opt
Catalog 1 User Name: rman
Catalog 1 Password: RmAn_PaSsWoRd
Catalog 1 Connect String: rmandb
From Date (mm/dd/yy): 01/01/2002
To Date (mm/dd/yy): 09/30/2002
Tivoli Data Protection for Oracle
Synchronize utility PICK Window
Node Name: NSORA
Owner Name: nsora
Backup Date Size Backup Name
---------------------------------------------------------------------------------------------------------------------------------------------------------
1. | 05/09/02 10:40:17 5,581.00MB
/tstexm8i//TSTEXM8I_81do180f_1_1.bkp
...
<U>=Up <D>=Down <T>=Top <B>=Bottom <R#>=Right <L#>=Left
<G#>=Goto Line # <#>=Toggle Entry <+>=Select All <->=Deselect All
<#:#+>=Select A Range <#:#->=Deselect A Range <O>=Ok <C>=Cancel
pick> OK
You are about to delete data from the TSM Server, this operation is
irreversible. Do you wish to continue? (Yes (Y)/No (N)) Y
The TSM Server is Synchronized with the Oracle Catalog or there are no matching
files in the requested filespace.
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Oct 25 12:06:55 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit
Production
With the Partitioning option
JServer Release 8.1.7.3.0 - 64bit Production
Gathering Catalog information...Please wait
The TSM Server is Synchronized with the Oracle Catalog or there
are no matching files in the requested filespace.
---9i
a006:-(orcl6)-:/a0006/oracle/> tdposync syncdb
-tdpo_optfile=/a0006/app/oracle/tivoli/orcl_tdpo.opt
IBM Tivoli Storage Manager for Databases:
Data Protection for Oracle Version 5, Release 2, Level 0.0 (C) Copyright IBM
Corporation 1997, 2003. All rights reserved.
Catalog 1 User Name: rman
Catalog 1 Password: RmAn_PaSsWoRd
Catalog 1 Connect String: rmandb.world
From Date (mm/dd/yy): 01/01/04
To Date (mm/dd/yy): 09/23/04
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Sep 23 12:23:21 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
IBM Tivoli Storage Manager for Databases
Synchronize utility PICK Window
Node Name: o006
Owner Name: o006
Backup Date Size Backup Name
---------------------------------------------------------------------------------------------------------------------
x 1. | 07/23/04 02:53:59 457.00MB
/dba9i//orcl_arch_rpfrig30_1_1.bkp
x 2. | 07/22/04 21:44:21 6,390.00MB
/dba9i//orcl_arch_r2frhtnm_1_1.bkp
x 3. | 07/22/04 21:38:36 11.55GB
/dba9i//orcl_arch_r0frhta2_1_1.bkp
x 4. | 07/19/04 20:21:53 1,024.00KB
/dba9i//orcl_arch_qufr9rv1_1_1.bkp
x 5. | 07/19/04 20:19:37 2,667.00MB
/dba9i//orcl_arch_qsfr9rq4_1_1.bkp
x 6. | 09/21/04 03:17:49 507.00MB
/dba9i//orcl_arch_c8g0go2q_1_1.bkp
x 7. | 09/20/04 21:51:52 10.84GB
/dba9i//orcl_arch_bhg0g4vh_1_1.bkp
x 8. | 09/20/04 21:31:55 10.42GB
/dba9i//orcl_arch_bdg0g3q8_1_1.bkp
x 9. | 09/17/04 03:23:58 973.00MB
/dba9i//orcl_arch_bag066u9_1_1.bkp
|
0---------10--------20--------30--------40--------50--------60--------70--------80--------90--------100------110-----
<U>=Up <D>=Down <T>=Top <B>=Bottom <R#>=Right <L#>=Left
<G#>=Goto Line # <#>=Toggle Entry <+>=Select All <->=Deselect All
<#:#+>=Select A Range <#:#->=Deselect A Range <O>=Ok <C>=Cancel
pick> O
You are about to delete data from the TSM Server, this
operation is irreversible. Do you wish to continue? (Yes (Y)/No (N)) Yes
The TSM Server is Synchronized with the Oracle Catalog or there
are no matching files in the requested filespace.
====================================================
5.) Check RMAN Catalog For Backups Missing by Tivoli.
====================================================
---CONFIRM RMAN CATALOG IS HAS NO INFORMATION ON THE DELETED BACKUPS
---THIS SHOULD REALLY BE COMPLETED *BEFORE* A BACKUP IS REMOVED FROM TIVOLI!
SQLPLUS rman/RmAn_PaSsWoRd@rmandb
SQL>
select
b.NAME,
a.COMPLETION_TIME,
a.MEDIA,
a.STATUS,
a.HANDLE
from
rc_backup_piece a,
rc_database b
where a.DB_KEY = b.DB_KEY
and HANDLE in
('5TSTEXM8I_81do180f_1_1.bkp%')
order by b.NAME, a.COMPLETION_TIME, a.STATUS
/
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Peter.Hitchman@xxxxxxxxxxx
Sent: Tue 9/6/2005 11:31 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: TSM/TDP backup of rman database nocatalog
Hi,
I have backups using Tivoli TDP for Oracle of my rman catalog database. My
problem is that I now have files in a filespace that are no longer referenced
by the rman database controlfile and I do not know how to delete them. Does
anybody know how I can remove the entries in TSM?
Regards
Pete
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
