react 前端框架如何驱动企业数字化转型与创新发展
264
2023-12-05
如何使用RMAN对CDB中的PDB进行复制
如何使用RMAN对CDB中的PDB进行复制
本篇内容主要讲解“如何使用RMAN对CDB中的PDB进行复制”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用RMAN对CDB中的PDB进行复制”吧!
1.检查源RAC CDB(jy)的参数文件，数据文件，联机日志文件，控制文件，归档日志文件的存储目录
SQL> show parameter spfile NAME TYPE VALUE------------------------------------ ----------- --------------------------------------------spfile string +DATA/JY/PARAMETERFILE/spfile.303.961976713 SQL> select name from v$datafile; NAME-------------------------------------------------------------------------------- +DATA/JY/DATAFILE/system.317.962209603 +DATA/JY/DATAFILE/sysaux.298.962209605 +DATA/JY/DATAFILE/undotbs1.277.962209605 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675 +DATA/JY/DATAFILE/users.301.962209605 +DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675 +DATA/JY/DATAFILE/undotbs2.312.962209605 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649 +DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409 +DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409SQL> 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.961976705SQL> 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 1282.在目标主机上创建存储目标数据库(dupjy)相关数据库文件的目录，目标主机上的/u01/app/oracle/oradata/dupjy目录用来存储数据库的数据文件，控制文件，联机重做日志文件),/u01/app/oracle/arch/dupjy目录用来存储数据库的归档重做日志文件。
3.将源数据库的密码文件复制到目标主机的相应目录中并修改为目标数据库(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: RACStart concurrency: Stop concurrency: OSDBA group: dba OSOPER group: oper Databaseinstances: jy1,jy2 Configured nodes: jytest1,jytest2 CSScritical: no CPU count: 0 Memorytarget: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) cant 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 added10.138.130.171(ECDSA) to the list of known hosts. grid@10.138.130.171s password: pwddupjy [oracle@shard1 dbs]$ mv pwddupjy orapwdupjy4.使用源数据库的spfile文件来创建目标数据库要使用的spfile文件
在源数据库中执行下面的命令来创建pfile参数文件SQL> create pfile fromspfile; 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.171s 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.oraORACLE 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.5.使用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.ora6.给目标数据库配置静态监听
[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]$ lsnrctlstart 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.oraLog 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 forLinux: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) forthis service... The command completed successfully7.在目标主机上配置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) ) )8.在目标主机上测试是否可以通过使用网络服务名来连接源数据库与目标数据库
[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.9.在源主机上配置目标数据库的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) ) )10.在源主机上测试能否可以使用网络服务名来连接源数据库与目标数据库
[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.11.执行PDB数据库复制
[oracle@jytest1 ~]$ rman target sys/abcd@jy catalog rco/abcd@jypdb_173 auxiliary sys/abcd@dupjy Recovery Manager: Release 12.2.0.1.0 - Production on Tue Jan 23 17:47:09 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 connected to auxiliary database: DUPJY (not mounted) RMAN> duplicate database to dupjy pluggable database jypdb from active database nofilenamecheck using compressed backupset; Starting Duplicate Db at 23-JAN-18 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=2269 devicetype=DISK current logarchived contents of Memory Script: { sqlclone "alter system set db_name = JY comment= Modified by RMAN duplicate scope=spfile"; sql clone "alter system set db_unique_name = DUPJY comment= Modified by RMAN duplicate scope=spfile"; shutdown clone immediate; startup clone force nomount restore clone from service jyusing compressed backupset primary controlfile; alterclonedatabase mount; } executing Memory Script sql statement: alter systemsetdb_name = JY comment= Modified by RMAN duplicate scope=spfile sql statement: alter systemsetdb_unique_name = DUPJY 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 23-JAN-18 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: SID=2269 devicetype=DISK channel ORA_AUX_DISK_1: starting datafile backup setrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: restoring control file channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:06 output file name=/u01/app/oracle/oradata/dupjy/control01.ctl Finished restore at 23-JAN-18 database mounted Skipping pluggable database TESTPDB Automatically adding tablespace SYSTEM Automatically adding tablespace SYSAUX Automatically adding tablespace PDB$SEED:SYSTEM Automatically adding tablespace PDB$SEED:SYSAUX Automatically adding tablespace TESTPDB:SYSTEM Automatically adding tablespace TESTPDB:UNDOTBS1 Automatically adding tablespace UNDOTBS1 Automatically adding tablespace TESTPDB:UNDO_2 Automatically adding tablespace UNDOTBS2 Skipping tablespace USERS RMAN-05529: warning: DB_FILE_NAME_CONVERT resultedininvalid ASM names; names changed to disk group only. contents of Memory Script: { sqlclone alter database flashback off; set newname fordatafile 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 fordatafile 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"; setnewnamefor datafile 13 to "/u01/app/oracle/oradata/dupjy/undo_2.268.962209649"; set newname fordatafile 14 to"/u01/app/oracle/oradata/dupjy/users.278.962209649"; set newname for datafile 15 to "/u01/app/oracle/oradata/dupjy/test.275.962210609"; restore from nonsparse from service jyusing compressed backupsetclone database skip forever tablespace "USERS", "TESTPDB":"USERS", "TESTPDB":"UNDO_2", "TESTPDB":"UNDOTBS1", "TESTPDB":"TEST", "TESTPDB":"SYSTEM", "TESTPDB":"SYSAUX"; sqlalter system archive log current; } executing Memory Script sql statement: alter database flashback off executingcommand: SET NEWNAME executing command: SET NEWNAME executingcommand: SET NEWNAME executing command: SET NEWNAME executingcommand: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executingcommand: SET NEWNAME executing command: SET NEWNAME executingcommand: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executingcommand: SET NEWNAME Starting restore at 23-JAN-18 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/dupjy/system.317.962209603 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/dupjy/sysaux.298.962209605 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:36 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/dupjy/system.256.962209675 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/dupjy/sysaux.270.962209675 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:36 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: using compressed network backup setfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00008 to /u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: using compressed network backup setfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: using compressed network backup setfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/dupjy/system.271.962209649 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: using compressed network backup setfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/dupjy/sysaux.316.962209649 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:46 channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: using compressed network backup set from service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_AUX_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/dupjy/undo_2.268.962209649 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00014 to /u01/app/oracle/oradata/dupjy/users.278.962209649 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05 channel ORA_AUX_DISK_1: starting datafile backupsetrestore channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backupsetchannel ORA_AUX_DISK_1: restoring datafile 00015 to /u01/app/oracle/oradata/dupjy/test.275.962210609 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:04 Finished restore at 23-JAN-18 sql statement: alter system archivelog current current logarchived contents of Memory Script: { restoreclone force from service jyusing compressed backupset archivelog from scn 15660582; switchclonedatafile all; } executing Memory Script Starting restore at 23-JAN-18 using channel ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: starting archivedlogrestore to default destination channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: restoring archivedlog archived logthread=1 sequence=163 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_AUX_DISK_1: starting archivedlogrestore to default destination channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: restoring archivedlog archived logthread=1 sequence=164 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_AUX_DISK_1: starting archivedlogrestore to default destination channel ORA_AUX_DISK_1: using compressed network backupset from service jy channel ORA_AUX_DISK_1: restoring archived log archived logthread=1 sequence=165 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 channel ORA_AUX_DISK_1: starting archivedlogrestore to default destination channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: restoring archivedlog archived logthread=2 sequence=144 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01 channel ORA_AUX_DISK_1: starting archivedlogrestore to default destination channel ORA_AUX_DISK_1: using compressed network backupsetfrom service jy channel ORA_AUX_DISK_1: restoring archivedlog archived logthread=2 sequence=145 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 Finished restore at 23-JAN-18 datafile 1 switched to datafile copy input datafile copy RECID=17 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/system.317.962209603 datafile 3 switched to datafile copy input datafile copy RECID=18 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 datafile 4 switched to datafile copy input datafile copy RECID=19 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 datafile 5 switched to datafile copy input datafile copy RECID=20 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/system.256.962209675 datafile 6 switched to datafile copy input datafile copy RECID=21 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 datafile 8 switched to datafile copy input datafile copy RECID=22 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 datafile 9 switched to datafile copy input datafile copy RECID=23 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 datafile 10 switched to datafile copy input datafile copy RECID=24 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/system.271.962209649 datafile 11 switched to datafile copy input datafile copy RECID=25 STAMP=966167434 file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 datafile 12 switched to datafile copy input datafile copy RECID=26 STAMP=966167435 file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 datafile 13 switched to datafile copy input datafile copy RECID=27 STAMP=966167435 file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 datafile 14 switched to datafile copy input datafile copy RECID=28 STAMP=966167435 file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 datafile 15 switched to datafile copy input datafile copy RECID=29 STAMP=966167435 file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 contents of Memory Script: {set until scn 15661286; recover clone database skip forever tablespace "USERS","TESTPDB":"USERS", "TESTPDB":"UNDO_2", "TESTPDB":"UNDOTBS1", "TESTPDB":"TEST", "TESTPDB":"SYSTEM", "TESTPDB":"SYSAUX"delete archivelog ; } executing Memory Script executingcommand: SET until clause Starting recover at 23-JAN-18 using channel ORA_AUX_DISK_1 Executing: alter database datafile 7 offline drop Executing: alter database datafile 20 offline drop Executing: alter database datafile 19 offline drop Executing: alter database datafile 18 offline drop Executing: alter database datafile 21 offline drop Executing: alter database datafile 16 offline drop Executing: alter database datafile 17 offline drop starting media recovery archivedlog forthread 1 with sequence 164 is already on disk as file /u01/app/oracle/oradata/arch_dupjy/1_164_961976319.dbf archivedlog forthread 1 with sequence 165 is already on disk as file /u01/app/oracle/oradata/arch_dupjy/1_165_961976319.dbf archivedlog forthread 2 with sequence 144 is already on disk as file /u01/app/oracle/oradata/arch_dupjy/2_144_961976319.dbf archivedlog forthread 2 with sequence 145 is already on disk as file /u01/app/oracle/oradata/arch_dupjy/2_145_961976319.dbf archivedlogfile name=/u01/app/oracle/oradata/arch_dupjy/1_164_961976319.dbf thread=1 sequence=164 archivedlogfile name=/u01/app/oracle/oradata/arch_dupjy/2_144_961976319.dbf thread=2 sequence=144 archivedlogfile name=/u01/app/oracle/oradata/arch_dupjy/1_165_961976319.dbf thread=1 sequence=165 archivedlogfile name=/u01/app/oracle/oradata/arch_dupjy/2_145_961976319.dbf thread=2 sequence=145 media recovery complete, elapsed time: 00:00:02 Finished recover at 23-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: { sqlclone "alter system set db_name = DUPJY comment= Reset to original value by RMAN scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; } executing Memory Script sql statement: alter systemsetdb_name = DUPJY comment= Reset to original value by RMAN scope=spfile sql statement: alter system reset db_unique_name 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 DATAFILE/u01/app/oracle/oradata/dupjy/system.317.962209603, /u01/app/oracle/oradata/dupjy/system.256.962209675, /u01/app/oracle/oradata/dupjy/system.271.962209649CHARACTER SET ZHS16GBK sql statement: ALTER DATABASE ADD LOGFILE INSTANCEi2 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 contents of Memory Script: {set newname for tempfile 1 to "+DATA"; set newname for tempfile 2 to "+DATA"; set newname fortempfile 3 to"+DATA"; 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/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"; switch clonedatafile all; } executing Memory Script executingcommand: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME renamed tempfile 1 to +DATA incontrol file renamed tempfile 2 to +DATAin control file renamed tempfile 3 to +DATA incontrol file cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 RECID=1 STAMP=966167470 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 RECID=2 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 RECID=3 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 RECID=4 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 RECID=5 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 RECID=6 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 RECID=7 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 RECID=8 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 RECID=9 STAMP=966167471 cataloged datafile copy datafile copy file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 RECID=10 STAMP=966167471 datafile 3 switched to datafile copy input datafile copy RECID=1 STAMP=966167470 file name=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605 datafile 4 switched to datafile copy input datafile copy RECID=2 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605 datafile 6 switched to datafile copy input datafile copy RECID=3 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675 datafile 8 switched to datafile copy input datafile copy RECID=4 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675 datafile 9 switched to datafile copy input datafile copy RECID=5 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605 datafile 11 switched to datafile copy input datafile copy RECID=6 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649 datafile 12 switched to datafile copy input datafile copy RECID=7 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649 datafile 13 switched to datafile copy input datafile copy RECID=8 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649 datafile 14 switched to datafile copy input datafile copy RECID=9 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/users.278.962209649 datafile 15 switched to datafile copy input datafile copy RECID=10 STAMP=966167471 file name=/u01/app/oracle/oradata/dupjy/test.275.962210609 contents of Memory Script: { Alterclonedatabase open resetlogs; } executing Memory Script database opened Executing: drop pluggable database"TESTPDB"including datafiles contents of Memory Script: { sqlclone "alter pluggable database all open"; } executing Memory Script sql statement: alter pluggable database all open Dropping offline and skipped tablespaces Executing: alter database default tablespace system Executing: drop tablespace"USERS"including contents cascade constraints Finished Duplicate Db at 23-JAN-1812.检查源数据库中的PDB(jypdb)是否被成功复制到目标数据库dupjy中
SQL> selectname,open_mode from v$pdbs; NAME OPEN_MODE -------------------------------------------------------------------------------------------------------------------------------- ---------- PDB$SEED READ ONLY JYPDB READ WRITE到此，相信大家对“如何使用RMAN对CDB中的PDB进行复制”有了更深的了解，不妨来实际操作一番吧！这里是网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！
版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。
相关文章
发表评论
最近发表
推荐文章
热评文章
暂时没有评论，来抢沙发吧~