{"id":385,"date":"2015-06-12T02:21:45","date_gmt":"2015-06-12T02:21:45","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=385"},"modified":"2015-06-12T02:21:45","modified_gmt":"2015-06-12T02:21:45","slug":"1-active-data-guard-%ec%84%a4%ec%a0%95%ed%95%98%ea%b8%b01-rman-duplicate","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=385","title":{"rendered":"1. Active Data Guard \uc124\uc815\ud558\uae30(#1 RMAN Duplicate)"},"content":{"rendered":"<ul>\n<li><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515\"><span style=\"font-size:14pt\"><strong>\uc0c1\ud669 <\/strong><\/span><span style=\"font-size:10pt\"><br \/>\n\t\t\t\t<\/span><\/span><\/li>\n<\/ul>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SDB1 : Single on ASM DB\uc73c\ub85c DB OPEN \ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SDB2 : Grid + DB \uc5d4\uc9c4\ub9cc \uc124\uce58\ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ADG\ub97c \uc124\uc815\ud558\uae30\uc804\uc5d0 DB \ubcf5\uc81c\ub97c \uc704\ud558\uc5ec RMAN\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.(ASM \ubc29\uc2dd\uc5d0\uc11c DATAFILE \ubc29\uc2dd\uc73c\ub85c Convert)<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">RMAN DB \ubcf5\uc81c \ubc29\uc2dd\uc5d0\ub294<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<ol>\n<li><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ubc31\uc5c5\uc744 \uc774\uc6a9\ud55c Duplicate (OFFLINE)<br \/>\n<\/span><\/li>\n<li><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Open \ub418\uc5b4 \uc788\ub294 DB\ub97c \uc774\uc6a9\ud55c Active Duplicate (ONLINE)<br \/>\n<\/span><\/li>\n<\/ol>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\ubc29\uc2dd\uc774 \uc788\ub294\ub370 \uc5ec\uae30\uc5d0\uc11c\ub294 2\ubc88\uc744 \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>ADG\ub97c \uc704\ud55c force logging, archivelog \uc124\uc815<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb1 ~]$ sqlplus<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 4 15:12:11 2015<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1982, 2013, Oracle.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Enter user-name: \/as sysdba<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Connected to:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 &#8211; 64bit Production<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">With the Partitioning, Automatic Storage Management, OLAP, Data Mining<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">and Real Application Testing options<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; alter database force logging;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database altered.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; archive log list<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database log mode              No Archive Mode<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Automatic archival             Disabled<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Archive destination            \/oracle\/app\/oracle\/product\/11.2\/dbs\/arch<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oldest online log sequence     166<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Current log sequence           168<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; !<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb1 ~]$ ps -ef|grep pmon<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">grid      4085     1  0 May11 ?        00:04:08 asm_pmon_+ASM<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">oracle    4322     1  0 May11 ?        00:04:16 ora_pmon_SDB<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">oracle   28271 28225  0 15:16 pts\/3    00:00:00 grep pmon<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb1 ~]$ srvctl stop database -d SDB<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb1 ~]$ sqlplus<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 4 15:51:29 2015<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1982, 2013, Oracle.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Enter user-name: \/as sysdba<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Connected to an idle instance.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; startup mount<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ORACLE instance started.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area  835104768 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                  2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size             507513936 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers          322961408 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                2371584 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database mounted.<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; alter database archivelog;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database altered.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; alter database open;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database altered.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; archive log list<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database log mode              Archive Mode<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Automatic archival             Enabled<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Archive destination            \/oracle\/app\/oracle\/product\/11.2\/dbs\/arch<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oldest online log sequence     166<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Next log sequence to archive   168<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Current log sequence           168<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB2(Target) \uc811\uc18d\ud558\uc5ec \uc544\ub798 \ub0b4\uc6a9 \ucd94\uac00<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">vi \/etc\/hosts<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">192.168.56.55   sdb1.localdomain        sdb1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">192.168.56.57   sdb1-vip.localdomain    sdb1-vip<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">192.168.56.56   sdb2.localdomain        sdb2<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB2(Target)\uc5d0 \ub514\ub809\ud1a0\ub9ac \uc0dd\uc131<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oracle\/admin\/sdb2<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oracle\/admin\/sdb2\/adump<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oracle\/admin\/sdb2\/dpdump<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oracle\/admin\/sdb2\/pfile<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oradata\/sdb2<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">mkdir -p \/oracle\/admin\/oradata\/recovery_area\/sdb2<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">chmod -R 777 \/oracle\/admin\/oradata\/sdb2<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">chmod -R 777 \/oracle\/admin\/oradata\/recovery_area\/sdb2<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB2(Target) \ub124\ud2b8\uc6cc\ud06c \uad00\ub828 \uc124\uc815<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Source, Tagert \ubaa8\ub450 tnsnames.ora\uc5d0 \uc544\ub798 \uc815\ubcf4 \uae30\uc785<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb2 ~]$ vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SDB =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  (DESCRIPTION =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">    (ADDRESS = (PROTOCOL = TCP)(HOST = sdb1.localdomain)(PORT = 1521))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">    (CONNECT_DATA =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">      (SERVER = DEDICATED)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">      (SERVICE_NAME = SDB)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">    )<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  )<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SDB2 =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">        (DESCRIPTION =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">         (ADDRESS = (PROTOCOL = TCP)(HOST = sdb2.localdomain)(PORT = 1521))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">         (CONNECT_DATA =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (SERVER = DEDICATED)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (SERVICE_NAME = SDB2)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">        )<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> )<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Tagert listener.ora\uc5d0 \uc544\ub798 \uc815\ubcf4 \uae30\uc785<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb2 ~]$ vi $ORACLE_HOME\/network\/admin\/listener.ora<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SID_LIST_LISTENER=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">        (SID_LIST=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">         (SID_DESC=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (ORACLE_HOME=\/oracle\/app\/oracle\/product\/11.2)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (SID_NAME=SDB2))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">        )<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> )<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">LISTENER=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">        (DESCRIPTION=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">         (ADDRESS_LIST=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">          (ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ADR_BASE_LISTENER = \/u01\/app\/oracle<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb2 ~]$ lsnrctl start<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">LSNRCTL for Linux: Version 11.2.0.4.0 &#8211; Production on 04-JUN-2015 16:56:21<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1991, 2013, Oracle.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting \/oracle\/app\/oracle\/product\/11.2\/bin\/tnslsnr: please wait&#8230;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">TNSLSNR for Linux: Version 11.2.0.4.0 &#8211; Production<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Log messages written to \/oracle\/diag\/tnslsnr\/sdb2\/listener\/alert\/log.xml<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521)))<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">STATUS of the LISTENER<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Alias                     LISTENER<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Version                   TNSLSNR for Linux: Version 11.2.0.4.0 &#8211; Production<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Start Date                04-JUN-2015 16:56:22<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Uptime                    0 days 0 hr. 0 min. 0 sec<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Trace Level               off<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Security                  ON: Local OS Authentication<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SNMP                      OFF<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Listener Log File         \/oracle\/diag\/tnslsnr\/sdb2\/listener\/alert\/log.xml<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Listening Endpoints Summary&#8230;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sdb2.localdomain)(PORT=1521)))<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">The listener supports no services<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">The command completed successfully<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB1\uc758 pfile\uc744 \uc0dd\uc131\ud574 SDB2\uc5d0 \ubcf5\uc0ac\ud569\ub2c8\ub2e4.<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>\ub0b4\uc6a9\uc740  \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud569\ub2c8\ub2e4.(*\ub85c \uc218\uc815)<\/strong><br \/>\n\t\t<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__db_cache_size=385875968<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__java_pool_size=4194304<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__large_pool_size=8388608<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__oracle_base=&#8217;\/oracle&#8217;#ORACLE_BASE set from environment<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__pga_aggregate_target=293601280<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__sga_target=545259520<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__shared_io_pool_size=0<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__shared_pool_size=138412032<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.__streams_pool_size=0<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.audit_file_dest=&#8217;\/oracle\/admin\/oracle\/admin\/sdb2\/adump&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.audit_trail=&#8217;db&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.compatible=&#8217;11.2.0.4.0&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.control_files=&#8217;+DATA\/sdb\/controlfile\/current.260.878568075&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.db_block_size=8192<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.db_create_file_dest=&#8217;+DATA&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.db_domain=&#8221;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.db_name=&#8217;SDB2&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.diagnostic_dest=&#8217;\/oracle&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.dispatchers='(PROTOCOL=TCP) (SERVICE=SDBXDB)&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.memory_target=838860800<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.open_cursors=300<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.processes=150<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.remote_login_passwordfile=&#8217;EXCLUSIVE&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.statistics_level=&#8217;ALL&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.undo_tablespace=&#8217;UNDOTBS1&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">*.sec_case_sensitive_logon=&#8217;false&#8217;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB2(Targer) pfile\uc744 \uc774\uc6a9\ud558\uc5ec nomount\ub85c \uc2dc\uc791<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb2 dbs]$ sqlplus<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 9 10:42:19 2015<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1982, 2013, Oracle.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Enter user-name: \/as sysdba<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Connected to an idle instance.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; startup nomount pfile=&#8217;\/oracle\/app\/oracle\/product\/11.2\/dbs\/initSDB2.ora&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">ORACLE instance started.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area  835104768 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                  2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size             507513936 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers          322961408 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                2371584 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>SDB1(Source)\uc5d0\uc11c rman\uc744 \uc774\uc6a9\ud55c Duplicate \uc2dc\uc791(Source DB OPEN \uc0c1\ud0dc\uc5d0\uc11c \uc9c4\ud589)<\/strong><br \/>\n\t\t<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">RMAN \uc2a4\ud06c\ub9bd\ud2b8\uc5d0 \ub300\ud55c \uc124\uba85 \ucc38\uc870 : <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/backup.112\/e10643\/rcmsynta020.htm\">http:\/\/docs.oracle.com\/cd\/E11882_01\/backup.112\/e10643\/rcmsynta020.htm#RCMRF126<\/a><br \/>\n\t\t<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb1 ~]$ rman target sys\/oracle@SDB auxiliary sys\/oracle@SDB2<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Recovery Manager: Release 11.2.0.4.0 &#8211; Production on Thu Jun 11 10:29:24 2015<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1982, 2011, Oracle and\/or its affiliates.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">connected to target database: SDB (DBID=2394535691)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">connected to auxiliary database: SDB2 (not mounted)<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">RMAN&gt;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">run {<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SET NEWNAME FOR DATAFILE 1 TO &#8216;\/oracle\/admin\/oradata\/sdb2\/system01.dbf&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SET NEWNAME FOR DATAFILE 2 TO &#8216;\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SET NEWNAME FOR DATAFILE 3 TO &#8216;\/oracle\/admin\/oradata\/sdb2\/undo01.dbf&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SET NEWNAME FOR DATAFILE 4 TO &#8216;\/oracle\/admin\/oradata\/sdb2\/users01.dbf&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SET NEWNAME FOR TEMPFILE 1 TO &#8216;\/oracle\/admin\/oradata\/sdb2\/temp01&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">DUPLICATE TARGET DATABASE TO SDB2 FROM ACTIVE DATABASE<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">spfile<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">parameter_value_convert &#8216;SDB&#8217;,&#8217;SDB2&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set db_unique_name=&#8217;SDB2&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set cluster_database=&#8217;false&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set control_files=&#8217;\/oracle\/admin\/oradata\/sdb2\/control01.ctl&#8217;,&#8217;\/oracle\/admin\/oradata\/sdb2\/control02.ctl&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set db_recovery_file_dest=&#8217;\/oracle\/admin\/oradata\/recovery_area\/sdb2&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set db_recovery_file_dest_size=&#8217;18446744073709551614&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set db_create_file_dest=&#8217;\/oracle\/admin\/oradata\/sdb2\/&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set audit_trail=&#8217;none&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set audit_file_dest=&#8217;\/oracle\/admin\/oracle\/admin\/sdb2\/adump&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set log_archive_max_processes=&#8217;5&#8242;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">set standby_file_management=&#8217;AUTO&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">nofilenamecheck<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting Duplicate Db at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">using target database control file instead of recovery catalog<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">allocated channel: ORA_AUX_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_AUX_DISK_1: SID=21 device type=DISK<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   backup as copy reuse<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   targetfile  &#8216;+DATA\/sdb\/spfilesdb.ora&#8217; auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8216;\/oracle\/app\/oracle\/product\/11.2\/dbs\/spfileSDB2.ora&#8217;   ;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set spfile= &#8221;\/oracle\/app\/oracle\/product\/11.2\/dbs\/spfileSDB2.ora&#8221;&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">allocated channel: ORA_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: SID=47 device type=DISK<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set spfile= &#8221;\/oracle\/app\/oracle\/product\/11.2\/dbs\/spfileSDB2.ora&#8221;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_name =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;SDB2&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;duplicate&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  dispatchers =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;(PROTOCOL=TCP) (SERVICE=SDB2XDB)&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_unique_name =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;SDB2&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  cluster_database =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> false comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  control_files =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;\/oracle\/admin\/oradata\/sdb2\/control01.ctl&#8221;, &#8221;\/oracle\/admin\/oradata\/sdb2\/control02.ctl&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_recovery_file_dest =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;\/oracle\/admin\/oradata\/recovery_area\/sdb2&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_recovery_file_dest_size =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> 18446744073709551614 comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_create_file_dest =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;\/oracle\/admin\/oradata\/sdb2\/&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  audit_trail =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;none&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  audit_file_dest =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;\/oracle\/admin\/oracle\/admin\/sdb2\/adump&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  log_archive_max_processes =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> 5 comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  standby_file_management =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;AUTO&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   shutdown clone immediate;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   startup clone nomount;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_name =  &#8221;SDB2&#8221; comment= &#8221;duplicate&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  dispatchers =  &#8221;(PROTOCOL=TCP) (SERVICE=SDB2XDB)&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_unique_name =  &#8221;SDB2&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  cluster_database =  false comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  control_files =  &#8221;\/oracle\/admin\/oradata\/sdb2\/control01.ctl&#8221;, &#8221;\/oracle\/admin\/oradata\/sdb2\/control02.ctl&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_recovery_file_dest =  &#8221;\/oracle\/admin\/oradata\/recovery_area\/sdb2&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_recovery_file_dest_size =  18446744073709551614 comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_create_file_dest =  &#8221;\/oracle\/admin\/oradata\/sdb2\/&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  audit_trail =  &#8221;none&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  audit_file_dest =  &#8221;\/oracle\/admin\/oracle\/admin\/sdb2\/adump&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  log_archive_max_processes =  5 comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  standby_file_management =  &#8221;AUTO&#8221; comment= &#8221;&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance shut down<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">connected to auxiliary database (not started)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance started<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area     835104768 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                     2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size                541068368 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers             289406976 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                   2371584 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_name =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;SDB&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;Modified by RMAN duplicate&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_unique_name =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;SDB2&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;Modified by RMAN duplicate&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   shutdown clone immediate;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   startup clone force nomount<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   backup as copy current controlfile auxiliary format  &#8216;\/oracle\/admin\/oradata\/sdb2\/control01.ctl&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   restore clone controlfile to  &#8216;\/oracle\/admin\/oradata\/sdb2\/control02.ctl&#8217; from<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8216;\/oracle\/admin\/oradata\/sdb2\/control01.ctl&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   alter clone database mount;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_name =  &#8221;SDB&#8221; comment= &#8221;Modified by RMAN duplicate&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_unique_name =  &#8221;SDB2&#8221; comment= &#8221;Modified by RMAN duplicate&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance shut down<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance started<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area     835104768 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                     2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size                541068368 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers             289406976 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                   2371584 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">using channel ORA_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">copying current control file<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/app\/oracle\/product\/11.2\/dbs\/snapcf_SDB.f tag=TAG20150612T103404 RECID=4 STAMP=882182045<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting restore at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">allocated channel: ORA_AUX_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_AUX_DISK_1: SID=18 device type=DISK<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_AUX_DISK_1: copied control file copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished restore at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">database mounted<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set newname for datafile  1 to<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/system01.dbf&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set newname for datafile  2 to<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set newname for datafile  3 to<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/undo01.dbf&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set newname for datafile  4 to<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/users01.dbf&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   backup as copy reuse<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   datafile  1 auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/system01.dbf&#8221;   datafile<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> 2 auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf&#8221;   datafile<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> 3 auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/undo01.dbf&#8221;   datafile<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> 4 auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/users01.dbf&#8221;   ;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql &#8216;alter system archive log current&#8217;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">using channel ORA_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile file number=00004 name=+DATA\/sdb\/datafile\/users.259.878567899<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/admin\/oradata\/sdb2\/users01.dbf tag=TAG20150612T103415<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:02:15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile file number=00001 name=+DATA\/sdb\/datafile\/system.256.878567899<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/admin\/oradata\/sdb2\/system01.dbf tag=TAG20150612T103415<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile file number=00002 name=+DATA\/sdb\/datafile\/sysaux.257.878567899<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf tag=TAG20150612T103415<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:05<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile file number=00003 name=+DATA\/sdb\/datafile\/undotbs1.258.878567899<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/admin\/oradata\/sdb2\/undo01.dbf tag=TAG20150612T103415<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:55<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system archive log current<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   backup as copy reuse<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   archivelog like  &#8220;\/oracle\/app\/oracle\/product\/11.2\/dbs\/arch1_208_878568082.dbf&#8221; auxiliary format<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_%u_.arc&#8221;   ;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   catalog clone recovery area;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   switch clone datafile all;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">using channel ORA_DISK_1<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: starting archived log copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input archived log thread=1 sequence=208 RECID=41 STAMP=882182386<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">output file name=\/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_0mq9a27i_.arc RECID=0 STAMP=0<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished backup at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">searching for all files in the recovery area<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">List of Files Unknown to the Database<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">=====================================<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">File Name: \/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_0mq9a27i_.arc<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">File Name: \/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_207_0gq9a1mm_.arc<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">cataloging files&#8230;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">cataloging done<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">List of Cataloged Files<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">=======================<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">File Name: \/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_0mq9a27i_.arc<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">File Name: \/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_207_0gq9a1mm_.arc<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 1 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=4 STAMP=882182893 file name=\/oracle\/admin\/oradata\/sdb2\/system01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 2 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=5 STAMP=882182893 file name=\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 3 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=6 STAMP=882182893 file name=\/oracle\/admin\/oradata\/sdb2\/undo01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 4 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=7 STAMP=882182893 file name=\/oracle\/admin\/oradata\/sdb2\/users01.dbf<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set until scn  2900288;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   recover<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   clone database<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">    delete archivelog<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   ;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET until clause<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Starting recover at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">using channel ORA_AUX_DISK_1<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">starting media recovery<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">archived log for thread 1 with sequence 208 is already on disk as file \/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_0mq9a27i_.arc<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">archived log file name=\/oracle\/admin\/oradata\/recovery_area\/sdb2\/SDB2\/archivelog\/2015_06_12\/o1_mf_1_208_0mq9a27i_.arc thread=1 sequence=208<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">media recovery complete, elapsed time: 00:00:00<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished recover at 12-JUN-15<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance started<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area     835104768 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                     2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size                541068368 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers             289406976 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                   2371584 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system set  db_name =<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;SDB2&#8221; comment=<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8221;Reset to original value by RMAN&#8221; scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   sql clone &#8220;alter system reset  db_unique_name scope=spfile&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   shutdown clone immediate;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   startup clone nomount;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system set  db_name =  &#8221;SDB2&#8221; comment= &#8221;Reset to original value by RMAN&#8221; scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: alter system reset  db_unique_name scope=spfile<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance shut down<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">connected to auxiliary database (not started)<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle instance started<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Total System Global Area     835104768 bytes<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Fixed Size                     2257840 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Variable Size                541068368 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Database Buffers             289406976 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Redo Buffers                   2371584 bytes<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">sql statement: CREATE CONTROLFILE REUSE SET DATABASE &#8220;SDB2&#8221; RESETLOGS ARCHIVELOG<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  MAXLOGFILES     16<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  MAXLOGMEMBERS      3<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  MAXDATAFILES      100<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  MAXINSTANCES     8<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  MAXLOGHISTORY      292<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> LOGFILE<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  GROUP   1  SIZE 50 M ,<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  GROUP   2  SIZE 50 M ,<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  GROUP   3  SIZE 50 M<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> DATAFILE<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">  &#8216;\/oracle\/admin\/oradata\/sdb2\/system01.dbf&#8217;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> CHARACTER SET AL32UTF8<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   set newname for tempfile  1 to<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/temp01&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   switch clone tempfile all;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   catalog clone datafilecopy  &#8220;\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf&#8221;,<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/undo01.dbf&#8221;,<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\"> &#8220;\/oracle\/admin\/oradata\/sdb2\/users01.dbf&#8221;;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   switch clone datafile all;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing command: SET NEWNAME<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">renamed tempfile 1 to \/oracle\/admin\/oradata\/sdb2\/temp01 in control file<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">cataloged datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile copy file name=\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf RECID=1 STAMP=882182906<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">cataloged datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile copy file name=\/oracle\/admin\/oradata\/sdb2\/undo01.dbf RECID=2 STAMP=882182906<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">cataloged datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile copy file name=\/oracle\/admin\/oradata\/sdb2\/users01.dbf RECID=3 STAMP=882182906<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 2 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=1 STAMP=882182906 file name=\/oracle\/admin\/oradata\/sdb2\/sysaux01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 3 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=2 STAMP=882182906 file name=\/oracle\/admin\/oradata\/sdb2\/undo01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">datafile 4 switched to datafile copy<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">input datafile copy RECID=3 STAMP=882182906 file name=\/oracle\/admin\/oradata\/sdb2\/users01.dbf<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Reenabling controlfile options for auxiliary database<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Executing: alter database force logging<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">contents of Memory Script:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">{<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">   Alter clone database open resetlogs;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">}<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">executing Memory Script<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">database opened<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Finished Duplicate Db at 12-JUN-15<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:14pt\"><strong>Duplicate \uc798 \ub418\uc5c8\ub294\uc9c0 \ud655\uc778<\/strong><br \/>\n\t\t<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">[oracle@sdb2 ~]$ sqlplus &#8220;\/as sysdba&#8221;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL*Plus: Release 11.2.0.4.0 Production on Fri Jun 12 10:52:08 2015<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Copyright (c) 1982, 2013, Oracle.  All rights reserved.<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Connected to:<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 &#8211; 64bit Production<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SQL&gt; select instance_name,status from v$instance;<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">INSTANCE_NAME    STATUS<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">&#8212;&#8212;&#8212;&#8212;&#8212;- &#8212;&#8212;&#8212;&#8212;<br \/>\n<\/span><\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">SDB2             OPEN<br \/>\n<\/span><\/p>\n<p>\u00a0<br \/>\n\u00a0<\/p>\n<p><span style=\"color:black; font-family:\ub9d1\uc740 \uace0\ub515; font-size:10pt\">\u00a0<br \/>\n<\/span>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0c1\ud669 SDB1 : Single on ASM DB\uc73c\ub85c DB OPEN \ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc SDB2 : Grid + DB \uc5d4\uc9c4\ub9cc \uc124\uce58\ub418\uc5b4 \uc788\ub294 \uc0c1\ud0dc \u00a0 \u00a0 ADG\ub97c \uc124\uc815\ud558\uae30\uc804\uc5d0 DB \ubcf5\uc81c\ub97c \uc704\ud558\uc5ec RMAN\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.(ASM \ubc29\uc2dd\uc5d0\uc11c DATAFILE \ubc29\uc2dd\uc73c\ub85c Convert) \u00a0 \u00a0 RMAN DB \ubcf5\uc81c \ubc29\uc2dd\uc5d0\ub294 \u00a0 \u00a0 \ubc31\uc5c5\uc744 \uc774\uc6a9\ud55c Duplicate (OFFLINE) Open \ub418\uc5b4 \uc788\ub294 DB\ub97c \uc774\uc6a9\ud55c Active Duplicate (ONLINE) \u00a0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[21],"tags":[],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/385"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=385"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/385\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=385"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=385"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=385"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}