Database Backup and Recovery (MOSC)

MOSC Banner

Duplicate fails with RMAN-06729

edited Feb 23, 2017 8:28AM in Database Backup and Recovery (MOSC) 4 commentsAnswered ✓

Hi guys,

I am trying to create a StandBy database through duplicate command (Backup-based duplication without a target connection). But the script fails with these errors:

RMAN-06026: some targets not found - aborting restore 
RMAN-06729: no backup of the SPFILE found to restore 


The duplicate script is:

export ORACLE_SID=DUPLIX
export ORACLE_HOME=/u01/app/oracle/product/11G

$ORACLE_HOME/bin/sqlplus / as sysdba <<EOF
  STARTUP NOMOUNT PFILE='/u01/app/oracle/product/11G/dbs/initDUPLIX.ora';
EOF




$ORACLE_HOME/bin/rman auxiliary / catalog rman/rm2n@CATALOGO DEBUG trace=/tmp/debug_rman_21102014.log <<EOF
run {
  allocate auxiliary channel d1 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d2 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d3 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d4 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d5 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d6 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d7 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  allocate auxiliary channel d8 device type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
  DUPLICATE DATABASE 'PROD_SID' DBID 3431116671 FOR STANDBY
  SPFILE
    SET db_unique_name='DUPLIX'
   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center