[INS-00001] unknown irrecoverable error during database creation

The below error was found during database creation:
[INS-00001] unknown irrecoverable error

error description: I was trying to install the database from a remote ORACLE software source to local VM.
as the network was very slow so it was throwing some internal error as above

Solution: copy the software to local locatio and try to install from there.

recovering standby database from incremental SCN from primary

One of my standby database was out of sync for 15 days and we didn't have our archivelogs to recover it, so i had followed the below steps to recover it by taking a incremental backup from primary

Step1

=======

Find the difference in SCN from primary Database and standby database.

---------

primary

---------

SQL> select NAME,CURRENT_SCN from v$database;

NAME      CURRENT_SCN

--------- -----------

ORCL     15819959

----------

standby

----------

SQL> select NAME,CURRENT_SCN from v$database;

NAME      CURRENT_SCN

--------- -----------

ORCL     11281979

step2

======

Take a incremental backup from primary database form the required SCN number as below , move and catalog the backups at standby database

-----------------------------

Incremental backup at primary

------------------------------

[oracle@subhen_prim07 backup_ORCL]$ pwd

/oracle/app/backup_ORCL

[oracle@subhen_prim07 backup_ORCL]$ echo $ORACLE_SID

ORCL1

[oracle@subhen_prim07 backup_ORCL]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 11 17:30:29 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1213379060)

RMAN> BACKUP DEVICE TYPE DISK INCREMENTAL FROM SCN 11281979 DATABASE FORMAT '/oracle/app/backup_ORCL/bkupsby_%U';

Starting backup at 11-JAN-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=6 instance=ORCL1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=71 instance=ORCL1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=137 instance=ORCL1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=203 instance=ORCL1 device type=DISK

backup will be obsolete on date 18-JAN-13

archived logs will not be kept or backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00017 name=+DATA/ORCL/datafile/wcccontts.1446.799932363

input datafile file number=00005 name=+DATA/ORCL/datafile/undotbs2.1388.799870311

input datafile file number=00004 name=+DATA/ORCL/datafile/users.1381.799870137

input datafile file number=00010 name=+DATA/ORCL/datafile/nwcont_ias_discuss.1439.799930727

channel ORA_DISK_1: starting piece 1 at 11-JAN-13

channel ORA_DISK_2: starting compressed full datafile backup set

channel ORA_DISK_2: specifying datafile(s) in backup set

input datafile file number=00016 name=+DATA/ORCL/datafile/wcpcontts.1445.799932339

input datafile file number=00003 name=+DATA/ORCL/datafile/undotbs1.1380.799870137

input datafile file number=00009 name=+DATA/ORCL/datafile/nwcont_ias_portlet.1438.799930725

channel ORA_DISK_2: starting piece 1 at 11-JAN-13

channel ORA_DISK_3: starting compressed full datafile backup set

channel ORA_DISK_3: specifying datafile(s) in backup set

input datafile file number=00002 name=+DATA/ORCL/datafile/sysaux.1379.799870137

input datafile file number=00014 name=+DATA/ORCL/datafile/nwcont_urmserver.1443.799930741

input datafile file number=00015 name=+DATA/ORCL/datafile/nwcont_ipm.1444.799930747

input datafile file number=00011 name=+DATA/ORCL/datafile/nwcont_ocssearch.1440.799930729

input datafile file number=00008 name=+DATA/ORCL/datafile/nwcont_orairm.1437.799930725

channel ORA_DISK_3: starting piece 1 at 11-JAN-13

channel ORA_DISK_4: starting compressed full datafile backup set

channel ORA_DISK_4: specifying datafile(s) in backup set

input datafile file number=00001 name=+DATA/ORCL/datafile/system.1378.799870137

input datafile file number=00012 name=+DATA/ORCL/datafile/nwcont_ias_activity.1441.799930729

input datafile file number=00013 name=+DATA/ORCL/datafile/nwcont_ocs.1442.799930735

input datafile file number=00007 name=+DATA/ORCL/datafile/nwcont_ias_webcenter.1436.799930721

input datafile file number=00006 name=+DATA/ORCL/datafile/nwcont_mds.1435.799930719

channel ORA_DISK_4: starting piece 1 at 11-JAN-13

channel ORA_DISK_1: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1 tag=TAG20130111T173046 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16

channel ORA_DISK_2: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1 tag=TAG20130111T173046 comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 00:00:16

channel ORA_DISK_4: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1 tag=TAG20130111T173046 comment=NONE

channel ORA_DISK_4: backup set complete, elapsed time: 00:00:15

channel ORA_DISK_3: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1 tag=TAG20130111T173046 comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 00:00:36

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

backup will be obsolete on date 18-JAN-13

archived logs will not be kept or backed up

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 11-JAN-13

channel ORA_DISK_1: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/bkupsby_ksnv5ore_1_1 tag=TAG20130111T173046 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 11-JAN-13

--------------------------------------

catalog backup pieces at standby site

--------------------------------------

[oracle@subhen_sby07 backup_ORCL]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 11 17:46:10 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1213379060, not open)

RMAN> catalog start with '/oracle/app/backup_ORCL/';

using target database control file instead of recovery catalog

searching for all files that match the pattern /oracle/app/backup_ORCL/

List of Files Unknown to the Database

=====================================

File Name: /oracle/app/backup_ORCL/bkupsby_ksnv5ore_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1

File Name: /oracle/app/backup_ORCL/forstandbyctrl.bck

File Name: /oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done

List of Cataloged Files

=======================

File Name: /oracle/app/backup_ORCL/bkupsby_ksnv5ore_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1

File Name: /oracle/app/backup_ORCL/forstandbyctrl.bck

File Name: /oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1

File Name: /oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1

Step3

==========

Do the recover of the standby database

------------------------

recover standby database

------------------------

RMAN> recover database noredo;

Starting recover at 11-JAN-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=518 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=582 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=645 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=710 instance=ORCLSBY1 device type=DISK

channel ORA_DISK_1: starting incremental datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: +DATA/ORCLSBY/datafile/system.1253.800020585

destination for restore of datafile 00006: +DATA/ORCLSBY/datafile/nwcont_mds.1261.800020819

destination for restore of datafile 00007: +DATA/ORCLSBY/datafile/nwcont_ias_webcenter.1258.800020741

destination for restore of datafile 00012: +DATA/ORCLSBY/datafile/nwcont_ias_activity.1255.800020655

destination for restore of datafile 00013: +DATA/ORCLSBY/datafile/nwcont_ocs.1257.800020717

channel ORA_DISK_1: reading from backup piece /oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1

channel ORA_DISK_2: starting incremental datafile backup set restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: +DATA/ORCLSBY/datafile/sysaux.1254.800020621

destination for restore of datafile 00008: +DATA/ORCLSBY/datafile/nwcont_orairm.1262.800020835

destination for restore of datafile 00011: +DATA/ORCLSBY/datafile/nwcont_ocssearch.1260.800020793

destination for restore of datafile 00014: +DATA/ORCLSBY/datafile/nwcont_urmserver.1256.800020681

destination for restore of datafile 00015: +DATA/ORCLSBY/datafile/nwcont_ipm.1259.800020767

channel ORA_DISK_2: reading from backup piece /oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1

channel ORA_DISK_3: starting incremental datafile backup set restore

channel ORA_DISK_3: specifying datafile(s) to restore from backup set

destination for restore of datafile 00003: +DATA/ORCLSBY/datafile/undotbs1.1264.800020865

destination for restore of datafile 00009: +DATA/ORCLSBY/datafile/nwcont_ias_portlet.1266.800020875

destination for restore of datafile 00016: +DATA/ORCLSBY/datafile/wcpcontts.1251.800020377

channel ORA_DISK_3: reading from backup piece /oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1

channel ORA_DISK_4: starting incremental datafile backup set restore

channel ORA_DISK_4: specifying datafile(s) to restore from backup set

destination for restore of datafile 00004: +DATA/ORCLSBY/datafile/users.1267.800020883

destination for restore of datafile 00005: +DATA/ORCLSBY/datafile/undotbs2.1265.800020873

destination for restore of datafile 00010: +DATA/ORCLSBY/datafile/nwcont_ias_discuss.1263.800020849

destination for restore of datafile 00017: +DATA/ORCLSBY/datafile/wcccontts.1252.800020481

channel ORA_DISK_4: reading from backup piece /oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 01/11/2013 17:48:00

ORA-19870: error while restoring backup piece /oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1

ORA-19573: cannot obtain exclusive enqueue for datafile 1

--failed because the managed recovery was active for standby database, so cancel the managed recovery first and retry recovery

[oracle@subhen_sby07 backup_ORCL]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 11 17:49:41 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 4175568896 bytes

Fixed Size                  2234960 bytes

Variable Size            2432697776 bytes

Database Buffers         1728053248 bytes

Redo Buffers               12582912 bytes

Database mounted.

SQL> recover managed standby database cancel;

Media recovery complete.

SQL> exit

RMAN> recover database noredo;

Starting recover at 11-JAN-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=515 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=579 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=643 instance=ORCLSBY1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=708 instance=ORCLSBY1 device type=DISK

channel ORA_DISK_1: starting incremental datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: +DATA/ORCLSBY/datafile/system.1253.800020585

destination for restore of datafile 00006: +DATA/ORCLSBY/datafile/nwcont_mds.1261.800020819

destination for restore of datafile 00007: +DATA/ORCLSBY/datafile/nwcont_ias_webcenter.1258.800020741

destination for restore of datafile 00012: +DATA/ORCLSBY/datafile/nwcont_ias_activity.1255.800020655

destination for restore of datafile 00013: +DATA/ORCLSBY/datafile/nwcont_ocs.1257.800020717

channel ORA_DISK_1: reading from backup piece /oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1

channel ORA_DISK_2: starting incremental datafile backup set restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: +DATA/ORCLSBY/datafile/sysaux.1254.800020621

destination for restore of datafile 00008: +DATA/ORCLSBY/datafile/nwcont_orairm.1262.800020835

destination for restore of datafile 00011: +DATA/ORCLSBY/datafile/nwcont_ocssearch.1260.800020793

destination for restore of datafile 00014: +DATA/ORCLSBY/datafile/nwcont_urmserver.1256.800020681

destination for restore of datafile 00015: +DATA/ORCLSBY/datafile/nwcont_ipm.1259.800020767

channel ORA_DISK_2: reading from backup piece /oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1

channel ORA_DISK_3: starting incremental datafile backup set restore

channel ORA_DISK_3: specifying datafile(s) to restore from backup set

destination for restore of datafile 00003: +DATA/ORCLSBY/datafile/undotbs1.1264.800020865

destination for restore of datafile 00009: +DATA/ORCLSBY/datafile/nwcont_ias_portlet.1266.800020875

destination for restore of datafile 00016: +DATA/ORCLSBY/datafile/wcpcontts.1251.800020377

channel ORA_DISK_3: reading from backup piece /oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1

channel ORA_DISK_4: starting incremental datafile backup set restore

channel ORA_DISK_4: specifying datafile(s) to restore from backup set

destination for restore of datafile 00004: +DATA/ORCLSBY/datafile/users.1267.800020883

destination for restore of datafile 00005: +DATA/ORCLSBY/datafile/undotbs2.1265.800020873

destination for restore of datafile 00010: +DATA/ORCLSBY/datafile/nwcont_ias_discuss.1263.800020849

destination for restore of datafile 00017: +DATA/ORCLSBY/datafile/wcccontts.1252.800020481

channel ORA_DISK_4: reading from backup piece /oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1

channel ORA_DISK_1: piece handle=/oracle/app/backup_ORCL/bkupsby_krnv5oqb_1_1 tag=TAG20130111T173046

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:07

channel ORA_DISK_4: piece handle=/oracle/app/backup_ORCL/bkupsby_konv5oq9_1_1 tag=TAG20130111T173046

channel ORA_DISK_4: restored backup piece 1

channel ORA_DISK_4: restore complete, elapsed time: 00:00:07

channel ORA_DISK_3: piece handle=/oracle/app/backup_ORCL/bkupsby_kpnv5oqa_1_1 tag=TAG20130111T173046

channel ORA_DISK_3: restored backup piece 1

channel ORA_DISK_3: restore complete, elapsed time: 00:00:15

channel ORA_DISK_2: piece handle=/oracle/app/backup_ORCL/bkupsby_kqnv5oqa_1_1 tag=TAG20130111T173046

channel ORA_DISK_2: restored backup piece 1

channel ORA_DISK_2: restore complete, elapsed time: 00:00:55

Finished recover at 11-JAN-13

-- start the managed recovery in standby database again

[recover managed standby database cancel;]

[alter database recover managed standby database using current logfile disconnect from session;]

here in the alert log of standby we will find still it is looking for older archivelogs this is due to the control file is still the older one. so we will restore the standby controlfile from primary

-- backup standby control file from primary

RMAN> backup device type disk current controlfile for standby format '/oracle/app/backup_ORCL/forstandbyctrl.bck';

Starting backup at 11-JAN-13

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

channel ORA_DISK_1: starting compressed full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including standby control file in backup set

channel ORA_DISK_1: starting piece 1 at 11-JAN-13

channel ORA_DISK_1: finished piece 1 at 11-JAN-13

piece handle=/oracle/app/backup_ORCL/forstandbyctrl.bck tag=TAG20130111T173139 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 11-JAN-13

Starting Control File and SPFILE Autobackup at 11-JAN-13

piece handle=+BACKUP/ORCL/autobackup/2013_01_11/s_804447105.6477.804447105 comment=NONE

Finished Control File and SPFILE Autobackup at 11-JAN-13

-- move and catalog the controlfile in standby and restore the controlfile

RMAN> restore standby controlfile from '/oracle/app/backup_ORCL/forstandbyctrl.bck';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/05/2013 14:49:30
RMAN-06496: must use the TO clause when the database is mounted or open

-- put the standby database in nomount mode and try again

[oracle@subhen_sby01 backup_ORCL]$ srvctl stop database -d ORCLB -o immediate
[oracle@subhen_sby01 backup_pptnwaut]$ echo $ORACLE_SID
ORCLB2
[oracle@subhen_sby01 backup_pptnwaut]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Mar 5 14:53:21 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 3140026368 bytes
Fixed Size                  2232472 bytes
Variable Size             788533096 bytes
Database Buffers         2332033024 bytes
Redo Buffers               17227776 bytes

-- restore again
RMAN> restore standby controlfile from '/oracle/app/backup_ORCL/forstandbyctrl.bck';

Starting restore at 11-JAN-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=899 instance=ORCLSBY1 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=+DATA/ORCLSBY/controlfile/current.1250.800020347

output file name=+FRA/ORCLSBY/controlfile/current.102570.800020347

Finished restore at 11-JAN-13

RMAN> sql 'alter database mount';

sql statement: alter database mount

released channel: ORA_DISK_1

-- try the managed recovery again, here we might find the below error in alert log of standby due to datafile mismatch so use the alter database file rename command

[match the file id from primary database(v$datafile) and standby database (v$datafile)]

Managed Standby Recovery starting Real Time Apply

Fri Jan 11 18:06:38 2013

Errors in file /oracle/app/diag/rdbms/ORCLSBY/ORCLSBY1/trace/ORCLSBY1_dbw0_16388.trc:

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: '+DATA/ORCL/datafile/system.1378.799870137'

ORA-17503: ksfdopn:2 Failed to open file +DATA/ORCL/datafile/system.1378.799870137

ORA-15012: ASM file '+DATA/ORCL/datafile/system.1378.799870137' does not exist

Errors in file /oracle/app/diag/rdbms/ORCLSBY/ORCLSBY1/trace/ORCLSBY1_dbw0_16388.trc:

-- rename file at standby database

[before that make standby_file_management to manual after rename complete change the parameter again to auto]

SQL> alter system set standby_file_management=MANUAL scope=both sid='*';

SQL> alter database rename  file '+DATA/ORCL/datafile/sysaux.1379.799870137' to '+DATA/ORCLSBY/DATAFILE/SYSAUX.1254.800020621';

Database altered.

SQL> alter system set standby_file_management=AUTO scope=both sid='*';

-- shutdown and restart standby database in mount state and check for archive_log_dest parameters and enable managed recovery again

SQL> shu immediate

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,

OLAP, Data Mining, Oracle Database Vault and Real Application Testing options

[oracle@subhen_sby07 backup_ORCL]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 11 18:29:28 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area 4175568896 bytes

Fixed Size                  2234960 bytes

Variable Size            2449474992 bytes

Database Buffers         1711276032 bytes

Redo Buffers               12582912 bytes

Database mounted.

SQL> recover managed standby database cancel;

Media recovery complete.

SQL> alter database recover managed standby database disconnect from session using current logfile;

Database altered.

-- in my case log_archive_dest_3 value was wrongly populated so i disabled that in standby database

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_3                   string      location="USE_DB_RECOVERY_FILE

                                                 _DEST",  valid_for=(STANDBY_LO

                                                 GFILE,STANDBY_ROLE)

SQL> alter system set log_archive_dest_3=' ' scope=both sid='*';

-- finally check the archivelogs from both primary and standby database





========================================
Dataguard broker configuration redo
========================================

After the standby databases back into sync i found that the DG broker configuaration is not working, so i had to redo the configuration these are the steps i followed

[oracle@subhen_prim07 backup_PPTNWAUT]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect /
Connected.
DGMGRL> show configuration

Configuration - ORCLdg

  Protection Mode: MaxAvailability
  Databases:
    ORCL  - Primary database
      Warning: ORA-16809: multiple warnings detected for the database

    ORCLSBY - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

-- disable configuration and remove it

DGMGRL> disable configuration
Disabled.
DGMGRL> remove configuration
Removed configuration

-- login to both primary and standby Database disable broker and remove the broker files from ASM location of both servers

SQL> alter system set dg_broker_start=FALSE scope=both sid='*';

-- recreate the configuration

[oracle@subhen_prim07 backup_PPTNWAUT]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys@ORCL
Password:
Connected.
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL
DGMGRL> create configuration ORCLDG as primary database is 'ORCL' connect identifier is 'ORCL';
Configuration "ORCLdg" created with primary database "ORCL"
DGMGRL> add database 'ORCLSBY' as connect identifier is 'ORCLSBY' maintained as physical;
Database "ORCLSBY" added
DGMGRL> show configuration

Configuration - ORCLdg

  Protection Mode: MaxAvailability
  Databases:
    ORCL  - Primary database
    ORCLSBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration


Configuration - ORCLdg

  Protection Mode: MaxAvailability
  Databases:
    ORCL  - Primary database
    ORCLSBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


DGMGRL> show database verbose 'ORCL';

Database - ORCL

  Role:            PRIMARY
  Intended State:  TRANSPORT-ON
  Instance(s):
    ORCL1
    ORCL2

  Properties:
    DGConnectIdentifier             = 'ORCL'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '+DATA/ORCLSBY, +DATA/ORCL'
    LogFileNameConvert              = '+FRA/ORCLSBY, +FRA/ORCL'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName(*)
    StaticConnectIdentifier(*)
    StandbyArchiveLocation(*)
    AlternateLocation(*)
    LogArchiveTrace(*)
    LogArchiveFormat(*)
    TopWaitEvents(*)
    (*) - Please check specific instance for the property value

Database Status:
SUCCESS

DGMGRL> show database verbose 'ORCLSBY';

Database - ORCLSBY

  Role:            PHYSICAL STANDBY
  Intended State:  APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: OFF
  Instance(s):
    ORCLSBY1

  Properties:
    DGConnectIdentifier             = 'ORCLSBY'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'SYNC'
    DelayMins                       = '0'
    Binding                         = 'OPTIONAL'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'
    NetTimeout                      = '30'
    RedoCompression                 = 'DISABLE'
    LogShipping                     = 'ON'
    PreferredApplyInstance          = ''
    ApplyInstanceTimeout            = '0'
    ApplyParallel                   = 'AUTO'
    StandbyFileManagement           = 'AUTO'
    ArchiveLagTarget                = '0'
    LogArchiveMaxProcesses          = '4'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = '+DATA/ORCLSBY, +DATA/ORCL'
    LogFileNameConvert              = '+FRA/ORCLSBY, +FRA/ORCL'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORCLSBY1'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.12.62.107)(PORT=1621))(CONNECT_DATA=(SERVICE_NAME=ORCLSBY_DGMGRL)(INSTANCE_NAME=ORCLSBY1)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '+BACKUP'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

Duplicate Db creation from 2node RAC to single instance using RMAN(tape restoration)

[oracle@subhen-db01 lib]$ ps -fe|grep pmon|grep -i autode
oracle   28881     1  0  2012 ?        00:02:36 ora_pmon_AUTODEV_1
[oracle@subhen-db01 lib]$ . oraenv
ORACLE_SID = [oracle] ? AUTODEV_1
The Oracle base for ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 is /oracle/app
[oracle@subhen-db01 lib]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 14:19:37 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select sum(bytes)/1024/1024/1024 Gb from dba_segments;

        GB
----------
2.01220703

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@subhen-db01 lib]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 3 14:20:15 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: AUTODEV (DBID=3812261009)

RMAN> run {
2> set command id to 'RMAN_BACKUP_LEVEL0';
allocate channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
allocate channel c2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
3> 4> 5> backup incremental level 0 cumulative database;
6> backup archivelog all not backed up;
7> backup current controlfile;
}8>

executing command: SET COMMAND ID

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=322 instance=AUTODEV_1 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

allocated channel: c2
channel c2: SID=386 instance=AUTODEV_1 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

Starting backup at 03-JAN-13
channel c1: starting incremental level 0 datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA/autodev/datafile/sysaux.3472.799329609
input datafile file number=00005 name=+DATA/autodev/datafile/undotbs2.3481.799329791
input datafile file number=00004 name=+DATA/autodev/datafile/users.3474.799329609
channel c1: starting piece 1 at 03-JAN-13
channel c2: starting incremental level 0 datafile backup set
channel c2: specifying datafile(s) in backup set
input datafile file number=00001 name=+DATA/autodev/datafile/system.3471.799329607
input datafile file number=00006 name=+DATA/autodev/datafile/undotbs3.3482.799329791
input datafile file number=00007 name=+DATA/autodev/datafile/ggate_data.3487.799330815
input datafile file number=00003 name=+DATA/autodev/datafile/undotbs1.3473.799329609
channel c2: starting piece 1 at 03-JAN-13
channel c2: finished piece 1 at 03-JAN-13
piece handle=0bnugald_1_1 tag=TAG20130103T142029 comment=API Version 2.0,MMS Version 5.0.0.0
channel c2: backup set complete, elapsed time: 00:03:55
channel c1: finished piece 1 at 03-JAN-13
piece handle=0anugald_1_1 tag=TAG20130103T142029 comment=API Version 2.0,MMS Version 5.0.0.0
channel c1: backup set complete, elapsed time: 00:11:36
Finished backup at 03-JAN-13

Starting backup at 03-JAN-13
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=3 sequence=23 RECID=50 STAMP=801245796
input archived log thread=1 sequence=13 RECID=52 STAMP=801245800
input archived log thread=2 sequence=16 RECID=51 STAMP=801245799
input archived log thread=3 sequence=24 RECID=55 STAMP=801245859
input archived log thread=2 sequence=17 RECID=54 STAMP=801245859
input archived log thread=1 sequence=14 RECID=53 STAMP=801245856
input archived log thread=1 sequence=15 RECID=57 STAMP=801396916
input archived log thread=2 sequence=18 RECID=56 STAMP=801396916
input archived log thread=3 sequence=25 RECID=63 STAMP=801415284
input archived log thread=2 sequence=19 RECID=58 STAMP=801396916
input archived log thread=1 sequence=16 RECID=60 STAMP=801415279
input archived log thread=3 sequence=26 RECID=59 STAMP=801415278
input archived log thread=1 sequence=17 RECID=61 STAMP=801415279
input archived log thread=3 sequence=27 RECID=65 STAMP=801415286
input archived log thread=1 sequence=18 RECID=62 STAMP=801415283
input archived log thread=1 sequence=19 RECID=64 STAMP=801415284
input archived log thread=3 sequence=28 RECID=67 STAMP=801424146
input archived log thread=2 sequence=20 RECID=68 STAMP=801424147
input archived log thread=1 sequence=20 RECID=66 STAMP=801424146
input archived log thread=1 sequence=21 RECID=69 STAMP=801424147
input archived log thread=3 sequence=29 RECID=73 STAMP=801425615
input archived log thread=2 sequence=21 RECID=71 STAMP=801425609
input archived log thread=1 sequence=22 RECID=70 STAMP=801425609
input archived log thread=1 sequence=23 RECID=72 STAMP=801425610
input archived log thread=2 sequence=22 RECID=75 STAMP=801427557
input archived log thread=3 sequence=30 RECID=74 STAMP=801427557
input archived log thread=3 sequence=31 RECID=76 STAMP=801526600
input archived log thread=2 sequence=23 RECID=80 STAMP=801658725
input archived log thread=1 sequence=24 RECID=77 STAMP=801658724
input archived log thread=3 sequence=32 RECID=78 STAMP=801658724
input archived log thread=3 sequence=33 RECID=79 STAMP=801658725
input archived log thread=1 sequence=25 RECID=82 STAMP=801660582
input archived log thread=2 sequence=24 RECID=84 STAMP=801660582
input archived log thread=3 sequence=34 RECID=81 STAMP=801660540
input archived log thread=3 sequence=35 RECID=83 STAMP=801660582
input archived log thread=1 sequence=26 RECID=86 STAMP=801662278
input archived log thread=2 sequence=25 RECID=87 STAMP=801662278
input archived log thread=3 sequence=36 RECID=85 STAMP=801662272
input archived log thread=3 sequence=37 RECID=88 STAMP=801662279
input archived log thread=1 sequence=27 RECID=90 STAMP=801663161
input archived log thread=2 sequence=26 RECID=92 STAMP=801663195
input archived log thread=3 sequence=38 RECID=89 STAMP=801663156
input archived log thread=3 sequence=39 RECID=91 STAMP=801663167
input archived log thread=2 sequence=27 RECID=94 STAMP=801665559
input archived log thread=1 sequence=28 RECID=95 STAMP=801665559
input archived log thread=3 sequence=40 RECID=93 STAMP=801665557
input archived log thread=3 sequence=41 RECID=96 STAMP=801665592
input archived log thread=2 sequence=28 RECID=97 STAMP=801671815
input archived log thread=1 sequence=29 RECID=101 STAMP=801673614
input archived log thread=3 sequence=42 RECID=99 STAMP=801673612
input archived log thread=2 sequence=29 RECID=98 STAMP=801671817
input archived log thread=2 sequence=30 RECID=100 STAMP=801673614
input archived log thread=2 sequence=31 RECID=102 STAMP=801673614
input archived log thread=1 sequence=30 RECID=104 STAMP=801676957
input archived log thread=3 sequence=43 RECID=103 STAMP=801676955
input archived log thread=3 sequence=44 RECID=106 STAMP=801677302
input archived log thread=1 sequence=31 RECID=108 STAMP=801677321
input archived log thread=2 sequence=32 RECID=105 STAMP=801677301
input archived log thread=2 sequence=33 RECID=107 STAMP=801677311
input archived log thread=1 sequence=32 RECID=110 STAMP=801678761
input archived log thread=3 sequence=45 RECID=112 STAMP=801678765
input archived log thread=2 sequence=34 RECID=109 STAMP=801678744
input archived log thread=2 sequence=35 RECID=111 STAMP=801678761
input archived log thread=1 sequence=33 RECID=116 STAMP=801679762
channel c1: starting piece 1 at 03-JAN-13
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=3 sequence=46 RECID=114 STAMP=801679748
input archived log thread=2 sequence=36 RECID=113 STAMP=801679748
input archived log thread=2 sequence=37 RECID=115 STAMP=801679749
input archived log thread=3 sequence=47 RECID=118 STAMP=801681759
input archived log thread=1 sequence=34 RECID=120 STAMP=801681770
input archived log thread=2 sequence=38 RECID=117 STAMP=801681756
input archived log thread=2 sequence=39 RECID=119 STAMP=801681761
input archived log thread=3 sequence=48 RECID=121 STAMP=801682595
input archived log thread=1 sequence=35 RECID=122 STAMP=801682597
input archived log thread=2 sequence=40 RECID=127 STAMP=801683776
input archived log thread=1 sequence=36 RECID=123 STAMP=801682601
input archived log thread=3 sequence=49 RECID=126 STAMP=801683770
input archived log thread=1 sequence=37 RECID=124 STAMP=801683768
input archived log thread=1 sequence=38 RECID=125 STAMP=801683769
input archived log thread=3 sequence=50 RECID=128 STAMP=801741776
input archived log thread=2 sequence=41 RECID=130 STAMP=801744026
input archived log thread=1 sequence=39 RECID=131 STAMP=801744798
input archived log thread=3 sequence=51 RECID=129 STAMP=801743635
input archived log thread=3 sequence=52 RECID=132 STAMP=801871234
input archived log thread=2 sequence=42 RECID=135 STAMP=802112433
input archived log thread=1 sequence=40 RECID=133 STAMP=802004417
input archived log thread=3 sequence=53 RECID=134 STAMP=802076420
input archived log thread=1 sequence=41 RECID=136 STAMP=802123214
input archived log thread=3 sequence=54 RECID=140 STAMP=802245590
input archived log thread=2 sequence=43 RECID=139 STAMP=802245585
input archived log thread=1 sequence=42 RECID=137 STAMP=802231217
input archived log thread=1 sequence=43 RECID=138 STAMP=802245583
input archived log thread=2 sequence=44 RECID=142 STAMP=802270575
input archived log thread=3 sequence=55 RECID=141 STAMP=802270574
input archived log thread=1 sequence=44 RECID=143 STAMP=802271119
input archived log thread=2 sequence=45 RECID=147 STAMP=802523373
input archived log thread=3 sequence=56 RECID=144 STAMP=802271119
input archived log thread=3 sequence=57 RECID=145 STAMP=802436905
input archived log thread=1 sequence=45 RECID=148 STAMP=802537208
input archived log thread=3 sequence=58 RECID=146 STAMP=802523372
channel c2: starting piece 1 at 03-JAN-13
channel c1: finished piece 1 at 03-JAN-13
piece handle=0cnugbbi_1_1 tag=TAG20130103T143213 comment=API Version 2.0,MMS Version 5.0.0.0
channel c1: backup set complete, elapsed time: 00:08:16
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=3 sequence=59 RECID=153 STAMP=802546776
input archived log thread=2 sequence=46 RECID=150 STAMP=802546771
input archived log thread=1 sequence=46 RECID=149 STAMP=802546768
input archived log thread=1 sequence=47 RECID=151 STAMP=802546775
input archived log thread=2 sequence=47 RECID=152 STAMP=802546775
input archived log thread=3 sequence=60 RECID=156 STAMP=802782650
input archived log thread=1 sequence=48 RECID=157 STAMP=802782650
input archived log thread=2 sequence=48 RECID=154 STAMP=802648864
input archived log thread=2 sequence=49 RECID=155 STAMP=802782649
input archived log thread=2 sequence=50 RECID=158 STAMP=802869112
input archived log thread=1 sequence=49 RECID=161 STAMP=803049292
input archived log thread=3 sequence=61 RECID=160 STAMP=803049291
input archived log thread=2 sequence=51 RECID=159 STAMP=803042024
input archived log thread=2 sequence=52 RECID=164 STAMP=803131785
input archived log thread=3 sequence=62 RECID=162 STAMP=803049296
input archived log thread=1 sequence=50 RECID=163 STAMP=803131784
input archived log thread=3 sequence=63 RECID=171 STAMP=803136537
input archived log thread=1 sequence=51 RECID=165 STAMP=803131786
input archived log thread=2 sequence=53 RECID=166 STAMP=803131788
input archived log thread=1 sequence=52 RECID=168 STAMP=803136532
input archived log thread=2 sequence=54 RECID=167 STAMP=803136532
input archived log thread=2 sequence=55 RECID=170 STAMP=803136533
input archived log thread=1 sequence=53 RECID=169 STAMP=803136533
input archived log thread=3 sequence=64 RECID=174 STAMP=803141022
input archived log thread=1 sequence=54 RECID=173 STAMP=803141022
input archived log thread=2 sequence=56 RECID=172 STAMP=803141017
input archived log thread=2 sequence=57 RECID=175 STAMP=803141022
input archived log thread=3 sequence=65 RECID=176 STAMP=803148561
input archived log thread=1 sequence=55 RECID=177 STAMP=803148563
input archived log thread=1 sequence=56 RECID=178 STAMP=803150460
input archived log thread=3 sequence=66 RECID=179 STAMP=803150460
input archived log thread=3 sequence=67 RECID=180 STAMP=803150461
input archived log thread=1 sequence=57 RECID=181 STAMP=803153012
input archived log thread=2 sequence=58 RECID=183 STAMP=803153019
input archived log thread=3 sequence=68 RECID=182 STAMP=803153016
input archived log thread=3 sequence=69 RECID=184 STAMP=803153041
input archived log thread=1 sequence=58 RECID=186 STAMP=803286018
input archived log thread=2 sequence=59 RECID=187 STAMP=803286018
input archived log thread=3 sequence=70 RECID=185 STAMP=803222503
input archived log thread=3 sequence=71 RECID=188 STAMP=803286019
input archived log thread=3 sequence=72 RECID=189 STAMP=803469489
channel c1: starting piece 1 at 03-JAN-13
channel c2: finished piece 1 at 03-JAN-13
piece handle=0dnugbbj_1_1 tag=TAG20130103T143213 comment=API Version 2.0,MMS Version 5.0.0.0
channel c2: backup set complete, elapsed time: 00:08:42
channel c2: starting archived log backup set
channel c2: specifying archived log(s) in backup set
input archived log thread=1 sequence=59 RECID=193 STAMP=803600292
input archived log thread=2 sequence=60 RECID=192 STAMP=803600289
input archived log thread=3 sequence=73 RECID=190 STAMP=803470438
input archived log thread=3 sequence=74 RECID=191 STAMP=803600289
input archived log thread=3 sequence=75 RECID=194 STAMP=803707212
input archived log thread=2 sequence=61 RECID=196 STAMP=803745130
input archived log thread=1 sequence=60 RECID=197 STAMP=803745133
input archived log thread=3 sequence=76 RECID=195 STAMP=803745128
channel c2: starting piece 1 at 03-JAN-13
channel c2: finished piece 1 at 03-JAN-13
piece handle=0fnugbru_1_1 tag=TAG20130103T143213 comment=API Version 2.0,MMS Version 5.0.0.0
channel c2: backup set complete, elapsed time: 00:01:45
channel c1: finished piece 1 at 03-JAN-13
piece handle=0enugbr3_1_1 tag=TAG20130103T143213 comment=API Version 2.0,MMS Version 5.0.0.0
channel c1: backup set complete, elapsed time: 00:12:10
Finished backup at 03-JAN-13

Starting backup at 03-JAN-13
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
channel c1: starting piece 1 at 03-JAN-13
channel c1: finished piece 1 at 03-JAN-13
piece handle=0gnugci1_1_1 tag=TAG20130103T145249 comment=API Version 2.0,MMS Version 5.0.0.0
channel c1: backup set complete, elapsed time: 00:01:05
Finished backup at 03-JAN-13

Starting Control File and SPFILE Autobackup at 03-JAN-13
piece handle=c-3812261009-20130103-00 comment=API Version 2.0,MMS Version 5.0.0.0
Finished Control File and SPFILE Autobackup at 03-JAN-13
released channel: c1
released channel: c2

RMAN> exit


Recovery Manager complete.
[oracle@subhen-db01 lib]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 15:03:51 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      AUTODEV
SQL> show parameter pfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      +DATA/autodev/spfileautodev
                                                 .ora
SQL> create pfile='/tmp/initAUTODEV.ora' from spfile='+DATA/autodev/spfileautodev.ora';

File created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@subhen-db01 lib]$ cd /tmp
[oracle@subhen-db01 tmp]$ ls -ltr|grep -i initAUTODEV.ora
-rw-r--r-- 1 oracle       oinstall        2561 Jan  3 15:05 initAUTODEV.ora
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ ls -ltr|grep -i init

-rw-r--r-- 1 oracle       oinstall         750 Jan  3 15:11 initAUTODEV.ora
[oracle@subhen-db01 tmp]$ view initSYSNWHDS07DEC.ora
[oracle@subhen-db01 tmp]$ view initSYSNWHDS.ora
[oracle@subhen-db01 tmp]$ view initSYSNWHDS.ora.orig
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ view initSYSNWHDS.ora.orig
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ mkdir
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ mkdir /oracle/app/admin/AUTODEVTP/adump
mkdir: cannot create directory `/oracle/app/admin/AUTODEVTP/adump': No such file or directory
[oracle@subhen-db01 tmp]$ mkdir -p /oracle/app/admin/AUTODEVTP/adump
[oracle@subhen-db01 tmp]$ vi initAUTODEV.ora
[oracle@subhen-db01 tmp]$ export ORACLE_SID=
[oracle@subhen-db01 tmp]$ mv initAUTODEV.ora initAUTODEVTP.ora
[oracle@subhen-db01 tmp]$ view initAUTODEVTP.ora
[oracle@subhen-db01 tmp]$ sleep 2d
^C

[oracle@subhen-db01 tmp]$
[oracle@subhen-db01 tmp]$
[oracle@subhen-db01 tmp]$ export ORACLE_SID=
[oracle@subhen-db01 tmp]$ echo $ORACLE_SID
AUTODEV_1
[oracle@subhen-db01 tmp]$ rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 3 15:38:55 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: AUTODEV (DBID=3812261009)

RMAN> list backup device type sbt_tape;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8       Incr 0  796.50M    SBT_TAPE    00:03:49     03-JAN-13
        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T142029
        Handle: 0bnugald_1_1   Media: X07162
  List of Datafiles in backup set 8
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 12289667   03-JAN-13 +DATA/autodev/datafile/system.3471.799329607
  3    0  Incr 12289667   03-JAN-13 +DATA/autodev/datafile/undotbs1.3473.799329609
  6    0  Incr 12289667   03-JAN-13 +DATA/autodev/datafile/undotbs3.3482.799329791
  7    0  Incr 12289667   03-JAN-13 +DATA/autodev/datafile/ggate_data.3487.799330815

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Incr 0  1.23G      SBT_TAPE    00:11:34     03-JAN-13
        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T142029
        Handle: 0anugald_1_1   Media: X07162
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 12289661   03-JAN-13 +DATA/autodev/datafile/sysaux.3472.799329609
  4    0  Incr 12289661   03-JAN-13 +DATA/autodev/datafile/users.3474.799329609
  5    0  Incr 12289661   03-JAN-13 +DATA/autodev/datafile/undotbs2.3481.799329791

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
10      1.08G      SBT_TAPE    00:08:09     03-JAN-13
        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T143213
        Handle: 0cnugbbi_1_1   Media: X05232

  List of Archived Logs in backup set 10
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    13      4857788    05-DEC-12 4872259    05-DEC-12
  1    14      4872259    05-DEC-12 4872298    05-DEC-12
  1    15      4872298    05-DEC-12 5252806    07-DEC-12
  1    16      5252806    07-DEC-12 5316190    07-DEC-12
  1    17      5316190    07-DEC-12 5316193    07-DEC-12
  1    18      5316193    07-DEC-12 5316195    07-DEC-12
  1    19      5316195    07-DEC-12 5316240    07-DEC-12
  1    20      5327486    07-DEC-12 5361199    07-DEC-12
  1    21      5361199    07-DEC-12 5361217    07-DEC-12
  1    22      5361904    07-DEC-12 5390251    07-DEC-12
  1    23      5390251    07-DEC-12 5390256    07-DEC-12
  1    24      5418312    07-DEC-12 6032322    10-DEC-12
  1    25      6032322    10-DEC-12 6060142    10-DEC-12
  1    26      6060142    10-DEC-12 6085579    10-DEC-12
  1    27      6085579    10-DEC-12 6112564    10-DEC-12
  1    28      6112564    10-DEC-12 6135797    10-DEC-12
  1    29      6135797    10-DEC-12 6203110    10-DEC-12
  1    30      6203110    10-DEC-12 6224091    10-DEC-12
  1    31      6224091    10-DEC-12 6252404    10-DEC-12
  1    32      6252404    10-DEC-12 6280266    10-DEC-12
  1    33      6280266    10-DEC-12 6305244    10-DEC-12
  2    16      4859699    05-DEC-12 4872255    05-DEC-12
  2    17      4872255    05-DEC-12 4872312    05-DEC-12
  2    18      4872312    05-DEC-12 5252795    07-DEC-12
  2    19      5252795    07-DEC-12 5252797    07-DEC-12
  2    20      5316780    07-DEC-12 5361253    07-DEC-12
  2    21      5361253    07-DEC-12 5390260    07-DEC-12
  2    22      5390260    07-DEC-12 5411081    07-DEC-12
  2    23      5411081    07-DEC-12 6032359    10-DEC-12
  2    24      6032359    10-DEC-12 6060162    10-DEC-12
  2    25      6060162    10-DEC-12 6085615    10-DEC-12
  2    26      6085615    10-DEC-12 6112558    10-DEC-12
  2    27      6112558    10-DEC-12 6135793    10-DEC-12
  2    28      6135793    10-DEC-12 6173861    10-DEC-12
  2    29      6173861    10-DEC-12 6173863    10-DEC-12
  2    30      6174833    10-DEC-12 6203098    10-DEC-12
  2    31      6203098    10-DEC-12 6203100    10-DEC-12
  2    32      6228417    10-DEC-12 6252327    10-DEC-12
  2    33      6252327    10-DEC-12 6252332    10-DEC-12
  2    34      6256211    10-DEC-12 6280260    10-DEC-12
  2    35      6280260    10-DEC-12 6280262    10-DEC-12
  3    23      4857784    05-DEC-12 4872251    05-DEC-12
  3    24      4872251    05-DEC-12 4872316    05-DEC-12
  3    25      4872316    05-DEC-12 5295906    07-DEC-12
  3    26      5295906    07-DEC-12 5295908    07-DEC-12
  3    27      5316191    07-DEC-12 5316553    07-DEC-12
  3    28      5316553    07-DEC-12 5361249    07-DEC-12
  3    29      5361249    07-DEC-12 5390274    07-DEC-12
  3    30      5390274    07-DEC-12 5411079    07-DEC-12
  3    31      5411079    07-DEC-12 5695343    08-DEC-12
  3    32      5695343    08-DEC-12 6032239    10-DEC-12
  3    33      6032239    10-DEC-12 6032253    10-DEC-12
  3    34      6034824    10-DEC-12 6060136    10-DEC-12
  3    35      6060136    10-DEC-12 6060139    10-DEC-12
  3    36      6060637    10-DEC-12 6085573    10-DEC-12
  3    37      6085573    10-DEC-12 6085575    10-DEC-12
  3    38      6088849    10-DEC-12 6112552    10-DEC-12
  3    39      6112552    10-DEC-12 6112554    10-DEC-12
  3    40      6114356    10-DEC-12 6135785    10-DEC-12
  3    41      6135785    10-DEC-12 6135790    10-DEC-12
  3    42      6137732    10-DEC-12 6203113    10-DEC-12
  3    43      6203113    10-DEC-12 6224090    10-DEC-12
  3    44      6224090    10-DEC-12 6252407    10-DEC-12
  3    45      6252407    10-DEC-12 6280269    10-DEC-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
11      2.56G      SBT_TAPE    00:08:42     03-JAN-13
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T143213
        Handle: 0dnugbbj_1_1   Media: X04802

  List of Archived Logs in backup set 11
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    34      6305244    10-DEC-12 6333208    10-DEC-12
  1    35      6333208    10-DEC-12 6354655    10-DEC-12
  1    36      6354655    10-DEC-12 6354657    10-DEC-12
  1    37      6355691    10-DEC-12 6377203    10-DEC-12
  1    38      6377203    10-DEC-12 6377205    10-DEC-12
  1    39      6379291    10-DEC-12 6538343    11-DEC-12
  1    40      6539221    11-DEC-12 7332648    14-DEC-12
  1    41      7332648    14-DEC-12 7742277    15-DEC-12
  1    42      7742277    15-DEC-12 8029283    17-DEC-12
  1    43      8029283    17-DEC-12 8074581    17-DEC-12
  1    44      8074581    17-DEC-12 8174438    17-DEC-12
  1    45      8174697    17-DEC-12 8978684    20-DEC-12
  2    36      6280695    10-DEC-12 6305209    10-DEC-12
  2    37      6305209    10-DEC-12 6305211    10-DEC-12
  2    38      6309072    10-DEC-12 6333194    10-DEC-12
  2    39      6333194    10-DEC-12 6333196    10-DEC-12
  2    40      6333859    10-DEC-12 6377212    10-DEC-12
  2    41      6377212    10-DEC-12 6533681    11-DEC-12
  2    42      6534346    11-DEC-12 7715423    15-DEC-12
  2    43      7715423    15-DEC-12 8074580    17-DEC-12
  2    44      8074580    17-DEC-12 8163554    17-DEC-12
  2    45      8163584    17-DEC-12 8935574    20-DEC-12
  3    46      6280269    10-DEC-12 6305215    10-DEC-12
  3    47      6305215    10-DEC-12 6333200    10-DEC-12
  3    48      6333200    10-DEC-12 6354692    10-DEC-12
  3    49      6354692    10-DEC-12 6377209    10-DEC-12
  3    50      6377209    10-DEC-12 6522788    11-DEC-12
  3    51      6524891    11-DEC-12 6529567    11-DEC-12
  3    52      6529690    11-DEC-12 6940482    12-DEC-12
  3    53      6940482    12-DEC-12 7576269    15-DEC-12
  3    54      7576269    15-DEC-12 8074580    17-DEC-12
  3    55      8074580    17-DEC-12 8163559    17-DEC-12
  3    56      8163724    17-DEC-12 8174465    17-DEC-12
  3    57      8174500    17-DEC-12 8643483    19-DEC-12
  3    58      8643483    19-DEC-12 8935080    20-DEC-12

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
12      1.14G      SBT_TAPE    00:01:39     03-JAN-13
        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T143213
        Handle: 0fnugbru_1_1   Media: X05232

  List of Archived Logs in backup set 12
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    59      11139791   29-DEC-12 11925804   01-JAN-13
  1    60      11925804   01-JAN-13 12290449   03-JAN-13
  2    60      11140218   29-DEC-12 11923278   01-JAN-13
  2    61      11923278   01-JAN-13 12290445   03-JAN-13
  3    73      11460110   30-DEC-12 11551372   31-DEC-12
  3    74      11551372   31-DEC-12 11922457   01-JAN-13
  3    75      11922457   01-JAN-13 12204105   03-JAN-13
  3    76      12204105   03-JAN-13 12290441   03-JAN-13

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
13      2.58G      SBT_TAPE    00:12:09     03-JAN-13
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T143213
        Handle: 0enugbr3_1_1   Media: X04802

  List of Archived Logs in backup set 13
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    46      8978684    20-DEC-12 9022218    20-DEC-12
  1    47      9022218    20-DEC-12 9022220    20-DEC-12
  1    48      9022230    20-DEC-12 9669485    23-DEC-12
  1    49      9669485    23-DEC-12 10397133   26-DEC-12
  1    50      10397133   26-DEC-12 10616566   27-DEC-12
  1    51      10616566   27-DEC-12 10616568   27-DEC-12
  1    52      10616669   27-DEC-12 10656305   27-DEC-12
  1    53      10656305   27-DEC-12 10656307   27-DEC-12
  1    54      10656398   27-DEC-12 10694946   27-DEC-12
  1    55      10694946   27-DEC-12 10725017   27-DEC-12
  1    56      10725017   27-DEC-12 10755207   27-DEC-12
  1    57      10755207   27-DEC-12 10792353   27-DEC-12
  1    58      10792353   27-DEC-12 11139791   29-DEC-12
  2    46      8935574    20-DEC-12 9022220    20-DEC-12
  2    47      9022220    20-DEC-12 9022222    20-DEC-12
  2    48      9027222    20-DEC-12 9301954    21-DEC-12
  2    49      9301954    21-DEC-12 9667806    23-DEC-12
  2    50      9667806    23-DEC-12 9900985    24-DEC-12
  2    51      9900985    24-DEC-12 10348572   26-DEC-12
  2    52      10348572   26-DEC-12 10616569   27-DEC-12
  2    53      10616569   27-DEC-12 10616571   27-DEC-12
  2    54      10621489   27-DEC-12 10656303   27-DEC-12
  2    55      10656303   27-DEC-12 10656305   27-DEC-12
  2    56      10660838   27-DEC-12 10694921   27-DEC-12
  2    57      10694921   27-DEC-12 10694923   27-DEC-12
  2    58      10755252   27-DEC-12 10792357   27-DEC-12
  2    59      10792357   27-DEC-12 11140218   29-DEC-12
  3    59      8935080    20-DEC-12 9022226    20-DEC-12
  3    60      9022226    20-DEC-12 9670004    23-DEC-12
  3    61      9670004    23-DEC-12 10397070   26-DEC-12
  3    62      10397070   26-DEC-12 10397076   26-DEC-12
  3    63      10397812   26-DEC-12 10656316   27-DEC-12
  3    64      10656316   27-DEC-12 10694942   27-DEC-12
  3    65      10694942   27-DEC-12 10725018   27-DEC-12
  3    66      10725018   27-DEC-12 10755206   27-DEC-12
  3    67      10755206   27-DEC-12 10755781   27-DEC-12
  3    68      10760924   27-DEC-12 10792305   27-DEC-12
  3    69      10792305   27-DEC-12 10792338   27-DEC-12
  3    70      10793626   27-DEC-12 10959718   28-DEC-12
  3    71      10959718   28-DEC-12 11138744   29-DEC-12
  3    72      11138744   29-DEC-12 11460110   30-DEC-12

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    22.75M     SBT_TAPE    00:00:58     03-JAN-13
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T145249
        Handle: 0gnugci1_1_1   Media: X06790
  Control File Included: Ckp SCN: 12291827     Ckp time: 03-JAN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
15      Full    22.75M     SBT_TAPE    00:01:09     03-JAN-13
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20130103T145355
        Handle: c-3812261009-20130103-00   Media: X03223
  SPFILE Included: Modification time: 27-DEC-12
  SPFILE db_unique_name: AUTODEV
  Control File Included: Ckp SCN: 12291907     Ckp time: 03-JAN-13

RMAN> exit


Recovery Manager complete.
[oracle@subhen-db01 tmp]$ view initAUTODEVTP.ora
[oracle@subhen-db01 tmp]$ cat initAUTODEVTP.ora
*.audit_file_dest='/oracle/app/admin/AUTODEVTP/adump'
*.audit_trail='db'
*.cluster_database=false
*.compatible='11.2.0.0.0'
*.control_files='+DATA/autodevtp/controlfile/current.3475.799329681','+FRA/autodevtp/controlfile/current.6090.799329683'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_name='AUTODEVTP'
*.db_recovery_file_dest='+FRA'
*.db_recovery_file_dest_size=5G
*.diagnostic_dest='/oracle/app'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=AUTODEVTPXDB)'
*.log_archive_format='%t_%s_%r.dbf'
*.memory_max_target=4G
*.open_cursors=500
*.pga_aggregate_target=1G
*.processes=500
*.remote_listener='subhen-dbscan.espdev.aurdev.national.com.au:1621'
*.remote_login_passwordfile='exclusive'
*.utl_file_dir='/tmp/'
DB_FILE_NAME_CONVERT='AUTODEV','AUTODEVTP'
LOG_FILE_NAME_CONVERT='AUTODEV','AUTODEVTP'

[oracle@subhen-db01 tmp]$ export ORACLE_SID=AUTODEVTP
[oracle@subhen-db01 tmp]$ free -g
             total       used       free     shared    buffers     cached
Mem:           189        186          3          0          0        149
-/+ buffers/cache:         36        152
Swap:            1          0          1
[oracle@subhen-db01 tmp]$ cat initAUTODEVTP.ora
[oracle@subhen-db01 tmp]$ export ORACLE_SID=AUTODEVTP
[oracle@subhen-db01 tmp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 15:41:46 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount='/tmp/initAUTODEVTP.ora';
SP2-0714: invalid combination of STARTUP options
SQL> startup nomount pfile='/tmp/initAUTODEVTP.ora'
ORA-01127: database name 'AUTODEVTP' exceeds size limit of 8 characters
SQL> exit
Disconnected
[oracle@subhen-db01 tmp]$ vi initAUTODEVTP.ora
[oracle@subhen-db01 tmp]$ mv initAUTODEVTP.ora initAUTODEVT.ora
[oracle@subhen-db01 tmp]$ export ORACLE_SID=
[oracle@subhen-db01 tmp]$ vi initAUTODEVT.ora
[oracle@subhen-db01 tmp]$ mkdir -p /oracle/app/admin/AUTODEVT/adump
[oracle@subhen-db01 tmp]$ vi initAUTODEVT.ora
[oracle@subhen-db01 tmp]$ export ORACLE_SID=AUTODEVT
[oracle@subhen-db01 tmp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 15:44:56 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/tmp/initAUTODEVT.ora'
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2235208 bytes
Variable Size            4160750776 bytes
Database Buffers          100663296 bytes
Redo Buffers               12132352 bytes
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

[oracle@subhen-db01 tmp]$ rman target sys/sw2tesb@AUTODEV auxiliary /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 3 15:46:29 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: AUTODEV (DBID=3812261009)
connected to auxiliary database: AUTODEVT (not mounted)

RMAN> run {
allocate channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
2> 3> allocate channel c2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
4> set until SCN 12291827;
DUPLICATE TARGET DATABASE TO AUTODEVT;
5> 6> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1474 instance=AUTODEV_1 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

allocated channel: c2
channel c2: SID=131 instance=AUTODEV_1 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

executing command: SET until clause

Starting Duplicate Db at 03-JAN-13
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/03/2013 15:49:43
RMAN-05501: aborting duplication of target database
RMAN-05503: at least one auxiliary channel must be allocated to execute this command

RMAN> run {
allocate auxiliary channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
2> 3> allocate auxiliary channel c2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
4> set until SCN 12291827;
5> DUPLICATE TARGET DATABASE TO AUTODEVT;
6> }

allocated channel: c1
channel c1: SID=200 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

allocated channel: c2
channel c2: SID=332 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

executing command: SET until clause

Starting Duplicate Db at 03-JAN-13
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/03/2013 15:54:07
RMAN-05501: aborting duplication of target database
RMAN-06457: UNTIL SCN (12291827) is ahead of last SCN in archived logs (12290441)

RMAN> run {
allocate auxiliary channel c1 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
2> 3> allocate auxiliary channel c2 type 'SBT_TAPE' parms 'ENV=(NB_ORA_CLASS=t3-***-**-***-3m-2, NB_ORA_SERV=*****.au.thenational.com, NB_ORA_SCHED=oracle)';
4> DUPLICATE TARGET DATABASE TO AUTODEVT;
5> }

allocated channel: c1
channel c1: SID=200 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

allocated channel: c2
channel c2: SID=332 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

Starting Duplicate Db at 03-JAN-13

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes
Variable Size               4160750776 bytes
Database Buffers             100663296 bytes
Redo Buffers                  12132352 bytes
allocated channel: c1
channel c1: SID=299 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
allocated channel: c2
channel c2: SID=332 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

contents of Memory Script:
{
   sql clone "alter system set  control_files =
  ''+DATA/autodevt/controlfile/current.3792.803750133'', ''+FRA/autodevt/controlfile/current.10014.803750133'' comment=
 ''Set by RMAN'' scope=spfile";
   sql clone "alter system set  db_name =
 ''AUTODEV'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''AUTODEVT'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  control_files =   ''+DATA/autodevt/controlfile/current.3792.803750133'', ''+FRA/autodevt/controlfile/current.10014.803750133'' comment= ''Set by RMAN'' scope=spfile

sql statement: alter system set  db_name =  ''AUTODEV'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''AUTODEVT'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes
Variable Size               4160750776 bytes
Database Buffers             100663296 bytes
Redo Buffers                  12132352 bytes
allocated channel: c1
channel c1: SID=299 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
allocated channel: c2
channel c2: SID=332 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)

Starting restore at 03-JAN-13

channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece c-3812261009-20130103-00
channel c1: piece handle=c-3812261009-20130103-00 tag=TAG20130103T145355
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:56
output file name=+DATA/autodevt/controlfile/current.3792.803750133
output file name=+FRA/autodevt/controlfile/current.10014.803750133
Finished restore at 03-JAN-13

database mounted
RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.

contents of Memory Script:
{
   set until scn  12290441;
   set newname for datafile  1 to
 "+DATA";
   set newname for datafile  2 to
 "+DATA";
   set newname for datafile  3 to
 "+DATA";
   set newname for datafile  4 to
 "+DATA";
   set newname for datafile  5 to
 "+DATA";
   set newname for datafile  6 to
 "+DATA";
   set newname for datafile  7 to
 "+DATA";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 03-JAN-13

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to +DATA
channel c1: restoring datafile 00003 to +DATA
channel c1: restoring datafile 00006 to +DATA
channel c1: restoring datafile 00007 to +DATA
channel c1: reading from backup piece 0bnugald_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00002 to +DATA
channel c2: restoring datafile 00004 to +DATA
channel c2: restoring datafile 00005 to +DATA
channel c2: reading from backup piece 0anugald_1_1
channel c1: piece handle=0bnugald_1_1 tag=TAG20130103T142029
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:05:36
channel c2: piece handle=0anugald_1_1 tag=TAG20130103T142029
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:06:36
Finished restore at 03-JAN-13

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=803750719 file name=+DATA/autodevt/datafile/system.3791.803750611
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=803750720 file name=+DATA/autodevt/datafile/sysaux.3787.803750665
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=803750720 file name=+DATA/autodevt/datafile/undotbs1.3788.803750611
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=803750720 file name=+DATA/autodevt/datafile/users.3785.803750667
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=803750720 file name=+DATA/autodevt/datafile/undotbs2.3786.803750665
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=803750720 file name=+DATA/autodevt/datafile/undotbs3.3790.803750611
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=803750720 file name=+DATA/autodevt/datafile/ggate_data.3789.803750611

contents of Memory Script:
{
   set until scn  12290441;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 03-JAN-13

starting media recovery

archived log for thread 1 with sequence 60 is already on disk as file +FRA/autodev/archivelog/2013_01_03/thread_1_seq_60.3760.803745131
archived log for thread 2 with sequence 61 is already on disk as file +FRA/autodev/archivelog/2013_01_03/thread_2_seq_61.17198.803745129
archived log for thread 3 with sequence 76 is already on disk as file +FRA/autodev/archivelog/2013_01_03/thread_3_seq_76.3399.803745129
archived log file name=+FRA/autodev/archivelog/2013_01_03/thread_3_seq_76.3399.803745129 thread=3 sequence=76
archived log file name=+FRA/autodev/archivelog/2013_01_03/thread_1_seq_60.3760.803745131 thread=1 sequence=60
archived log file name=+FRA/autodev/archivelog/2013_01_03/thread_2_seq_61.17198.803745129 thread=2 sequence=61
media recovery complete, elapsed time: 00:00:02
Finished recover at 03-JAN-13
Oracle instance started

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes
Variable Size               4160750776 bytes
Database Buffers             100663296 bytes
Redo Buffers                  12132352 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''AUTODEVT'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''AUTODEVT'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area    4275781632 bytes

Fixed Size                     2235208 bytes
Variable Size               4160750776 bytes
Database Buffers             100663296 bytes
Redo Buffers                  12132352 bytes
allocated channel: c1
channel c1: SID=299 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
allocated channel: c2
channel c2: SID=332 device type=SBT_TAPE
channel c2: Veritas NetBackup for Oracle - Release 6.5 (2010042404)
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "AUTODEVT" RESETLOGS ARCHIVELOG
  MAXLOGFILES   1000
  MAXLOGMEMBERS      5
  MAXDATAFILES     1024
  MAXINSTANCES    32
  MAXLOGHISTORY      292
 LOGFILE
  GROUP   1 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE,
  GROUP   2 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE,
  GROUP   7 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE,
  GROUP   8 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE
 DATAFILE
  '+DATA/autodevt/datafile/system.3791.803750611'
 CHARACTER SET AL32UTF8

sql statement: ALTER DATABASE ADD LOGFILE



  INSTANCE 'i2'
  GROUP   3 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE,
  GROUP   4 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE
sql statement: ALTER DATABASE ADD LOGFILE




  INSTANCE 'i3'
  GROUP   5 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE,
  GROUP   6 ( '+DATA', '+FRA' ) SIZE 256 M  REUSE

contents of Memory Script:
{
   set newname for tempfile  1 to
 "+DATA";
   switch clone tempfile all;
   catalog clone datafilecopy  "+DATA/autodevt/datafile/sysaux.3787.803750665",
 "+DATA/autodevt/datafile/undotbs1.3788.803750611",
 "+DATA/autodevt/datafile/users.3785.803750667",
 "+DATA/autodevt/datafile/undotbs2.3786.803750665",
 "+DATA/autodevt/datafile/undotbs3.3790.803750611",
 "+DATA/autodevt/datafile/ggate_data.3789.803750611";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +DATA in control file

cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/sysaux.3787.803750665 RECID=1 STAMP=803750767
cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/undotbs1.3788.803750611 RECID=2 STAMP=803750767
cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/users.3785.803750667 RECID=3 STAMP=803750767
cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/undotbs2.3786.803750665 RECID=4 STAMP=803750767
cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/undotbs3.3790.803750611 RECID=5 STAMP=803750767
cataloged datafile copy
datafile copy file name=+DATA/autodevt/datafile/ggate_data.3789.803750611 RECID=6 STAMP=803750768

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=803750767 file name=+DATA/autodevt/datafile/sysaux.3787.803750665
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=803750767 file name=+DATA/autodevt/datafile/undotbs1.3788.803750611
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=803750767 file name=+DATA/autodevt/datafile/users.3785.803750667
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=803750767 file name=+DATA/autodevt/datafile/undotbs2.3786.803750665
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=803750767 file name=+DATA/autodevt/datafile/undotbs3.3790.803750611
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=803750768 file name=+DATA/autodevt/datafile/ggate_data.3789.803750611

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 03-JAN-13
released channel: c1
released channel: c2

RMAN> exit


Recovery Manager complete.
[oracle@subhen-db01 tmp]$ ls -ltr|grep pmon|grep -i auto
[oracle@subhen-db01 tmp]$ ps -ef|grep pmon|grep -i auto
oracle   23269     1  0 16:05 ?        00:00:00 ora_pmon_AUTODEVT
oracle   28881     1  0  2012 ?        00:02:38 ora_pmon_AUTODEV_1
[oracle@subhen-db01 tmp]$ . oraenv
ORACLE_SID = [AUTODEVT] ?
ORACLE_HOME = [/home/oracle] ? ^C
[oracle@subhen-db01 tmp]$ cat /etc/oratab|grep -i AUTODEV
AUTODEV_1:/oracle/app/database/11.2.0.3/dbhome_1:N              # line added by Agent
AUTODEV:/oracle/app/database/11.2.0.3/dbhome_1:N                # line added by Agent
[oracle@subhen-db01 tmp]$ . oraenv
ORACLE_SID = [AUTODEVT] ?
ORACLE_HOME = [/home/oracle] ? /oracle/app/database/11.2.0.3/dbhome_1
The Oracle base for ORACLE_HOME=/oracle/app/database/11.2.0.3/dbhome_1 is /oracle/app
[oracle@subhen-db01 tmp]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 3 16:59:42 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> select name,open_mode,database_role from v$database;

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
AUTODEVT  READ WRITE           PRIMARY

SQL>


To convert this single instance DB to RAC Db please follow the steps in my below post in my blog

Duplicate database creation from 2 node RAC to 2 node RAC in same host