So I'm trying to run a duplicate database with RMAN and having some trouble getting it to work.
Platform: (Target Database) Node A: PRD RH Linux 4 Oracle 9.2.0.6 Veritas client 5.1 Oracle owner: oraprod (Auxiliary Instance) Node B: DEV RH Linux 4 Oracle 9.2.0.6 Veritas client 5.1 Oracle owner: oradev Veritas Master Server: Windows 2003, Veritas 5.1 MP5 Here is what is not working: Login to RMAN: $ORACLE_HOME/bin/rman target nbu/[EMAIL PROTECTED] auxiliary / nocatalog Run duplicate script: The ENV variables are set to the values used when the backup was created on Node A. run { allocate auxiliary channel clone_db_2 device type 'sbt' parms="ENV=(NB_ORA_CLIENT=PRD,NB_ORA_POLICY=ORA_PRD_full,NB_ORA_SERV=nbu_server,NB_ORA_SCHED=Daily-Full)"; set newname for datafile 1 to '/u01/oracle/dev/devdata/dbf/prod_system_01.dbf'; ... set newname for datafile 46 to '/u01/oracle/dev/devdata/dbf/sysdba01.dbf'; set until time "to_date('05/05/2007 12:00:00','mm/dd/yyyy hh24:mi:ss')"; DUPLICATE TARGET DATABASE TO DEV LOGFILE GROUP 1 ... SIZE 20M; } The syntax of the script is fine - no parsing errors occur. Unnecessary bits have been edited out for conciseness. Output: connected to target database: PROD (DBID=15620415) using target database controlfile instead of recovery catalog connected to auxiliary database: DEV (not mounted) RMAN> RMAN> RMAN> run { 2> 3> 4> 5> 6> allocate auxiliary channel clone_db_2 device type 'sbt' 7> parms="ENV=(NB_ORA_CLIENT=PRD,NB_ORA_POLICY=ORA_PRD_full,NB_ORA_SERV=nbu_server,NB_ORA_SCHED=Daily-Full)"; 8> 9> set newname for datafile 1 to '/u01/oracle/dev/devdata/dbf/prod_system_01.dbf'; ... 54> set newname for datafile 46 to '/u01/oracle/dev/devdata/dbf/sysdba01.dbf'; 55> 56> set until time "to_date('05/05/2007 12:00:00','mm/dd/yyyy hh24:mi:ss')"; 57> 58> DUPLICATE TARGET DATABASE TO DEV 59> LOGFILE 60> GROUP 1 61> ( ... 74> ) SIZE 20M; 75> 76> } allocated channel: clone_db_2 channel clone_db_2: sid=11 devtype=SBT_TAPE channel clone_db_2: VERITAS NetBackup for Oracle - Release 5.1 (2006040520) executing command: SET NEWNAME ... executing command: SET until clause Starting Duplicate Db at 08-MAY-07 printing stored script: Memory Script { set until scn 2000109207; set newname for datafile 1 to "/u01/oracle/dev/devdata/dbf/prod_system_01.dbf"; set newname for datafile 2 to ... "/u01/oracle/dev/devdata/dbf/noetix_views_01.dbf"; set newname for datafile 46 to "/u01/oracle/dev/devdata/dbf/sysdba01.dbf"; restore check readonly clone database ; } executing script: Memory Script executing command: SET until clause ... executing command: SET NEWNAME Starting restore at 08-MAY-07 channel clone_db_2: starting datafile backupset restore channel clone_db_2: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/oracle/dev/devdata/dbf/prod_system_01.dbf ... restoring datafile 00046 to /u01/oracle/dev/devdata/dbf/sysdba01.dbf released channel: clone_db_2 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 05/08/2007 14:52:13 RMAN-03015: error occurred in stored script Memory Script ORA-19507: failed to retrieve sequential file, handle="bk_PROD_u77igrh59_s1255_p1_t621659305", parms="" ORA-27029: skgfrtrv: sbtrestore returned error ORA-19511: Error received from media manager layer, error text: Backup file <bk_PROD_u77igrh59_s1255_p1_t621659305> not found in NetBackup catalog RMAN> RMAN> **end-of-file** This problem seems to be an evironment or permissions problem. The auxiliary node can browse the backups from the target node via the netbackup command 'bplist', so the netbackup backup catalog is visible for backups from other nodes. The file that is shown as not found in the backup catalog is indeed there, and can be seen as per previous comments about bplist. A straight restore of the DEV database was initiated to ensure that the communications from Node B to the NetBackup server were functioning properly. Running the job from Node A ( owner of the backup files) gets the same results. I have successfully run done similar database duplicate jobs, the difference being that the duplicate database was on the same node. Several notes on MetaLink, Veritas support site, and googling have yielded a number of things to check, but no help. So, if you have some insights into this issue, please feel free to share. Thanks, -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist
_______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu