Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TSM/TDP backup of rman database nocatalog

RE: TSM/TDP backup of rman database nocatalog

From: <Peter.Hitchman_at_thomson.com>
Date: Wed, 7 Sep 2005 09:32:53 +0100
Message-ID: <3D730671F3FB8C4EA73FD2E94A11F9472D8A3E@tshuklonmbx02.ERF.THOMSON.COM> 





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_at_collegeboard.org]
Sent: 06 September 2005 16:42


To: Hitchman, Peter (TS UK); oracle-l_at_freelists.org
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_at_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_at_a004 in /home/oracle : ORACLE_BASE=/a0004/app/oracle export ORACLE_BASE
oracle_at_a004 in /home/oracle : ORACLE_HOME=/a0004/app/oracle/product/817 export ORACLE_HOME
oracle_at_a004 in /home/oracle : LD_LIBRARY_PATH=/a0004/app/oracle/product/817/lib export LD_LIBRARY_PATH
oracle_at_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_at_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_at_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_at_freelists.org on behalf of Peter.Hitchman_at_thomson.com
Sent: Tue 9/6/2005 11:31 AM


To: oracle-l_at_freelists.org


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


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Sep 07 2005 - 03:34:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US