I hit the error when using RMAN duplicate command to create a physical standby database, with purpose of using same directory structure in two boxes. Hence, I commented
#DB_FILE_NAME_CONVERT='/u01/oradata/DG/','/u01/oradata/DGS/'
#LOG_FILE_NAME_CONVERT= '/u01/oradata/DG/','/u01/oradata/DGS/'
orarac2poc:DGS:/u01/app/oracle/product/11.2.0/db_2/dbs> cat initDGS.ora
#DG.__db_cache_size=427819008
#DG.__java_pool_size=4194304
#DG.__large_pool_size=4194304
#DG.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
#DG.__pga_aggregate_target=209715200
#DG.__sga_target=683671552
#DG.__shared_io_pool_size=0
#DG.__shared_pool_size=230686720
#DG.__streams_pool_size=4194304
*.audit_file_dest='/u01/app/oracle/admin/DGS/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.db_block_size=8192
*.db_domain=''
#*.db_recovery_file_dest='/u01/oradata/DGS/FRA'
*.db_recovery_file_dest='/u01/oradata/DG/FRA'
*.db_recovery_file_dest_size=5218762752
*.diagnostic_dest='/u01/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=DGPXDB)'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=DGXDB)'
*.open_cursors=300
*.pga_aggregate_target=209715200
*.processes=150
*.sga_target=681574400
*.undo_tablespace='UNDOTBS1'
#Initialization Parameters for a Physical Standby Database
DB_NAME=DG
DB_UNIQUE_NAME=DGS
LOG_ARCHIVE_CONFIG='DG_CONFIG=(DG,DGS)'
*.control_files='/u01/oradata/DG/control01.ctl','/u01/oradata/DG/FRA/DG/control02.ctl'
#DB_FILE_NAME_CONVERT='DG','DGS'
#LOG_FILE_NAME_CONVERT='DG','DGS'
#DB_FILE_NAME_CONVERT='/u01/oradata/DG/','/u01/oradata/DGS/'
#LOG_FILE_NAME_CONVERT= '/u01/oradata/DG/','/u01/oradata/DGS/'
*.log_archive_format='DG_%t_%s_%r.arc'
LOG_ARCHIVE_DEST_1= 'LOCATION=/u01/oradata/DG/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=DGS'
LOG_ARCHIVE_DEST_2= 'SERVICE=DG ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DG'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
STANDBY_FILE_MANAGEMENT=AUTO
FAL_SERVER=DG
orarac1poc:DG:/home/oracle> rman target sys/oracle123@DG auxiliary sys/oracle123@DGS
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Jan 3 17:03:36 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DG (DBID=1716975309)
connected to auxiliary database: DG (not mounted)
RMAN> run {
2> allocate auxiliary channel stby type disk;
3> allocate channel prmy1 type disk;
4> duplicate target database for standby from active database;
5> }
using target database control file instead of recovery catalog
allocated channel: stby
channel stby: SID=12 device type=DISK
allocated channel: prmy1
channel prmy1: SID=35 device type=DISK
Starting Duplicate Db at 03-JAN-13
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDG' auxiliary format
'/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDGS' ;
}
executing Memory Script
Starting backup at 03-JAN-13
Finished backup at 03-JAN-13
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/oradata/DG/control01.ctl';
restore clone controlfile to '/u01/oradata/DG/FRA/DG/control02.ctl' from
'/u01/oradata/DG/control01.ctl';
}
executing Memory Script
Starting backup at 03-JAN-13
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f tag=TAG20130103T170400 RECID=7 STAMP=803754240
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 03-JAN-13
Starting restore at 03-JAN-13
channel stby: copied control file copy
Finished restore at 03-JAN-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
released channel: stby
released channel: prmy1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/03/2013 17:04:08
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/oradata/DG/DG1_tbs03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/dg1_tbs02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/DG1_tbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/system01.dbf conflicts with a file used by the target database
RMAN> exit
Recovery Manager complete.
I thought It was caused by previous RMAN DUPLCIATE failure, so I restart physical standby. but my guess wrong.
SYS@DGS> startup nomount
ORACLE instance started.
Total System Global Area 680607744 bytes
Fixed Size 2229600 bytes
Variable Size 197135008 bytes
Database Buffers 473956352 bytes
Redo Buffers 7286784 bytes
SYS@DGS> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SYS@DGS> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SYS@DGS> startup nomount
ORACLE instance started.
Total System Global Area 680607744 bytes
Fixed Size 2229600 bytes
Variable Size 197135008 bytes
Database Buffers 473956352 bytes
Redo Buffers 7286784 bytes
orarac1poc:DG:/home/oracle> rman target sys/oracle123@DG auxiliary sys/oracle123@DGS
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Jan 3 17:03:36 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DG (DBID=1716975309)
connected to auxiliary database: DG (not mounted)
RMAN> run {
2> allocate auxiliary channel stby type disk;
3> allocate channel prmy1 type disk;
4> duplicate target database for standby from active database;
5> }
using target database control file instead of recovery catalog
allocated channel: stby
channel stby: SID=12 device type=DISK
allocated channel: prmy1
channel prmy1: SID=35 device type=DISK
Starting Duplicate Db at 03-JAN-13
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDG' auxiliary format
'/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDGS' ;
}
executing Memory Script
Starting backup at 03-JAN-13
Finished backup at 03-JAN-13
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/oradata/DG/control01.ctl';
restore clone controlfile to '/u01/oradata/DG/FRA/DG/control02.ctl' from
'/u01/oradata/DG/control01.ctl';
}
executing Memory Script
Starting backup at 03-JAN-13
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f tag=TAG20130103T170400 RECID=7 STAMP=803754240
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 03-JAN-13
Starting restore at 03-JAN-13
channel stby: copied control file copy
Finished restore at 03-JAN-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
released channel: stby
released channel: prmy1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/03/2013 17:04:08
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary file name /u01/oradata/DG/DG1_tbs03.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/dg1_tbs02.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/DG1_tbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/users01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/undotbs01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/sysaux01.dbf conflicts with a file used by the target database
RMAN-05001: auxiliary file name /u01/oradata/DG/system01.dbf conflicts with a file used by the target database
RMAN> exit
Recovery Manager complete.
orarac1poc:DG:/home/oracle> oerr rman 5001
5001, 1, "auxiliary file name %s conflicts with a file used by the target database"
// *Cause: RMAN is attempting to use the specified file name as a restore
// destination in the auxiliary database, but this name is already
// in use by the target database.
// *Action: Use the CONFIGURE AUXNAME command to specify a name for the data
// file that does not conflict with a file name in use by the
// target db.
Then I googled and realized need to use NOFILENAMECHECK option from "Thread: RMAN-05001 - RMAN-03002 | Duplicating Database fails | Redo-Logs "
orarac1poc:DG:/home/oracle> rman target sys/oracle123@DG auxiliary sys/oracle123@DGS
Recovery Manager: Release 11.2.0.2.0 - Production on Thu Jan 3 17:12:15 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DG (DBID=1716975309)
connected to auxiliary database: DG (not mounted)
RMAN> run {
2> allocate channel prmy1 type disk;
3> allocate auxiliary channel stby type disk;
4> duplicate target database for standby from active database NOFILENAMECHECK;
5> }
using target database control file instead of recovery catalog
allocated channel: prmy1
channel prmy1: SID=172 device type=DISK
allocated channel: stby
channel stby: SID=13 device type=DISK
Starting Duplicate Db at 03-JAN-13
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDG' auxiliary format
'/u01/app/oracle/product/11.2.0/db_2/dbs/orapwDGS' ;
}
executing Memory Script
Starting backup at 03-JAN-13
Finished backup at 03-JAN-13
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format '/u01/oradata/DG/control01.ctl';
restore clone controlfile to '/u01/oradata/DG/FRA/DG/control02.ctl' from
'/u01/oradata/DG/control01.ctl';
}
executing Memory Script
Starting backup at 03-JAN-13
channel prmy1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/11.2.0/db_2/dbs/snapcf_DG.f tag=TAG20130103T171246 RECID=9 STAMP=803754767
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 03-JAN-13
Starting restore at 03-JAN-13
channel stby: copied control file copy
Finished restore at 03-JAN-13
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/oradata/DG/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/oradata/DG/system01.dbf";
set newname for datafile 2 to
"/u01/oradata/DG/sysaux01.dbf";
set newname for datafile 3 to
"/u01/oradata/DG/undotbs01.dbf";
set newname for datafile 4 to
"/u01/oradata/DG/users01.dbf";
set newname for datafile 5 to
"/u01/oradata/DG/DG1_tbs01.dbf";
set newname for datafile 6 to
"/u01/oradata/DG/dg1_tbs02.dbf";
set newname for datafile 7 to
"/u01/oradata/DG/DG1_tbs03.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/u01/oradata/DG/system01.dbf" datafile
2 auxiliary format
"/u01/oradata/DG/sysaux01.dbf" datafile
3 auxiliary format
"/u01/oradata/DG/undotbs01.dbf" datafile
4 auxiliary format
"/u01/oradata/DG/users01.dbf" datafile
5 auxiliary format
"/u01/oradata/DG/DG1_tbs01.dbf" datafile
6 auxiliary format
"/u01/oradata/DG/dg1_tbs02.dbf" datafile
7 auxiliary format
"/u01/oradata/DG/DG1_tbs03.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/oradata/DG/temp01.dbf in control file
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 backup at 03-JAN-13
channel prmy1: starting datafile copy
input datafile file number=00001 name=/u01/oradata/DG/system01.dbf
output file name=/u01/oradata/DG/system01.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:15
channel prmy1: starting datafile copy
input datafile file number=00002 name=/u01/oradata/DG/sysaux01.dbf
output file name=/u01/oradata/DG/sysaux01.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:25
channel prmy1: starting datafile copy
input datafile file number=00003 name=/u01/oradata/DG/undotbs01.dbf
output file name=/u01/oradata/DG/undotbs01.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:15
channel prmy1: starting datafile copy
input datafile file number=00005 name=/u01/oradata/DG/DG1_tbs01.dbf
output file name=/u01/oradata/DG/DG1_tbs01.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:01
channel prmy1: starting datafile copy
input datafile file number=00006 name=/u01/oradata/DG/dg1_tbs02.dbf
output file name=/u01/oradata/DG/dg1_tbs02.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:01
channel prmy1: starting datafile copy
input datafile file number=00007 name=/u01/oradata/DG/DG1_tbs03.dbf
output file name=/u01/oradata/DG/DG1_tbs03.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:01
channel prmy1: starting datafile copy
input datafile file number=00004 name=/u01/oradata/DG/users01.dbf
output file name=/u01/oradata/DG/users01.dbf tag=TAG20130103T171254
channel prmy1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 03-JAN-13
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=9 STAMP=803754835 file name=/u01/oradata/DG/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=10 STAMP=803754835 file name=/u01/oradata/DG/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=803754835 file name=/u01/oradata/DG/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=803754836 file name=/u01/oradata/DG/users01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=803754836 file name=/u01/oradata/DG/DG1_tbs01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=14 STAMP=803754836 file name=/u01/oradata/DG/dg1_tbs02.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=15 STAMP=803754836 file name=/u01/oradata/DG/DG1_tbs03.dbf
Finished Duplicate Db at 03-JAN-13
released channel: prmy1
released channel: stby
--after duplication, I checked files in physical standby node
orarac2poc:DGS:/u01/oradata/DG> ls -l
total 1716424
drwxr-xr-x 2 oracle oinstall 4096 Jan 3 16:55 arch
-rw-r----- 1 oracle asmadmin 9912320 Jan 3 17:14 control01.ctl
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 DG1_tbs01.dbf
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 dg1_tbs02.dbf
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 DG1_tbs03.dbf
drwxr-xr-x 4 oracle oinstall 4096 Jan 3 17:13 FRA
-rw-r----- 1 oracle asmadmin 629153792 Jan 3 17:13 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Jan 3 17:13 system01.dbf
-rw-r----- 1 oracle asmadmin 346038272 Jan 3 17:13 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Jan 3 17:13 users01.dbf
orarac2poc:DGS:/u01/oradata/DG> ls -lR
.:
total 1716424
drwxr-xr-x 2 oracle oinstall 4096 Jan 3 16:55 arch
-rw-r----- 1 oracle asmadmin 9912320 Jan 3 17:14 control01.ctl
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 DG1_tbs01.dbf
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 dg1_tbs02.dbf
-rw-r----- 1 oracle asmadmin 10493952 Jan 3 17:13 DG1_tbs03.dbf
drwxr-xr-x 4 oracle oinstall 4096 Jan 3 17:13 FRA
-rw-r----- 1 oracle asmadmin 629153792 Jan 3 17:13 sysaux01.dbf
-rw-r----- 1 oracle asmadmin 734011392 Jan 3 17:13 system01.dbf
-rw-r----- 1 oracle asmadmin 346038272 Jan 3 17:13 undotbs01.dbf
-rw-r----- 1 oracle asmadmin 5251072 Jan 3 17:13 users01.dbf
./arch:
total 0
./FRA:
total 8
drwxr-xr-x 2 oracle oinstall 4096 Jan 3 17:04 DG
drwxr-x--- 3 oracle asmadmin 4096 Jan 3 17:13 DGS
./FRA/DG:
total 9696
-rw-r----- 1 oracle asmadmin 9912320 Jan 3 17:14 control02.ctl
./FRA/DGS:
total 4
drwxr-x--- 2 oracle asmadmin 4096 Jan 3 17:14 onlinelog
./FRA/DGS/onlinelog:
total 358820
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:13 o1_mf_1_8gblynhm_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:13 o1_mf_2_8gblyntf_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:13 o1_mf_3_8gblyo4p_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:13 o1_mf_4_8gblyojf_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:13 o1_mf_5_8gblyqhv_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:14 o1_mf_6_8gblyqv7_.log
-rw-r----- 1 oracle asmadmin 52429312 Jan 3 17:14 o1_mf_7_8gblyr67_.log
#the filename of onlinelog is strange to me.
orarac2poc:DGS:/u01/oradata/DG> ls -l arch
total 0
orarac2poc:DGS:/u01/oradata/DG> ps -ef |grep DGS
oracle 679 1 0 17:12 ? 00:00:00 ora_pmon_DGS
oracle 681 1 0 17:12 ? 00:00:00 ora_psp0_DGS
oracle 683 1 0 17:12 ? 00:00:00 ora_vktm_DGS
oracle 687 1 0 17:12 ? 00:00:00 ora_gen0_DGS
oracle 689 1 0 17:12 ? 00:00:00 ora_diag_DGS
oracle 691 1 0 17:12 ? 00:00:00 ora_dbrm_DGS
oracle 693 1 0 17:12 ? 00:00:00 ora_ping_DGS
oracle 695 1 0 17:12 ? 00:00:00 ora_acms_DGS
oracle 697 1 0 17:12 ? 00:00:00 ora_dia0_DGS
oracle 699 1 0 17:12 ? 00:00:00 ora_lmon_DGS
oracle 701 1 0 17:12 ? 00:00:00 ora_lmd0_DGS
oracle 703 1 0 17:12 ? 00:00:00 ora_rms0_DGS
oracle 705 1 0 17:12 ? 00:00:00 ora_lmhb_DGS
oracle 707 1 0 17:12 ? 00:00:00 ora_mman_DGS
oracle 709 1 0 17:12 ? 00:00:00 ora_dbw0_DGS
oracle 711 1 0 17:12 ? 00:00:00 ora_lgwr_DGS
oracle 713 1 0 17:12 ? 00:00:00 ora_ckpt_DGS
oracle 715 1 0 17:12 ? 00:00:00 ora_smon_DGS
oracle 717 1 0 17:12 ? 00:00:00 ora_reco_DGS
oracle 719 1 0 17:12 ? 00:00:00 ora_mmon_DGS
oracle 721 1 0 17:12 ? 00:00:00 ora_mmnl_DGS
oracle 723 1 0 17:12 ? 00:00:00 ora_d000_DGS
oracle 725 1 0 17:12 ? 00:00:00 ora_s000_DGS
oracle 726 28526 0 17:12 ? 00:00:00 oracleDGS (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 730 1 1 17:12 ? 00:00:01 oracleDGS (LOCAL=NO)
oracle 732 1 0 17:12 ? 00:00:00 oracleDGS (LOCAL=NO)
oracle 771 1 0 17:12 ? 00:00:00 oracleDGS (LOCAL=NO)
oracle 793 1 0 17:12 ? 00:00:00 ora_arc0_DGS
oracle 795 1 0 17:12 ? 00:00:00 ora_arc1_DGS
oracle 797 1 0 17:12 ? 00:00:00 ora_arc2_DGS
oracle 799 1 0 17:12 ? 00:00:00 ora_arc3_DGS
oracle 935 11645 0 17:14 pts/2 00:00:00 grep DGS
orarac1poc:DG:/home/oracle> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 3 17:16:37 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SYS@DG> alter system switch logfile;
System altered.
SYS@DG> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE#
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------
NEXT_TIME
---------
1 1 79 52428800 512 1 YES ACTIVE 862246 03-JAN-13 862408
03-JAN-13
2 1 80 52428800 512 1 NO CURRENT 862408 03-JAN-13 2.8147E+14
3 1 78 52428800 512 1 YES ACTIVE 861684 03-JAN-13 862246
03-JAN-13
--after rman duplicate
SYS@DGS> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SYS@DGS> select name from v$datafile;
NAME
------------------------------------------------------------------------------------------------------------------------------------
/u01/oradata/DG/system01.dbf
/u01/oradata/DG/sysaux01.dbf
/u01/oradata/DG/undotbs01.dbf
/u01/oradata/DG/users01.dbf
/u01/oradata/DG/DG1_tbs01.dbf
/u01/oradata/DG/dg1_tbs02.dbf
/u01/oradata/DG/DG1_tbs03.dbf
7 rows selected.
SYS@DGS> select sequence#, applied, first_time, next_time from v$archived_log order by 1;
no rows selected
SYS@DGS> select member, type from v$logfile;
MEMBER
------------------------------------------------------------------------------------------------------------------------------------
TYPE
-------
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_1_8gblynhm_.log
ONLINE
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_2_8gblyntf_.log
ONLINE
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_3_8gblyo4p_.log
ONLINE
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_4_8gblyojf_.log
STANDBY
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_5_8gblyqhv_.log
STANDBY
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_6_8gblyqv7_.log
STANDBY
/u01/oradata/DG/FRA/DGS/onlinelog/o1_mf_7_8gblyr67_.log
STANDBY
7 rows selected.
SYS@DGS> select sequence#, applied, first_time, next_time from v$archived_log order by 1;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
76 NO 03-JAN-13 03-JAN-13
77 NO 03-JAN-13 03-JAN-13
78 NO 03-JAN-13 03-JAN-13
SYS@DGS> alter database recover managed standby database using current logfile disconnect from session;
Database altered.
SYS@DGS> select sequence#, applied, first_time, next_time from v$archived_log order by 1;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
76 YES 03-JAN-13 03-JAN-13
77 YES 03-JAN-13 03-JAN-13
78 IN-MEMORY 03-JAN-13 03-JAN-13
SYS@DGS> select sequence#, applied, first_time, next_time from v$archived_log order by 1;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
76 YES 03-JAN-13 03-JAN-13
77 YES 03-JAN-13 03-JAN-13
78 IN-MEMORY 03-JAN-13 03-JAN-13
SYS@DGS> select sequence#, applied, first_time, next_time from v$archived_log order by 1;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
76 YES 03-JAN-13 03-JAN-13
77 YES 03-JAN-13 03-JAN-13
78 YES 03-JAN-13 03-JAN-13
79 IN-MEMORY 03-JAN-13 03-JAN-13
More google results lead me to the following threads.
RMAN-05001: Auxiliary Filename Conflicts with a File Used by the Target Database Tips
Curious RMAN-05001 in database duplicate
Clone an Oracle database using RMAN duplicate (same server)
Next I need to make the onlinelog filename look "beautiful"
