12C Duplicating a Database to a Remote Host by Using Backup-based Duplication
不連線目標資料庫和恢復目錄使用備份來將RAC CDB複製成單例項CDB資料庫操作如下
1.檢查源RAC CDB(jy)的引數檔案,資料檔案,聯機日誌檔案,控制檔案,歸檔日誌檔案的儲存目錄
SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- -------------------------------------------- spfile string +DATA/JY/PARAMETERFILE/spfile.303.961976713 RMAN> report schema; Report of database schema for database with db_unique_name JY List of Permanent Datafiles =========================== File Size(MB) Tablespace RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1 840 SYSTEM YES +DATA/JY/DATAFILE/system.317.962209603 3 2340 SYSAUX NO +DATA/JY/DATAFILE/sysaux.298.962209605 4 1015 UNDOTBS1 YES +DATA/JY/DATAFILE/undotbs1.277.962209605 5 250 PDB$SEED:SYSTEM NO +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675 6 340 PDB$SEED:SYSAUX NO +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675 7 5 USERS NO +DATA/JY/DATAFILE/users.301.962209605 8 100 PDB$SEED:UNDOTBS1 NO +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675 9 1350 UNDOTBS2 YES +DATA/JY/DATAFILE/undotbs2.312.962209605 10 270 JYPDB:SYSTEM YES +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649 11 590 JYPDB:SYSAUX NO +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649 12 205 JYPDB:UNDOTBS1 YES +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649 13 310 JYPDB:UNDO_2 YES +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649 14 1267 JYPDB:USERS NO +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649 15 100 JYPDB:TEST NO +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609 16 260 TESTPDB:SYSTEM YES +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409 17 550 TESTPDB:SYSAUX NO +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409 18 245 TESTPDB:UNDOTBS1 YES +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409 19 100 TESTPDB:UNDO_2 YES +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409 20 5 TESTPDB:USERS NO +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409 21 100 TESTPDB:TEST NO +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409 List of Temporary Files ======================= File Size(MB) Tablespace Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1 144 TEMP 32767 +DATA/JY/TEMPFILE/temp.299.961976339 2 64 PDB$SEED:TEMP 32767 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.962209865 3 137 JYPDB:TEMP 32767 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.962210519 4 135 TESTPDB:TEMP 32767 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/TEMPFILE/temp.258.962469435 SQL> show parameter control_files NAME TYPE VALUE ------------------------------------ ----------- ------------------------------------------- control_files string +DATA/JY/CONTROLFILE/current.272.961976315 SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- +DATA/JY/ONLINELOG/group_2.302.961976321 +DATA/JY/ONLINELOG/group_1.261.961976319 +DATA/JY/ONLINELOG/group_3.263.961976697 +DATA/JY/ONLINELOG/group_4.262.961976705 SQL> archive log list Database log mode Archive Mode Automatic archival Enabled Archive destination +TEST/arch Oldest online log sequence 127 Next log sequence to archive 128 Current log sequence 128
2.對源RAC CDB資料庫建立RMAN備份,這裡將遠端主機的目錄/ora_backup透過nfs掛載到源主機的/ora_backup目錄這樣可以避免對備份檔案進行復制操作
[oracle@jytest1 ~]$ rman target/ catalog rco/abcd@jypdb_173 Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jan 24 19:47:12 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: JY (DBID=979425723) connected to recovery catalog database RMAN> run 2> { 3> backup as compressed backupset database format '/ora_backup/jy_%u_%d_%t_%s_%p' plus archivelog format '/ora_backup/arch_%d_%T_%U'; 4> backup current controlfile format'/ora_backup/%d_%s.ctl'; 5> backup spfile format '/ora_backup/spf%d_%s.ora'; 6> } Starting backup at 24-JAN-18 current log archived allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=385 instance=jy1 device type=DISK channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=2 sequence=141 RECID=320 STAMP=966188816 input archived log thread=1 sequence=161 RECID=321 STAMP=966188818 input archived log thread=2 sequence=142 RECID=323 STAMP=966188832 input archived log thread=1 sequence=162 RECID=322 STAMP=966188829 input archived log thread=1 sequence=163 RECID=325 STAMP=966188842 input archived log thread=2 sequence=143 RECID=324 STAMP=966188842 input archived log thread=2 sequence=144 RECID=327 STAMP=966189268 input archived log thread=1 sequence=164 RECID=326 STAMP=966189266 input archived log thread=1 sequence=165 RECID=328 STAMP=966189274 input archived log thread=2 sequence=145 RECID=329 STAMP=966189274 input archived log thread=1 sequence=166 RECID=330 STAMP=966192976 input archived log thread=2 sequence=146 RECID=331 STAMP=966192977 input archived log thread=1 sequence=167 RECID=333 STAMP=966193374 input archived log thread=2 sequence=147 RECID=332 STAMP=966193373 input archived log thread=2 sequence=148 RECID=334 STAMP=966193380 input archived log thread=1 sequence=168 RECID=335 STAMP=966193380 input archived log thread=1 sequence=169 RECID=336 STAMP=966207796 input archived log thread=2 sequence=149 RECID=338 STAMP=966208644 input archived log thread=1 sequence=170 RECID=337 STAMP=966208634 input archived log thread=1 sequence=171 RECID=339 STAMP=966208856 input archived log thread=2 sequence=150 RECID=340 STAMP=966208857 input archived log thread=1 sequence=172 RECID=341 STAMP=966209350 input archived log thread=2 sequence=151 RECID=342 STAMP=966209350 input archived log thread=1 sequence=173 RECID=344 STAMP=966209356 input archived log thread=2 sequence=152 RECID=343 STAMP=966209356 input archived log thread=2 sequence=153 RECID=346 STAMP=966246980 input archived log thread=1 sequence=174 RECID=345 STAMP=966246243 input archived log thread=1 sequence=175 RECID=347 STAMP=966271688 input archived log thread=2 sequence=154 RECID=349 STAMP=966282445 input archived log thread=1 sequence=176 RECID=348 STAMP=966282440 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/arch_JY_20180124_78spgj6g_1_1 tag=TAG20180124T194727 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:45 Finished backup at 24-JAN-18 Starting backup at 24-JAN-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00003 name=+DATA/JY/DATAFILE/sysaux.298.962209605 input datafile file number=00009 name=+DATA/JY/DATAFILE/undotbs2.312.962209605 input datafile file number=00004 name=+DATA/JY/DATAFILE/undotbs1.277.962209605 input datafile file number=00001 name=+DATA/JY/DATAFILE/system.317.962209603 input datafile file number=00007 name=+DATA/JY/DATAFILE/users.301.962209605 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/jy_79spgj9s_JY_966282556_233_1 tag=TAG20180124T194913 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:02:55 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00014 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649 input datafile file number=00011 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649 input datafile file number=00013 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649 input datafile file number=00010 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649 input datafile file number=00012 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649 input datafile file number=00015 name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/jy_7aspgjfb_JY_966282731_234_1 tag=TAG20180124T194913 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00017 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409 input datafile file number=00016 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409 input datafile file number=00018 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409 input datafile file number=00019 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409 input datafile file number=00021 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409 input datafile file number=00020 name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/jy_7bspgjhn_JY_966282807_235_1 tag=TAG20180124T194913 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:05 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00006 name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675 input datafile file number=00005 name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675 input datafile file number=00008 name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/jy_7cspgjjo_JY_966282872_236_1 tag=TAG20180124T194913 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55 channel ORA_DISK_1: starting compressed full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/jy_7dspgjlg_JY_966282928_237_1 tag=TAG20180124T194913 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 24-JAN-18 Starting backup at 24-JAN-18 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting compressed archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=177 RECID=351 STAMP=966282933 input archived log thread=2 sequence=155 RECID=350 STAMP=966282933 channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/arch_JY_20180124_7espgjln_1_1 tag=TAG20180124T195535 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 24-JAN-18 Starting backup at 24-JAN-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current control file in backup set channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/JY_239.ctl tag=TAG20180124T195540 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 24-JAN-18 Starting backup at 24-JAN-18 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set including current SPFILE in backup set channel ORA_DISK_1: starting piece 1 at 24-JAN-18 channel ORA_DISK_1: finished piece 1 at 24-JAN-18 piece handle=/ora_backup/spfJY_240.ora tag=TAG20180124T195549 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 24-JAN-18 在目標主機的/ora_backup目錄中檢視生成的RMAN備份檔案 [root@shard1 ora_backup]# ls -lrt total 1646052 -rw-r-----. 1 oracle 1006 473020928 Jan 24 13:45 arch_JY_20180124_78spgj6g_1_1 -rw-r-----. 1 oracle 1006 615038976 Jan 24 13:48 jy_79spgj9s_JY_966282556_233_1 -rw-r-----. 1 oracle 1006 213581824 Jan 24 13:49 jy_7aspgjfb_JY_966282731_234_1 -rw-r-----. 1 oracle 1006 190742528 Jan 24 13:50 jy_7bspgjhn_JY_966282807_235_1 -rw-r-----. 1 oracle 1006 171524096 Jan 24 13:51 jy_7cspgjjo_JY_966282872_236_1 -rw-r-----. 1 oracle 1006 1163264 Jan 24 13:51 jy_7dspgjlg_JY_966282928_237_1 -rw-r-----. 1 oracle 1006 392192 Jan 24 13:51 arch_JY_20180124_7espgjln_1_1 -rw-r-----. 1 oracle 1006 19972096 Jan 24 13:51 JY_239.ctl -rw-r-----. 1 oracle 1006 114688 Jan 24 13:51 spfJY_240.ora
3.在目標主機上建立儲存目標資料庫(dupjy)相關資料庫檔案的目錄,目標主機上的/u01/app/oracle/oradata/dupjy目錄用來儲存資料庫的資料檔案,控制檔案,聯機重做日誌檔案),/u01/app/oracle/arch/dupjy目錄用來儲存資料庫的歸檔重做日誌檔案。
4.將源資料庫的密碼檔案複製到目標主機的相應目錄中並修改為目標資料庫(dupjy)對應的檔名
[grid@jytest1 ~]$ srvctl config database -db jy Database unique name: jy Database name: jy Oracle home: /u01/app/oracle/product/12.2.0/db Oracle user: oracle Spfile: +DATA/JY/PARAMETERFILE/spfile.303.961976713 Password file: +DATA/JY/PASSWORD/pwdjy.274.961976109 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: oper Database instances: jy1,jy2 Configured nodes: jytest1,jytest2 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed [grid@jytest1 ~]$ asmcmd cp +DATA/JY/PASSWORD/pwdjy.274.961976109 /home/grid/pwddupjy copying +DATA/JY/PASSWORD/pwdjy.274.961976109 -> /home/grid/pwddupjy [oracle@shard1 dbs]# scp grid@10.138.130.171:/home/grid/pwddupjy /u01/app/oracle/product/12.2.0/db/dbs/ The authenticity of host '10.138.130.171 (10.138.130.171)' can't be established. ECDSA key fingerprint is 7a:62:58:8b:77:98:52:94:d6:d5:0c:c4:6c:87:a6:7f. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '10.138.130.171' (ECDSA) to the list of known hosts. grid@10.138.130.171's password: pwddupjy [oracle@shard1 dbs]$ mv pwddupjy orapwdupjy
5.使用源資料庫的spfile檔案來建立目標資料庫要使用的spfile檔案
在源資料庫中執行下面的命令來建立pfile引數檔案
SQL> create pfile from spfile; File created. [root@shard1 ~]# scp oracle@10.138.130.171:/u01/app/oracle/product/12.2.0/db/dbs/initjy1.ora /u01/app/oracle/product/12.2.0/db/dbs/ grid@10.138.130.171's password: initjy1.ora 100% 1731 1.7KB/s 00:00 [root@shard1 ~]# [oracle@shard1 dbs]$ cat initdupjy.ora *.audit_file_dest='/u01/app/oracle/admin/dupjy/adump' *.cluster_database=false *.compatible='12.2.0' *.control_files='/u01/app/oracle/oradata/dupjy/control01.ctl' *.db_block_size=8192 *.db_name='dupjy' *.diagnostic_dest='/u01/app/oracle' *.enable_pluggable_database=true *.open_cursors=300 *.pga_aggregate_target=1g *.processes=2000 *.remote_login_passwordfile='exclusive' *.sga_max_size=2147483648 *.sga_target=2147483648 db_file_name_convert= ('+DATA/JY/DATAFILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATA FILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/','/u01/app/oracle/oradata/dupjy/') log_file_name_convert=('+DATA/JY/ONLINELOG/','/u01/app/oracle/oradata/dupjy/') [oracle@shard1 dbs]$ export ORACLE_SID=dupjy [oracle@shard1 dbs]$ sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 18 19:06:00 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount pfile='/u01/app/oracle/product/12.2.0/db/dbs/initdupjy.ora' ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 570428704 bytes Database Buffers 1560281088 bytes Redo Buffers 7979008 bytes SQL> create spfile from pfile='/u01/app/oracle/product/12.2.0/db/dbs/initdupjy.ora'; File created.
6.使用spfile引數檔案來啟動目標資料庫例項(輔助例項dupjy)
SQL> shutdown immediate ORA-01507: database not mounted ORACLE instance shut down. SQL> startup nomount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 570428704 bytes Database Buffers 1560281088 bytes Redo Buffers 7979008 bytes SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ---------------------- ----------------------------------------------------- spfile string /u01/app/oracle/product/12.2.0/db/dbs/spfiledupjy.ora
7.給目標資料庫配置靜態監聽
[oracle@shard1 admin]$ vi listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = shard1)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = dupjy) (ORACLE_HOME = /u01/app/oracle/product/12.2.0/db) (GLOBAL_DBNAME=dupjy) ) ) [oracle@shard1 admin]$ lsnrctl start LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 18-JAN-2018 20:30:34 Copyright (c) 1991, 2016, Oracle. All rights reserved. Starting /u01/app/oracle/product/12.2.0/db/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/shard1/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shard1)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shard1)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 18-JAN-2018 20:30:34 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/12.2.0/db/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/shard1/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shard1)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Services Summary... Service "dupjy" has 1 instance(s). Instance "dupjy", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
8.在目標主機上配置tns,用來透過網路服務名來連線源資料庫與目標資料庫
[oracle@shard1 admin]$ vi tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db/network/admin/tnsnames.ora # Generated by Oracle configuration tools. JY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.130.171)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jy) ) ) DUPJY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.130.180)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dupjy) ) )
9.在目標主機上測試是否可以透過使用網路服務名來連線源資料庫與目標資料庫
[oracle@shard1 admin]$ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 18 21:02:53 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL> conn / as sysdba Connected. SQL> startup nomount ORACLE instance started. Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 570428704 bytes Database Buffers 1560281088 bytes Redo Buffers 7979008 bytes SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@shard1 admin]$ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Thu Jan 18 21:04:51 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL> conn sys/abcd@dupjy as sysdba Connected. SQL> conn sys/abcd@jy as sysdba Connected.
10.在源主機上配置目標資料庫的tns名
[oracle@jytest1 admin]$ vi tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.2.0/db/network/admin/tnsnames.ora # Generated by Oracle configuration tools. JY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = jytest-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jy) ) ) DUPJY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.138.130.180)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dupjy) (UR = A) ) )
11.在源主機上測試能否可以使用網路服務名來連線源資料庫與目標資料庫
[oracle@jytest1 admin]$ sqlplus /nolog SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 19 03:16:59 2018 Copyright (c) 1982, 2016, Oracle. All rights reserved. SQL> conn sys/abcd@jy as sysdba Connected. SQL> conn sys/abcd@dupjy as sysdba Connected.
12.使用備份來複制RAC CDB為單例項CDB(dupjy),執行duplicate命令,如果沒有配置自動通道,那麼至少手動分配一個輔助例項。如果是使用PFILE引數檔案啟動輔助例項需要指定pfile引數檔案,且pfile引數檔案必須儲存在執行RMAN執行復制的主機上。複製命令沒有指定資料庫名。使用database關鍵字而不指定資料庫名,duplicate將從備份中獲得資料庫名和DBID。如果在backup location目錄中一個資料庫有多個備份將會顯示錯誤。使用backup子句來識別沒有目標資料庫和恢復目錄的複製型別。until time選項用來指定恢復目標時間,它是唯一能與backup location子句一起使用的選項。因為副本資料庫和原資料庫檔案的檔名相同所以要指定nofilenamecheck選項:
[oracle@shard1 ora_backup]$ rman auxiliary sys/abcd@dupjy Recovery Manager: Release 12.2.0.1.0 - Production on Wed Jan 24 17:13:28 2018 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to auxiliary database: JY (not mounted) RMAN> run 2> { 3> set newname for database to '/u01/app/oracle/oradata/dupjy/%b'; 4> duplicate database 'JY' to 'dupjy' 5> logfile group 1 ('/u01/app/oracle/oradata/dupjy/group_1.261.961976319') size 200M reuse, 6> group 2 ('/u01/app/oracle/oradata/dupjy/group_2.302.961976321') size 200M reuse, 7> group 3 ('/u01/app/oracle/oradata/dupjy/group_3.263.961976697') size 200M reuse, 8> group 4 ('/u01/app/oracle/oradata/dupjy/group_4.262.961976705') size 200M reuse 9> backup location '/ora_backup'; 10> } executing command: SET NEWNAME Starting Duplicate Db at 24-JAN-18 contents of Memory Script: { sql clone "alter system set db_name = ''JY'' comment= ''Modified by RMAN duplicate'' scope=spfile"; shutdown clone immediate; startup clone force nomount restore clone primary controlfile from '/ora_backup/JY_239.ctl'; alter clone database mount; } executing Memory Script sql statement: alter system set db_name = ''JY'' comment= ''Modified by RMAN duplicate'' scope=spfile Oracle instance shut down Oracle instance started Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1056967968 bytes Database Buffers 1073741824 bytes Redo Buffers 7979008 bytes Starting restore at 24-JAN-18 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=2269 device type=DISK channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 output file name=/u01/app/oracle/oradata/dupjy/control01.ctl Finished restore at 24-JAN-18 database mounted released channel: ORA_AUX_DISK_1 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=2269 device type=DISK contents of Memory Script: { set until scn 15999223; sql clone 'alter database flashback off'; set newname for datafile 1 to "/u01/app/oracle/oradata/dupjy/system.317.962209603"; set newname for datafile 3 to "/u01/app/oracle/oradata/dupjy/sysaux.298.962209605"; set newname for datafile 4 to "/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605"; set newname for datafile 5 to "/u01/app/oracle/oradata/dupjy/system.256.962209675"; set newname for datafile 6 to "/u01/app/oracle/oradata/dupjy/sysaux.270.962209675"; set newname for datafile 7 to "/u01/app/oracle/oradata/dupjy/users.301.962209605"; set newname for datafile 8 to "/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675"; set newname for datafile 9 to "/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605"; set newname for datafile 10 to "/u01/app/oracle/oradata/dupjy/system.271.962209649"; set newname for datafile 11 to "/u01/app/oracle/oradata/dupjy/sysaux.316.962209649"; set newname for datafile 12 to "/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649"; set newname for datafile 13 to "/u01/app/oracle/oradata/dupjy/undo_2.268.962209649"; set newname for datafile 14 to "/u01/app/oracle/oradata/dupjy/users.278.962209649"; set newname for datafile 15 to "/u01/app/oracle/oradata/dupjy/test.275.962210609"; set newname for datafile 16 to "/u01/app/oracle/oradata/dupjy/system.260.962469409"; set newname for datafile 17 to "/u01/app/oracle/oradata/dupjy/sysaux.259.962469409"; set newname for datafile 18 to "/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409"; set newname for datafile 19 to "/u01/app/oracle/oradata/dupjy/undo_2.266.962469409"; set newname for datafile 20 to "/u01/app/oracle/oradata/dupjy/users.267.962469409"; set newname for datafile 21 to "/u01/app/oracle/oradata/dupjy/test.269.962469409"; restore clone database ; } executing Memory Script executing command: SET until clause sql statement: alter database flashback off executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 24-JAN-18 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/dupjy/system.317.962209603 channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/dupjy/sysaux.298.962209605 channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/dupjy/users.301.962209605 channel ORA_AUX_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 channel ORA_AUX_DISK_1: reading from backup piece /ora_backup/jy_79spgj9s_JY_966282556_233_1 channel ORA_AUX_DISK_1: piece handle=/ora_backup/jy_79spgj9s_JY_966282556_233_1 tag=TAG20180124T194913 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:25 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/dupjy/system.271.962209649 channel ORA_AUX_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/dupjy/sysaux.316.962209649 channel ORA_AUX_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 channel ORA_AUX_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/dupjy/undo_2.268.962209649 channel ORA_AUX_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/dupjy/users.278.962209649 channel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/dupjy/test.275.962210609 channel ORA_AUX_DISK_1: reading from backup piece /ora_backup/jy_7aspgjfb_JY_966282731_234_1 channel ORA_AUX_DISK_1: piece handle=/ora_backup/jy_7aspgjfb_JY_966282731_234_1 tag=TAG20180124T194913 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:55 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00016 to /u01/app/oracle/oradata/dupjy/system.260.962469409 channel ORA_AUX_DISK_1: restoring datafile 00017 to /u01/app/oracle/oradata/dupjy/sysaux.259.962469409 channel ORA_AUX_DISK_1: restoring datafile 00018 to /u01/app/oracle/oradata/dupjy/undotbs1.265.962469409 channel ORA_AUX_DISK_1: restoring datafile 00019 to /u01/app/oracle/oradata/dupjy/undo_2.266.962469409 channel ORA_AUX_DISK_1: restoring datafile 00020 to /u01/app/oracle/oradata/dupjy/users.267.962469409 channel ORA_AUX_DISK_1: restoring datafile 00021 to /u01/app/oracle/oradata/dupjy/test.269.962469409 channel ORA_AUX_DISK_1: reading from backup piece /ora_backup/jy_7bspgjhn_JY_966282807_235_1 channel ORA_AUX_DISK_1: piece handle=/ora_backup/jy_7bspgjhn_JY_966282807_235_1 tag=TAG20180124T194913 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45 channel ORA_AUX_DISK_1: starting datafile backup set restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set channel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/dupjy/system.256.962209675 channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/dupjy/sysaux.270.962209675 channel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 channel ORA_AUX_DISK_1: reading from backup piece /ora_backup/jy_7cspgjjo_JY_966282872_236_1 channel ORA_AUX_DISK_1: piece handle=/ora_backup/jy_7cspgjjo_JY_966282872_236_1 tag=TAG20180124T194913 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36 Finished restore at 24-JAN-18 contents of Memory Script: { switch clone datafile all; } executing Memory Script datafile 1 switched to datafile copy input datafile copy RECID=21 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/system.317.962209603 datafile 3 switched to datafile copy input datafile copy RECID=22 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 datafile 4 switched to datafile copy input datafile copy RECID=23 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 datafile 5 switched to datafile copy input datafile copy RECID=24 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/system.256.962209675 datafile 6 switched to datafile copy input datafile copy RECID=25 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 datafile 7 switched to datafile copy input datafile copy RECID=26 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/users.301.962209605 datafile 8 switched to datafile copy input datafile copy RECID=27 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 datafile 9 switched to datafile copy input datafile copy RECID=28 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 datafile 10 switched to datafile copy input datafile copy RECID=29 STAMP=966273552 file name=/u01/app/oracle/oradata/dupjy/system.271.962209649 datafile 11 switched to datafile copy input datafile copy RECID=30 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 datafile 12 switched to datafile copy input datafile copy RECID=31 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 datafile 13 switched to datafile copy input datafile copy RECID=32 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 datafile 14 switched to datafile copy input datafile copy RECID=33 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 datafile 15 switched to datafile copy input datafile copy RECID=34 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 datafile 16 switched to datafile copy input datafile copy RECID=35 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/system.260.962469409 datafile 17 switched to datafile copy input datafile copy RECID=36 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409 datafile 18 switched to datafile copy input datafile copy RECID=37 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409 datafile 19 switched to datafile copy input datafile copy RECID=38 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409 datafile 20 switched to datafile copy input datafile copy RECID=39 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/users.267.962469409 datafile 21 switched to datafile copy input datafile copy RECID=40 STAMP=966273553 file name=/u01/app/oracle/oradata/dupjy/test.269.962469409 contents of Memory Script: { set until scn 15999223; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 24-JAN-18 using channel ORA_AUX_DISK_1 starting media recovery channel ORA_AUX_DISK_1: starting archived log restore to default destination channel ORA_AUX_DISK_1: restoring archived log archived log thread=1 sequence=177 channel ORA_AUX_DISK_1: restoring archived log archived log thread=2 sequence=155 channel ORA_AUX_DISK_1: reading from backup piece /ora_backup/arch_JY_20180124_7espgjln_1_1 channel ORA_AUX_DISK_1: piece handle=/ora_backup/arch_JY_20180124_7espgjln_1_1 tag=TAG20180124T195535 channel ORA_AUX_DISK_1: restored backup piece 1 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 archived log file name=/u01/app/oracle/oradata/arch_dupjy/1_177_961976319.dbf thread=1 sequence=177 archived log file name=/u01/app/oracle/oradata/arch_dupjy/2_155_961976319.dbf thread=2 sequence=155 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/oradata/arch_dupjy/1_177_961976319.dbf RECID=1 STAMP=966273556 channel clone_default: deleting archived log(s) archived log file name=/u01/app/oracle/oradata/arch_dupjy/2_155_961976319.dbf RECID=2 STAMP=966273556 media recovery complete, elapsed time: 00:00:02 Finished recover at 24-JAN-18 Oracle instance started Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1056967968 bytes Database Buffers 1073741824 bytes Redo Buffers 7979008 bytes contents of Memory Script: { sql clone "alter system set db_name = ''DUPJY'' comment= ''Reset to original value by RMAN'' scope=spfile"; } executing Memory Script sql statement: alter system set db_name = ''DUPJY'' comment= ''Reset to original value by RMAN'' scope=spfile Oracle instance started Total System Global Area 2147483648 bytes Fixed Size 8794848 bytes Variable Size 1056967968 bytes Database Buffers 1073741824 bytes Redo Buffers 7979008 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUPJY" RESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 292 LOGFILE GROUP 1 ( '/u01/app/oracle/oradata/dupjy/group_1.261.961976319' ) SIZE 200 M REUSE, GROUP 2 ( '/u01/app/oracle/oradata/dupjy/group_2.302.961976321' ) SIZE 200 M REUSE, GROUP 3 ( '/u01/app/oracle/oradata/dupjy/group_3.263.961976697' ) SIZE 200 M REUSE, GROUP 4 ( '/u01/app/oracle/oradata/dupjy/group_4.262.961976705' ) SIZE 200 M REUSE DATAFILE '/u01/app/oracle/oradata/dupjy/system.317.962209603', '/u01/app/oracle/oradata/dupjy/system.256.962209675', '/u01/app/oracle/oradata/dupjy/system.271.962209649', '/u01/app/oracle/oradata/dupjy/system.260.962469409' CHARACTER SET ZHS16GBK contents of Memory Script: { set newname for tempfile 1 to "/u01/app/oracle/oradata/dupjy/temp.299.961976339"; set newname for tempfile 2 to "/u01/app/oracle/oradata/dupjy/temp.297.962209865"; set newname for tempfile 3 to "/u01/app/oracle/oradata/dupjy/temp.276.962210519"; set newname for tempfile 4 to "/u01/app/oracle/oradata/dupjy/temp.258.962469435"; switch clone tempfile all; catalog clone datafilecopy "/u01/app/oracle/oradata/dupjy/sysaux.298.962209605", "/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605", "/u01/app/oracle/oradata/dupjy/sysaux.270.962209675", "/u01/app/oracle/oradata/dupjy/users.301.962209605", "/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675", "/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605", "/u01/app/oracle/oradata/dupjy/sysaux.316.962209649", "/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649", "/u01/app/oracle/oradata/dupjy/undo_2.268.962209649", "/u01/app/oracle/oradata/dupjy/users.278.962209649", "/u01/app/oracle/oradata/dupjy/test.275.962210609", "/u01/app/oracle/oradata/dupjy/sysaux.259.962469409", "/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409", "/u01/app/oracle/oradata/dupjy/undo_2.266.962469409", "/u01/app/oracle/oradata/dupjy/users.267.962469409", "/u01/app/oracle/oradata/dupjy/test.269.962469409"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to /u01/app/oracle/oradata/dupjy/temp.299.961976339 in control file renamed tempfile 2 to /u01/app/oracle/oradata/dupjy/temp.297.962209865 in control file renamed tempfile 3 to /u01/app/oracle/oradata/dupjy/temp.276.962210519 in control file renamed tempfile 4 to /u01/app/oracle/oradata/dupjy/temp.258.962469435 in control file cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 RECID=1 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 RECID=2 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 RECID=3 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/users.301.962209605 RECID=4 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 RECID=5 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 RECID=6 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 RECID=7 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 RECID=8 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 RECID=9 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 RECID=10 STAMP=966273582 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 RECID=11 STAMP=966273583 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409 RECID=12 STAMP=966273583 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409 RECID=13 STAMP=966273583 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409 RECID=14 STAMP=966273583 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/users.267.962469409 RECID=15 STAMP=966273583 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/test.269.962469409 RECID=16 STAMP=966273583 datafile 3 switched to datafile copy input datafile copy RECID=1 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 datafile 4 switched to datafile copy input datafile copy RECID=2 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 datafile 6 switched to datafile copy input datafile copy RECID=3 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 datafile 7 switched to datafile copy input datafile copy RECID=4 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/users.301.962209605 datafile 8 switched to datafile copy input datafile copy RECID=5 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 datafile 9 switched to datafile copy input datafile copy RECID=6 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 datafile 11 switched to datafile copy input datafile copy RECID=7 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 datafile 12 switched to datafile copy input datafile copy RECID=8 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 datafile 13 switched to datafile copy input datafile copy RECID=9 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 datafile 14 switched to datafile copy input datafile copy RECID=10 STAMP=966273582 file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 datafile 15 switched to datafile copy input datafile copy RECID=11 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 datafile 17 switched to datafile copy input datafile copy RECID=12 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409 datafile 18 switched to datafile copy input datafile copy RECID=13 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409 datafile 19 switched to datafile copy input datafile copy RECID=14 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409 datafile 20 switched to datafile copy input datafile copy RECID=15 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/users.267.962469409 datafile 21 switched to datafile copy input datafile copy RECID=16 STAMP=966273583 file name=/u01/app/oracle/oradata/dupjy/test.269.962469409 contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened contents of Memory Script: { sql clone "alter pluggable database all open"; } executing Memory Script sql statement: alter pluggable database all open Finished Duplicate Db at 24-JAN-18
13.檢查源RAC CDB(jy)是否被成功複製成單例項CDB(dupjy)
SQL> alter session set container=testpdb; Session altered. SQL> select count(*) from jy.t1; COUNT(*) ---------- 39 SQL> select table_name,tablespace_name from dba_tables where owner='JY'; TABLE_NAME TABLESPACE_NAME -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ T1
從上面的輸出結果可以看到已經將源RAC CDB資料庫複製成為單例項CDB資料庫就已經操作完成了。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26015009/viewspace-2150756/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 12C RMAN Duplicating the PDB to remote CDBOracleREM
- Duplicating Database using RMAN duplicate commandDatabase
- Oracle 12c RMAN Duplicating a Subset of the Source Database TablespacesOracleDatabase
- Oracle Active database duplicationOracleDatabase
- Duplicating an Active DatabaseDatabase
- Duplicating a Database 筆記Database筆記
- 11g 新特性—— Active Database Duplication for A standby databaseDatabase
- Oracle 12C Transport a Database to a Different Platform Using Backup SetsOracleDatabasePlatform
- Oracle 12c RMAN Duplicating the Whole CDBOracle
- 11g 新特性—— Active Database DuplicationDatabase
- Oracle 12C RMAN Duplicating Tablespaces Within a PDBOracle
- TNS-12535 Unable To Connect To Remote Database using certain ApplicationsREMDatabaseAIAPP
- Oracle10G RMAN Database Duplication (Doc ID 259694.1)OracleDatabase
- Duplicating a Database Without Recovery Catalog or Target ConnectionDatabase
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!REMIDE
- Oracle Database 12c Release 2 (12.2) RAC On Oracle Linux 7 Using VMwareOracleDatabaseLinux
- oracle 12c 資料歸檔 即Using In-Database Archiving featureOracleDatabase
- Oracle 12C RMAN Duplicating the Whole RAC CDB to local RAC CDBOracle
- 11g RMAN新特性 active database duplication createing standbyDatabase
- REMOTE HOST IDENTIFICATION HAS CHANGED 問題解決REMIDE
- Using Regular Expressions in Oracle DatabaseExpressOracleDatabase
- Dependencies Among Local and Remote Database Procedures (252)REMDatabase
- 11g RMAN新特性 active database duplication 複製資料庫Database資料庫
- oracle 11gr2 活動資料庫複製(active database duplication)Oracle資料庫Database
- using-fastcgi-to-host-php-applications-on-iis7ASTPHPAPP
- SSH登入:WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!REMIDE
- Linux - SSH: WARNING REMOTE HOST IDENTIFICATION HAS CHANGEDLinuxREMIDE
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED解決方法REMIDE
- 【oracle官網】 Restoring a Database on a New HostOracleRESTDatabase
- 12c in-database archiveDatabaseHive
- 12c EM Database ExpressDatabaseExpress
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- Ora-12720 During Rman Duplication Of Database (文件 ID 341089.1)Database
- SSH登入警告(WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)REMIDE
- ssh登陸 “remote host identification has changed!“ 解決方案REMIDE
- Oracle 12c: Recover tables using RMANOracle
- How To Monitor Remote Windows Machine Using Nagios on LinuxREMWindowsMaciOSLinux
- recover database using backup controlfileDatabase