Environment Details:

[n00.test.alinafe.net:oracle:+ASM1:$dbs]: asmcmd lsdg

State   Type   Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N         512   4096 1048576 2584572   708515               0         708515             0             N BACKUP/

MOUNTED EXTERN N         512   4096 1048576   1542138 1508654               0         1508654             0             N DATA/

MOUNTED EXTERN N         512 4096 1048576   5242877 1704683               0         1704683             0             N PROD_DATA/

MOUNTED NORMAL N         512   4096 1048576     4094     3498               0           1749             0             Y TESTDC_OCR/

MOUNTED EXTERN N         512   4096 1048576   511999   479061               0         479061             0             N TESTRAC00/

MOUNTED EXTERN N         512   4096 1048576   1023999   925908               0         925908             0           N TANFAST/

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: asmcmd lsdg

State   Type   Rebal Sector Block       AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N         512   4096 1048576   921597   921220               0         921220             0            N DATA/

MOUNTED EXTERN N         512   4096 1048576   1023998 1023891               0         1023891             0             N TEST_ARCHIVE/

MOUNTED EXTERN N       512   4096 1048576   1023998 1023647               0         1023647             0             N TEST_PRODDATA/

MOUNTED EXTERN N         512   4096 1048576   4194300 4143388               0         4143388             0             N TEST_TAN/

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]:

[n00.test.alinafe.net:oracle:TEST1200:$dbs]: srvctl config scan

SCAN name: TESTdc-scan, Network: 1

Subnet IPv4: 192.168.196.0/255.255.255.0/eth0, static

Subnet IPv6:

SCAN 0 IPv4 VIP: …….

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

SCAN 1 IPv4 VIP: …….

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

SCAN 2 IPv4 VIP: ……

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

[oracle-n00.test.alinafe.net:oracle:TESTDB1:$dbs]: srvctl config scan

SCAN name: oracle-test-scan, Network: 1

Subnet IPv4: ………/255.255.255.0/eth0, static

Subnet IPv6:

SCAN 0 IPv4 VIP: ……….

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

SCAN 1 IPv4 VIP: ……..

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

SCAN 2 IPv4 VIP: ……..

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

[n00.test.alinafe.net:oracle:TEST1200:$dbs]: srvctl config nodeapps

Network 1 exists

Subnet IPv4: ……../255.255.255.0/eth0, static

Subnet IPv6:

Ping Targets:

Network is enabled

Network is individually enabled on nodes:

Network is individually disabled on nodes:

VIP exists: network number 1, hosting node d00

VIP Name: n00-vip

VIP IPv4 Address: …….

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

VIP exists: network number 1, hosting node d01

VIP Name: n01-vip

VIP IPv4 Address: ………

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false

ONS is enabled

ONS is individually enabled on nodes:

ONS is individually disabled on nodes:

[oracle-n00.test.alinafe.net:oracle:TESTDB1:$dbs]: srvctl config nodeapps

Network 1 exists

Subnet IPv4: ……./255.255.255.0/eth0, static

Subnet IPv6:

Ping Targets:

Network is enabled

Network is individually enabled on nodes:

Network is individually disabled on nodes:

VIP exists: network number 1, hosting node oracle-test00

VIP Name: oracle-n00-vip

VIP IPv4 Address: ……..

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

VIP exists: network number 1, hosting node oracle-test01

VIP Name: oracle-n01-vip

VIP IPv4 Address: ……….

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false

ONS is enabled

ONS is individually enabled on nodes:

ONS is individually disabled on nodes:

PRIMARY SERVER

n00.test.alinafe.net ;n01.test.alinafe.net

12c ASM Grid and Oralce 12 12.1.0.2.0 Binaries

db_name                       TEST12C

db_unique_name TEST12C_Japan

instance_name     TEST1200

SECONDARY SERVER

oracle-n00.test.alinafe.net;oracle-n01.test.alinafe.net

db_name                                              ORATS12C

db_unique_name             ORATS12C_Japan

instance_name                 ORATS1200

Step 1:

Copy the password file from Target database to auxiliary database location and rename it.

scp orapwtest1200 oracle@oracle-n00.test.alinafe.net:/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapworats1200

Step 2:

Create the pfile from target database for Auxilarydatabase( if target has spfile create pfile from spfile)

n00.test.alinafe.net:oracle:TEST1200:$dbs]: sp

sys@TEST12C> create pfile from spfile;

File created.

sys@TEST12C> exit

[n00.test.alinafe.net:oracle:TEST1200:$dbs]: ls -ltr

total 3224

………..

-rw-r—– 1 oracle oinstall   3521 Jul 30 13:55 initTEST1200.ora

-rw-rw—- 1 oracle oinstall 524288 Jul 30 13:55 id_TEST1200.dat

[n00.test.alinafe.net:oracle:TEST1200:$dbs]: mv initTEST1200.ora initORATS1200.ora

[n00.test.alinafe.net:oracle:TEST1200:$dbs]: scp initORATS1200.ora oracle@oracle-n00.test.alinafe.net:/u01/app/oracle/product/12.1.0/dbhome_1/dbs/

[oracle-n00.test.alinafe.net:oracle:TestDB1:$dbs]: ls -ltr

total 12

-rw-r—– 1 oracle oinstall 8192 Jul 30 13:54 orapwORATS1200

-rw-r—– 1 oracle oinstall 3521 Jul 30 13:57 initORATS1200.ora

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: mkdir -p /home/oracle/admin/ORATS1200/cdump

[oracle-n01.test.alinafe.net:oracle:TestDB2:$~]: mkdir -p /home/oracle/admin/ORATS1201/cdump

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: mkdir -p /u01/app/oracle/admin/ORATS12C_JAPAN

[oracle-n01.test.alinafe.net:oracle:TestDB2:$~]: mkdir -p /u01/app/oracle/admin/ORATS12C_JAPAN

[oracle-n00.test.alinafe.net:oracle:TestDB1:$dbs]: vi initORATS1200.ora

#ORATS1201.__data_transfer_cache_size=0

ORATS1200.__data_transfer_cache_size=0

#ORATS1201.__db_cache_size=5838471168

ORATS1200.__db_cache_size=12079595520

#ORATS1201.__java_pool_size=134217728

ORATS1200.__java_pool_size=134217728

#ORATS1201.__large_pool_size=134217728

ORATS1200.__large_pool_size=134217728

ORATS1200.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment

#ORATS1201.__oracle_base=’/u01/app/oracle’#ORACLE_BASE set from environment

#ORATS1201.__pga_aggregate_target=1073741824

ORATS1200.__pga_aggregate_target=1073741824

#ORATS1201.__sga_target=14294188032

ORATS1200.__sga_target=21005074432

#ORATS1201.__shared_io_pool_size=536870912

ORATS1200.__shared_io_pool_size=536870912

#ORATS1201.__shared_pool_size=7449083904

ORATS1200.__shared_pool_size=7918845952

#ORATS1201.__streams_pool_size=134217728

ORATS1200.__streams_pool_size=134217728

*.audit_file_dest=’/u01/app/oracle/admin/ORATS12C_JAPAN’

*.cluster_database=false

*.cluster_database_instances=1

*.control_files=’+DATA/ORATS12C_JAPAN/CONTROLFILE/controlfile01.ora’,’+TEST_ARCHIVE/ORATS12C_JAPAN/CONTROLFILE/controlfile02.ora’,’+TEST_PRODDATA/ORATS12C_JAPAN/CONTROLFILE/controlfile03.ora’

*.db_create_file_dest=’+TEST_TAN’

*.db_create_online_log_dest_1=’+TEST_TAN’

*.db_file_name_convert=’+BACKUP/TEST12c_japan’,’+TEST_TAN/ORATS12C_JAPAN’,’+TANFAST/TEST_JAPAN’,’+TEST_TAN/ORATS12C_JAPAN’

*.db_name=’ORATS12C’

*.db_recovery_file_dest=’+TEST_ARCHIVE’

*.db_recovery_file_dest_size=214748364800

*.db_unique_name=’ORATS12C_JAPAN’

*.diagnostic_dest=’/u01/app/oracle’

ORATS1200.instance_name=’ORATS1200′

#ORATS1201.instance_name=’ORATS1201′

ORATS1200.instance_number=1

#ORATS1201.instance_number=2

*.java_pool_size=134217728

*.job_queue_processes=10

*.large_pool_size=117440512

#ORATS1201.local_listener='(address=(protocol=tcp)(host=oracle-n01-vip)(port=1521))’

ORATS1200.local_listener='(address=(protocol=tcp)(host=oracle-n00-vip)(port=1521))’

*.log_file_name_convert=’+BACKUP/TEST12C_JAPAN’,’+TEST_TAN/ORATS12C_JAPAN’

*.processes=1000

*.remote_listener=’oracle-test-scan.test.alinafe.net:1521′,’oracle-test-scan:1521′

*.service_names=’ORATS12C’

ORATS1200.sga_max_size=31457280000#internally adjusted

*.sga_target=12884901888

#ORATS1201.sga_target=14260633600

ORATS1200.sga_target=21005074432

*.shared_pool_size=1358954496

*.sort_area_size=102400

*.streams_pool_size=117440512

ORATS1200.thread=1

#ORATS1201.thread=2

*.timed_statistics=TRUE

*.undo_management=’AUTO’

*.undo_retention=1800

ORATS1200.undo_tablespace=’UNDOTBS1′

#ORATS1201.undo_tablespace=’UNDOTBS2′

Step 3:

Configure the listener & tnsnames on both target database and auxiliary database.

Egs:

Tnsnames entries:

TEST1200 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = n00-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = n00-vip)(PORT = 1523))

(ADDRESS = (PROTOCOL = TCP)(HOST = n00-vip)(PORT = 1524))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = TEST12C)

(INSTANCE_NAME = TEST1200)

)

)

#Clone Database Parameters

ORATS1200 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-n00-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-test-scan)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED

(SID_NAME = ORATS1200)

)

)

ORATS1201 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-n01-vip)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = oracle-test-scan)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID_NAME = ORATS1201)

)

)

Step 4:

Create the required directory structure in Auxiliarydb location (based on pfile).

Step 5:

Open the Auxiliary database in Nomount state. Created spfile from pfile and again shutdown the auxiliary database and brought up to Nomount state using spfile.

 

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: ls

initORATS1200.ora orapwORATS1200

[oracle-n00.test.alinafe.net:oracle:+ASM1:$admin]: export ORACLE_SID=ORATS1200

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: sp

Connected to an idle instance.

idle> startup nomount;

ORACLE instance started.

Total System Global Area 3.1474E+10 bytes

Fixed Size                         2942880 bytes

Variable Size                 1.8790E+10 bytes

Database Buffers 1.2616E+10 bytes

Redo Buffers                     64163840 bytes

idle>

SQL> create spfile from pfile;

File created.

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: 12c

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: export ORACLE_SID=ORATS1200

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]:

SQL> shut immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

idle> startup nomount;

ORACLE instance started.

Total System Global Area 3.1474E+10 bytes

Fixed Size                         2942880 bytes

Variable Size                 1.8790E+10 bytes

Database Buffers 1.2616E+10 bytes

Redo Buffers                     64163840 bytes

idle> show parameter spfile;

NAME         TYPE           VALUE

——————————- ———– ————————–

spfile               string       /u01/app/oracle/product/12.1./dbhome_1/dbs/spfileORATS1200.ora

idle> exit

 

Step 6:

Go to the Target Database server and enter in to the RMAN prompt. Issue the below command to duplicate the Target database to auxiliary database.

 

[n00.test.alinafe.net:oracle:TEST1200:$admin]: tnsping orats1200

TNS Ping Utility for Linux: Version 12.1.0.2.0 – Production on 30-JUL-2016 21:37:10

Copyright (c) 1997, 2014, Oracle. All rights reserved.

Used parameter files:

/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-n00-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-test-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = ORATS1200)))

OK (10 msec)

[n00.test.alinafe.net:oracle:TEST1200:$admin]: rman target sys/******* auxiliary sys/*******@ORATS1200

Recovery Manager: Release 12.1.0.2.0 – Production on Sun Jul 31 01:29:07 2016

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

connected to target database: TEST12C (DBID=486976613)

connected to auxiliary database: ORATS12C (not mounted)

RMAN> duplicate target database to orats12C from active database nofilenamecheck;

Starting Duplicate Db at 31-07-16 01:30:08

using target database control file instead of recovery catalog

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=1146 device type=DISK

current log archived

contents of Memory Script:

{

sql clone “alter system set db_name =

”TEST12C” comment=

”Modified by RMAN duplicate” scope=spfile”;

shutdown clone immediate;

startup clone force nomount

backup as copy current controlfile auxiliary format ‘+DATA/ORATS12C_JAPAN/controlfile01.ora’;

restore clone primary controlfile to ‘+TEST_ARCHIVE/ORATS12C_JAPAN/controlfile02.ora’ from

‘+DATA/ORATS12C_JAPAN/controlfile01.ora’;

restore clone primary controlfile to ‘+TEST_PRODDATA/ORATS12C_JAPAN/controlfile03.ora’ from

‘+DATA/ORATS12C_JAPAN/controlfile01.ora’;

alter clone database mount;

}

executing Memory Script

sql statement: alter system set db_name = ”TEST12C” comment= ”Modified by RMAN duplicate” scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area   31474057216 bytes

Fixed Size                     2942880 bytes

Variable Size             18790484064 bytes

Database Buffers           12616466432 bytes

Redo Buffers                 64163840 bytes

Starting backup at 31-07-16 01:33:18

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=12 instance=TEST1200 device type=DISK

channel ORA_DISK_1: starting datafile copy

copying current control file

output file name=+DATA/ORATS12C_JAPAN/controlfile01.ora tag=TAG20160731T013319

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 31-07-16 01:33:25

Starting restore at 31-07-16 01:33:26

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=1146 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 31-07-16 01:33:34

Starting restore at 31-07-16 01:33:34

using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: copied control file copy

Finished restore at 31-07-16 01:33:37

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 newname for datafile 1 to

“+TEST_TAN”;

……………………

36 auxiliary format

“+TEST_TAN”   ;

sql ‘alter system archive log current’;

}

executing Memory Script

executing command: SET NEWNAME

……………………….

executing command: SET NEWNAME

Starting backup at 31-07-16 01:34:24

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile copy

………………………………

…………………………

Finished backup at 31-07-16 02:49:09

sql statement: alter system archive log current

current log archived

contents of Memory Script:

{

backup as copy reuse

archivelog like “+BACKUP/TEST12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11631.275.918610213” auxiliary format

“+TEST_ARCHIVE”   archivelog like

“+BACKUP/TEST12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11632.485.918611431″ auxiliary ……………./2016_07_31/thread_2_seq_11595.1242.918614955” auxiliary format

“+TEST_ARCHIVE”   ;

catalog clone start with “+TEST_ARCHIVE”;

switch clone datafile all;

}

executing Memory Script

Starting backup at 31-07-16 02:51:41

using channel ORA_DISK_1

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11632 RECID=23220 STAMP=918611431

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11632.341.918615105 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11634 RECID=23223 STAMP=918613650

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11634.426.918615107 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11633 RECID=23221 STAMP=918612413

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11633.415.918615111 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11635 RECID=23224 STAMP=918614450

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11635.339.918615115 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11631 RECID=23219 STAMP=918610213

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11631.342.918615117 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:03

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11637 RECID=23230 STAMP=918614950

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11637.338.918615121 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11589 RECID=23222 STAMP=918612408

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11589.343.918615123 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11638 RECID=23232 STAMP=918614956

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11638.314.918615123 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11590 RECID=23225 STAMP=918614447

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11590.313.918615125 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11594 RECID=23231 STAMP=918614946

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11594.312.918615127 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=1 sequence=11636 RECID=23229 STAMP=918614458

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11636.311.918615127 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11595 RECID=23233 STAMP=918614955

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11595.310.918615129 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11591 RECID=23226 STAMP=918614449

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11591.309.918615135 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:07

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11593 RECID=23228 STAMP=918614451

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11593.417.918615137 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

channel ORA_DISK_1: starting archived log copy

input archived log thread=2 sequence=11592 RECID=23227 STAMP=918614450

output file name=+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_2_seq_11592.398.918615139 RECID=0 STAMP=0

channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01

Finished backup at 31-07-16 02:52:23

searching for all files that match the pattern +TEST_ARCHIVE

List of Files Unknown to the Database

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

File Name: +TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11625.325.918608729

File Name: +TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11626.747.918608733

…………………..

+TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_30/thread_1_seq_11622.328.918602773

cataloging files…

cataloging done

List of Cataloged Files

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

File Name: +TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_31/thread_1_seq_11625.325.918608729

………………………………….

File Name: +TEST_ARCHIVE/ORATS12C_JAPAN/ARCHIVELOG/2016_07_30/thread_1_seq_11622.328.918602773

datafile 1 switched to datafile copy

input datafile copy RECID=36 STAMP=918615157 file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/system.283.918612267

datafile 2 switched to datafile copy

input datafile copy RECID=37 STAMP=918615174 file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/ts_undo.896.918614887

datafile 3 switched to datafile copy

input datafile copy RECID=38 STAMP=918615191 file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/archive.911.918614349

datafile 4 switched to datafile copy

input datafile copy RECID=39 STAMP=918615204 file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/TAN.474.918610673

datafile 5 switched to datafile copy

input datafile copy RECID=40 STAMP=918615226 file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/somedata.917.918613851

datafile 6 switched to datafile copy

…………………………….

contents of Memory Script:

{

set until scn 43862291989;

recover

clone database

delete archivelog

;

}

executing Memory Script

executing command: SET until clause

Starting recover at 31-07-16 03:05:10

using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 11632 is already on disk as file

…………………

media recovery complete, elapsed time: 00:00:09

Finished recover at 31-07-16 03:05:27

Oracle instance started

Total System Global Area   31474057216 bytes

Fixed Size                     2942880 bytes

Variable Size            18790484064 bytes

Database Buffers           12616466432 bytes

Redo Buffers                 64163840 bytes

contents of Memory Script:

{

sql clone “alter system set db_name =

”ORATS12C” comment=

”Reset to original value by RMAN” scope=spfile”;

}

executing Memory Script

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

Oracle instance started

Total System Global Area   31474057216 bytes

Fixed Size                     2942880 bytes

Variable Size             18790484064 bytes

Database Buffers           12616466432 bytes

Redo Buffers                 64163840 bytes

sql statement: CREATE CONTROLFILE REUSE SET DATABASE “ORATS12C” RESETLOGS ARCHIVELOG

MAXLOGFILES   315

MAXLOGMEMBERS     2

MAXDATAFILES       60

MAXINSTANCES   63

MAXLOGHISTORY   65732

LOGFILE

GROUP   4 ( ‘+TEST_TAN’ ) SIZE 100 M REUSE,

GROUP   6 ( ‘+TEST_TAN’ ) SIZE 100 M REUSE

DATAFILE

‘+TEST_TAN/ORATS12C_JAPAN/DATAFILE/system.283.918612267’

CHARACTER SET WE8ISO8859P1

sql statement: ALTER DATABASE ADD LOGFILE

INSTANCE ‘i2’

GROUP   1 ( ‘+TEST_TAN’ ) SIZE 100 M REUSE,

GROUP   2 ( ‘+TEST_TAN’ ) SIZE 100 M REUSE

contents of Memory Script:

{

set newname for tempfile 1 to

“+TEST_TAN”;

switch clone tempfile all;

catalog clone datafilecopy “+TEST_TAN/ORATS12C_JAPAN/DATAFILE/ts_undo.896.918614887”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/archive.911.918614349”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/TAN.474.918610673”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/somedata.917.918613851”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/ts_undo.465.918611049”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/TAN.449.918611425”,

“+TEST_TAN/ORATS12C_JAPAN/DATAFILE/sysaux.906.918614705”,

……………………………..

switch clone datafile all;

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to +TEST_TAN in control file

cataloged datafile copy

datafile copy file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/ts_undo.896.918614887 RECID=1 STAMP=918615980

cataloged datafile copy

datafile copy file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/archive.911.918614349 RECID=2 STAMP=918615980

cataloged datafile copy

datafile copy file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/TAN.474.918610673 RECID=3 STAMP=918615980

cataloged datafile copy

datafile copy file name=+TEST_TAN/ORATS12C_JAPAN/DATAFILE/somedata.917.918613851 RECID=4 STAMP=918615980

cataloged datafile copy

…………………………………

Executing: alter database force logging

contents of Memory Script:

{

Alter clone database open resetlogs;

}

executing Memory Script

database opened

Finished Duplicate Db at 31-07-16 03:06:45

Step 7:

Check the status of the cloned database.

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: sp

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 31 03:09:49 2016

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

sys@ORATS12C> select name,db_unique_name,database_role,dbid from v$database;

NAME DB_UNIQUE_NAME               DATABASE_ROLE                   DBID

——— —————————— —————- ———-

ORATS12C ORATS12C_JAPAN             PRIMARY       3292324836

VERIFICATIONS:

  1. Check the DBID of both the databases TEST12C and ORATS12C. It will be different.

Primary Database – TEST12C

[n00.test.alinafe.net:oracle:TEST1200:$admin]: sp

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 31 03:10:22 2016

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

sys@TEST12C> select name,db_unique_name,database_role,dbid from v$database;

NAME DB_UNIQUE_NAME               DATABASE_ROLE                   DBID

——— —————————— —————- ———-

TEST12C TEST12C_Japan                     PRIMARY           486976613

Clone Database – ORATS12C

sys@ORATS12C> select name,db_unique_name,database_role,dbid from v$database;

NAME DB_UNIQUE_NAME              DATABASE_ROLE                   DBID

——— —————————— —————- ———-

ORATS12C ORATS12C_JAPAN             PRIMARY       3292324836

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: sp

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 31 03:18:37 2016

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

sys@ORATS12C> create pfile from spfile;

File created.

oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: sp

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 31 03:28:14 2016

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

Connected to an idle instance.

idle> startup

ORACLE instance started.

Total System Global Area 3.1474E+10 bytes

Fixed Size                         2942880 bytes

Variable Size                 1.8790E+10 bytes

Database Buffers 1.2616E+10 bytes

Redo Buffers                     64163840 bytes

Database mounted.

Database opened.

idle> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

real       0m47.722s

user       0m0.022s

sys       0m0.056s

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: sftp oracle-test01

Connecting to oracle-test01…

sftp> cd /u01/app/oracle/product/12.1.0/dbhome_1/dbs

sftp> put initORATS1200.ora.post_clone_to_rac initORATS1201.ora

Uploading initORATS1200.ora.post_clone_to_rac to /u01/app/oracle/product/12.1.0/dbhome_1/dbs/initORATS1201.ora

initORATS1200.ora.post_clone_to_rac                                                                                                                                                 100% 3612     3.5KB/s   00:00

sftp>

oracle-n01.test.alinafe.net:oracle:ORATS1201:$dbs]: sp

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jul 31 03:34:37 2016

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

Connected to an idle instance.

idle> startup

ORACLE instance started.

Total System Global Area 3.1474E+10 bytes

Fixed Size                         2942880 bytes

Variable Size                 1.8790E+10 bytes

Database Buffers 1.2616E+10 bytes

Redo Buffers                     64163840 bytes

Database mounted.

Database opened.

idle> select name from v$database;

NAME

———

ORATS12C

idle> create spfile=’+TEST_TAN/ORATS12C_JAPAN/spfileorats12c.ora’ from pfile;

File created.

idle> exit

[oracle-n01.test.alinafe.net:oracle:ORATS1201:$dbs]: vi initORATS1201.ora

spfile=’+TEST_TAN/ORATS12C_JAPAN/spfileorats12c.ora’

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: srvctl add database -db ORATS12C_JAPAN -oraclehome /u01/app/oracle/product/12.1.0/dbhome_1 -spfile +TEST_TAN/ORATS12C_JAPAN/spfileorats12c.ora -dbname ORATS12C

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: srvctl config database -db ORATS12C_JAPAN -all

Database unique name: ORATS12C_JAPAN

Database name: ORATS12C

Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: +TEST_TAN/ORATS12C_JAPAN/spfileorats12c.ora

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups:

Mount point paths:

Services:

Type: RAC

Start concurrency:

Stop concurrency:

Database is enabled

Database is individually enabled on nodes:

Database is individually disabled on nodes:

OSDBA group: dba

OSOPER group:

Database instances:

Configured nodes:

Database is administrator managed

For regular database:

[oracle-n00.test.alinafe.net:oracle:ORATS1200:$dbs]: asm

[oracle-n00.test.alinafe.net:oracle:+ASM1:$dbs]: asmcmd

ASMCMD [+] > pwcreate –dbuniquename ORATS12C_JAPAN +TEST_TAN/ORATS12C_JAPAN/orapworats12c_japan *******

OPW-00010: Could not create the password file.

ORA-15056: additional error message

ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0 or higher

ORA-06512: at line 4

ASMCMD-9454: could not create new password file

ASMCMD [+] >

ASMCMD> pwget –dbuniquename orats12c_japan

 

 

Advertisements