|
- run {
- allocate auxiliary channel c1 device type disk;
- allocate auxiliary channel c2 device type disk;
- allocate auxiliary channel c3 device type disk;
- allocate auxiliary channel c4 device type disk;
- allocate auxiliary channel c5 device type disk;
- allocate auxiliary channel c6 device type disk;
- allocate auxiliary channel c7 device type disk;
- allocate auxiliary channel c8 device type disk;
- allocate channel a1 device type disk;
- allocate channel a2 device type disk;
- allocate channel a3 device type disk;
- allocate channel a4 device type disk;
- allocate channel a5 device type disk;
- allocate channel a6 device type disk;
- allocate channel a7 device type disk;
- allocate channel a8 device type disk;
- duplicate target database to clone1
- from active database
- nofilenamecheck
- skip tablespace tbstrans2
- spfile
- set
- memory_target='700M'
- set
- control_files='+DATA','+FRA'
- set
- db_file_name_convert='+DATA/orcl','+DATA/clone1'
- set
- log_file_name_convert='+DATA/orcl','+DATA/clone1','+FRA/orcl','+FRA/clone1'
- set
- audit_file_dest='/u01/app/oracle/admin/clone1/adump';
- }
复制代码- [oracle@station76 admin]$ pwd
- /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
- [oracle@station76 admin]$ cd ..
- [oracle@station76 network]$ ls
- admin doc install jlib lib log mesg tools trace
- [oracle@station76 network]$ cd ..
- [oracle@station76 dbhome_1]$ ls
- apex crs demo install jlib nls oraInst.loc racg sqlplus usm
- assistants csmig diagnostics instantclient ldap oc4j ord rdbms srvm utl
- bin css dv inventory lib odbc oui relnotes station76.example.com_orcl wwg
- ccr ctx emcli j2ee log olap owb root.sh suptools xdk
- cdata cv EMStage javavm md OPatch owm scheduler sysman
- cfgtoollogs dbs has jdbc mesg OPatch.ori perl slax timingframework
- clone dc_ocm hs jdev mgw opmn plsql sqldeveloper ucp
- config deinstall ide jdk network oracore precomp sqlj uix
- [oracle@station76 dbhome_1]$ cd dbs
- [oracle@station76 dbs]$ ls
- hc_apple.dat hc_mydb2.dat hc_rcat.dat initorcl.ora lkMYDB2 lkRCAT orapworcl snapcf_orcl.f spfilercat.ora
- hc_dbtest.dat hc_orcl.dat init.ora lkinstdbtest lkORCL lkWINORCL orapwrcat snapcf_rcat.f
- [oracle@station76 dbs]$ vim initclone1.ora
- db_name=clone1
- db_domain=example.com
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- "initclone1.ora" [New] 2L, 37C written
- [oracle@station76 dbs]$ vim initclone2.ora
- db_name=clone2
- db_domain=example.com
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- "initclone2.ora" [New] 2L, 37C written
- [oracle@station76 dbs]$ orapwd file=orapwclone1 password=oracle_4U
- [oracle@station76 dbs]$ orapwd file=orapwclone2 password=oracle_4U
- [oracle@station76 dbs]$ cd /u01/app/
- [oracle@station76 app]$ ls
- oracle oraInventory
- [oracle@station76 app]$ cd oracle
- [oracle@station76 oracle]$ ls
- admin cfgtoollogs Clusterware dirlin flash_recovery_area product wallet
- botangdir01 checkpoints diag fast_recovery_area oradata station76
- [oracle@station76 oracle]$ cd admin/
- [oracle@station76 admin]$ ls
- +ASM clone1 dbtest mydb2 orcl rcat
- [oracle@station76 admin]$ cd clone1/
- [oracle@station76 clone1]$ ls
- adump
- [oracle@station76 clone1]$ cd ..
- [oracle@station76 admin]$ ls
- +ASM clone1 dbtest mydb2 orcl rcat
- [oracle@station76 admin]$ mkdir -p clone2/adump
- [oracle@station76 admin]$ exit
- logout
- [root@station76 ~]# vim /etc/oratab
- #Backup file is /u01/app/oracle/product/11.2.0/grid/srvm/admin/oratab.bak.station76 line added by Agent
- #
- # This file is used by ORACLE utilities. It is created by root.sh
- # and updated by either Database Configuration Assistant while creating
- # a database or ASM Configuration Assistant while creating ASM instance.
- # A colon, ':', is used as the field terminator. A new line terminates
- # the entry. Lines beginning with a pound sign, '#', are comments.
- #
- # Entries are of the form:
- # $ORACLE_SID:$ORACLE_HOME:<N|Y>:
- #
- # The first and second fields are the system identifier and home
- # directory of the database respectively. The third filed indicates
- # to the dbstart utility that the database should , "Y", or should not,
- # "N", be brought up at system boot time.
- #
- # Multiple entries with the same $ORACLE_SID are not allowed.
- #
- #
- +ASM:/u01/app/oracle/product/11.2.0/grid:N
- rcat:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
- orcl:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
- clone1:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
- clone2:/u01/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- ~
- "/etc/oratab" 28L, 1173C written
- [root@station76 ~]# su - oracle
- [oracle@station76 ~]$ . oraenv
- ORACLE_SID = [orcl] ? clone1
- The Oracle base remains unchanged with value /u01/app/oracle
- [oracle@station76 ~]$ sqlplus /nolog
- SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 26 04:15:30 2019
- Copyright (c) 1982, 2013, Oracle. All rights reserved.
- SQL> conn / as sysdba
- Connected to an idle instance.
- SQL> startup
- ORACLE instance started.
- Total System Global Area 263090176 bytes
- Fixed Size 2252256 bytes
- Variable Size 205521440 bytes
- Database Buffers 50331648 bytes
- Redo Buffers 4984832 bytes
- ORA-00205: error in identifying control file, check alert log for more info
- SQL> exit
- Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
- With the Partitioning, OLAP, Data Mining and Real Application Testing options
- [oracle@station76 ~]$ rman target sys/oracle_4U@orcl auxiliary sys/oracle_4U@clone1
- Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 26 04:16:20 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1554722616)
- connected to auxiliary database: CLONE1 (not mounted)
- RMAN>
复制代码
用备份冷克隆:
先备份:
- run {
- allocate channel c1 device type disk format '/home/oracle/clone1/%U';
- allocate channel c2 device type disk format '/home/oracle/clone1/%U';
- allocate channel c3 device type disk format '/home/oracle/clone1/%U';
- allocate channel c4 device type disk format '/home/oracle/clone1/%U';
- allocate channel c5 device type disk format '/home/oracle/clone1/%U';
- allocate channel c6 device type disk format '/home/oracle/clone1/%U';
- allocate channel c7 device type disk format '/home/oracle/clone1/%U';
- allocate channel c8 device type disk format '/home/oracle/clone1/%U';
- backup database plus archivelog force;
- backup spfile force;
- backup current controlfile force;
- }
复制代码- run {
- allocate auxiliary channel c1 device type disk;
- allocate auxiliary channel c2 device type disk;
- allocate auxiliary channel c3 device type disk;
- allocate auxiliary channel c4 device type disk;
- allocate auxiliary channel c5 device type disk;
- allocate auxiliary channel c6 device type disk;
- allocate auxiliary channel c7 device type disk;
- allocate auxiliary channel c8 device type disk;
- duplicate database to clone2
- backup location '/home/oracle/clone1'
- nofilenamecheck
- skip tablespace tbstrans2
- db_file_name_convert '+DATA/orcl','+DATA/clone2'
- logfile
- group 1 ('+DATA','+FRA') size 50M,
- group 2 ('+DATA','+FRA') size 50M,
- group 3 ('+DATA','+FRA') size 50M
- spfile
- parameter_value_convert '+DATA/orcl','+DATA/clone2','+FRA/orcl','+FRA/clone2','/u01/app/oracle/admin/orcl/adump','/u01/app/oracle/admin/clone2/adump'
- set
- control_files='+DATA','+FRA'
- set
- memory_target='700M';
- }
复制代码- [oracle@station76 ~]$ rman auxiliary sys/oracle_4U@clone2 cmdfile=/home/oracle/clone2.rcv
- Recovery Manager: Release 11.2.0.4.0 - Production on Thu Dec 26 10:10:27 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to auxiliary database: CLONE2 (not mounted)
- RMAN> run {
- 2> allocate auxiliary channel c1 device type disk;
- 3> allocate auxiliary channel c2 device type disk;
- 4> allocate auxiliary channel c3 device type disk;
- 5> allocate auxiliary channel c4 device type disk;
- 6> allocate auxiliary channel c5 device type disk;
- 7> allocate auxiliary channel c6 device type disk;
- 8> allocate auxiliary channel c7 device type disk;
- 9> allocate auxiliary channel c8 device type disk;
- 10> duplicate database to clone2
- 11> backup location '/home/oracle/clone1'
- 12> nofilenamecheck
- 13> skip tablespace tbstrans2
- 14> db_file_name_convert '+DATA/orcl','+DATA/clone2'
- 15> logfile
- 16> group 1 ('+DATA','+FRA') size 50M,
- 17> group 2 ('+DATA','+FRA') size 50M,
- 18> group 3 ('+DATA','+FRA') size 50M
- 19> spfile
- 20> parameter_value_convert '+DATA/orcl','+DATA/clone2','+FRA/orcl','+FRA/clone2','/u01/app/oracle/admin/orcl/adump','/u01/app/oracle/admin/clone2/adump'
- 21> set
- 22> control_files='+DATA','+FRA'
- 23> set
- 24> memory_target='700M';
- 25> }
- 26>
- allocated channel: c1
- channel c1: SID=429 device type=DISK
- allocated channel: c2
- channel c2: SID=5 device type=DISK
- allocated channel: c3
- channel c3: SID=146 device type=DISK
- allocated channel: c4
- channel c4: SID=288 device type=DISK
- allocated channel: c5
- channel c5: SID=430 device type=DISK
- allocated channel: c6
- channel c6: SID=6 device type=DISK
- allocated channel: c7
- channel c7: SID=147 device type=DISK
- allocated channel: c8
- channel c8: SID=289 device type=DISK
- Starting Duplicate Db at 2019-12-26:10:10:50
- contents of Memory Script:
- {
- restore clone spfile to '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora' from
- '/home/oracle/clone1/4iukc5nj_1_1';
- sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora''";
- }
- executing Memory Script
- Starting restore at 2019-12-26:10:10:51
- channel c2: skipped, AUTOBACKUP already found
- channel c3: skipped, AUTOBACKUP already found
- channel c4: skipped, AUTOBACKUP already found
- channel c5: skipped, AUTOBACKUP already found
- channel c6: skipped, AUTOBACKUP already found
- channel c7: skipped, AUTOBACKUP already found
- channel c8: skipped, AUTOBACKUP already found
- channel c1: restoring spfile from AUTOBACKUP /home/oracle/clone1/4iukc5nj_1_1
- channel c1: SPFILE restore from AUTOBACKUP complete
- Finished restore at 2019-12-26:10:11:03
- sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileclone2.ora''
- contents of Memory Script:
- {
- sql clone "alter system set db_name =
- ''CLONE2'' comment=
- ''duplicate'' scope=spfile";
- sql clone "alter system set control_files =
- ''+DATA'', ''+FRA'' comment=
- '''' scope=spfile";
- sql clone "alter system set memory_target =
- 700M comment=
- '''' scope=spfile";
- shutdown clone immediate;
- startup clone nomount;
- }
- executing Memory Script
- sql statement: alter system set db_name = ''CLONE2'' comment= ''duplicate'' scope=spfile
- sql statement: alter system set control_files = ''+DATA'', ''+FRA'' comment= '''' scope=spfile
- sql statement: alter system set memory_target = 700M comment= '''' scope=spfile
- Oracle instance shut down
- connected to auxiliary database (not started)
- Oracle instance started
- Total System Global Area 730714112 bytes
- Fixed Size 2256832 bytes
- Variable Size 486539328 bytes
- Database Buffers 234881024 bytes
- Redo Buffers 7036928 bytes
- allocated channel: c1
- channel c1: SID=68 device type=DISK
- allocated channel: c2
- channel c2: SID=131 device type=DISK
- allocated channel: c3
- channel c3: SID=192 device type=DISK
- allocated channel: c4
- channel c4: SID=8 device type=DISK
- allocated channel: c5
- channel c5: SID=69 device type=DISK
- allocated channel: c6
- channel c6: SID=132 device type=DISK
- allocated channel: c7
- channel c7: SID=193 device type=DISK
- allocated channel: c8
- channel c8: SID=9 device type=DISK
- contents of Memory Script:
- {
- sql clone "alter system set control_files =
- ''+DATA/clone2/controlfile/current.276.1028023901'', ''+FRA/clone2/controlfile/current.479.1028023903'' comment=
- ''Set by RMAN'' scope=spfile";
- sql clone "alter system set db_name =
- ''ORCL'' comment=
- ''Modified by RMAN duplicate'' scope=spfile";
- sql clone "alter system set db_unique_name =
- ''CLONE2'' comment=
- ''Modified by RMAN duplicate'' scope=spfile";
- shutdown clone immediate;
- startup clone force nomount
- restore clone primary controlfile from '/home/oracle/clone1/4jukc5nk_1_1';
- alter clone database mount;
- }
- executing Memory Script
- sql statement: alter system set control_files = ''+DATA/clone2/controlfile/current.276.1028023901'', ''+FRA/clone2/controlfile/current.479.1028023903'' comment= ''Set by RMAN'' scope=spfile
- sql statement: alter system set db_name = ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile
- sql statement: alter system set db_unique_name = ''CLONE2'' comment= ''Modified by RMAN duplicate'' scope=spfile
- Oracle instance shut down
- Oracle instance started
- Total System Global Area 730714112 bytes
- Fixed Size 2256832 bytes
- Variable Size 486539328 bytes
- Database Buffers 234881024 bytes
- Redo Buffers 7036928 bytes
- allocated channel: c1
- channel c1: SID=68 device type=DISK
- allocated channel: c2
- channel c2: SID=131 device type=DISK
- allocated channel: c3
- channel c3: SID=192 device type=DISK
- allocated channel: c4
- channel c4: SID=8 device type=DISK
- allocated channel: c5
- channel c5: SID=69 device type=DISK
- allocated channel: c6
- channel c6: SID=132 device type=DISK
- allocated channel: c7
- channel c7: SID=193 device type=DISK
- allocated channel: c8
- channel c8: SID=9 device type=DISK
- Starting restore at 2019-12-26:10:12:27
- channel c2: skipped, AUTOBACKUP already found
- channel c3: skipped, AUTOBACKUP already found
- channel c4: skipped, AUTOBACKUP already found
- channel c5: skipped, AUTOBACKUP already found
- channel c6: skipped, AUTOBACKUP already found
- channel c7: skipped, AUTOBACKUP already found
- channel c8: skipped, AUTOBACKUP already found
- channel c1: restoring control file
- channel c1: restore complete, elapsed time: 00:00:11
- output file name=+DATA/clone2/controlfile/current.276.1028023901
- output file name=+FRA/clone2/controlfile/current.479.1028023903
- Finished restore at 2019-12-26:10:12:45
- database mounted
- Not connected to TARGET or TARGET not open, cannot verify that subset of tablespaces is self-contained
- Not connected to TARGET, cannot verify that set of tablespaces being duplicated does not have SYS objects
- Datafile 6 skipped by request
- RMAN-05529: WARNING: DB_FILE_NAME_CONVERT resulted in invalid ASM names; names changed to disk group only.
- contents of Memory Script:
- {
- set until scn 1623324;
- set newname for datafile 1 to
- "+data";
- set newname for datafile 2 to
- "+data";
- set newname for datafile 3 to
- "+data";
- set newname for datafile 4 to
- "+data";
- set newname for datafile 5 to
- "+data";
- restore
- clone database
- skip forever tablespace "TBSTRANS2" ;
- }
- executing Memory Script
- executing command: SET until clause
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- executing command: SET NEWNAME
- Starting restore at 2019-12-26:10:12:57
- channel c1: starting datafile backup set restore
- channel c1: specifying datafile(s) to restore from backup set
- channel c1: restoring datafile 00005 to +data
- channel c1: reading from backup piece /home/oracle/clone1/4cukc5mt_1_1
- channel c2: starting datafile backup set restore
- channel c2: specifying datafile(s) to restore from backup set
- channel c2: restoring datafile 00001 to +data
- channel c2: reading from backup piece /home/oracle/clone1/49ukc5ms_1_1
- channel c3: starting datafile backup set restore
- channel c3: specifying datafile(s) to restore from backup set
- channel c3: restoring datafile 00002 to +data
- channel c3: reading from backup piece /home/oracle/clone1/4aukc5ms_1_1
- channel c4: starting datafile backup set restore
- channel c4: specifying datafile(s) to restore from backup set
- channel c4: restoring datafile 00003 to +data
- channel c4: reading from backup piece /home/oracle/clone1/4bukc5ms_1_1
- channel c5: starting datafile backup set restore
- channel c5: specifying datafile(s) to restore from backup set
- channel c5: restoring datafile 00004 to +data
- channel c5: reading from backup piece /home/oracle/clone1/4fukc5mu_1_1
- channel c1: piece handle=/home/oracle/clone1/4cukc5mt_1_1 tag=TAG20191226T043226
- channel c1: restored backup piece 1
- channel c1: restore complete, elapsed time: 00:00:02
- channel c5: piece handle=/home/oracle/clone1/4fukc5mu_1_1 tag=TAG20191226T043226
- channel c5: restored backup piece 1
- channel c5: restore complete, elapsed time: 00:00:01
- channel c4: piece handle=/home/oracle/clone1/4bukc5ms_1_1 tag=TAG20191226T043226
- channel c4: restored backup piece 1
- channel c4: restore complete, elapsed time: 00:00:04
- channel c2: piece handle=/home/oracle/clone1/49ukc5ms_1_1 tag=TAG20191226T043226
- channel c2: restored backup piece 1
- channel c2: restore complete, elapsed time: 00:00:17
- channel c3: piece handle=/home/oracle/clone1/4aukc5ms_1_1 tag=TAG20191226T043226
- channel c3: restored backup piece 1
- channel c3: restore complete, elapsed time: 00:00:17
- Finished restore at 2019-12-26:10:13:18
- contents of Memory Script:
- {
- switch clone datafile all;
- }
- executing Memory Script
- datafile 1 switched to datafile copy
- input datafile copy RECID=6 STAMP=1028023998 file name=+DATA/clone2/datafile/system.278.1028023981
- datafile 2 switched to datafile copy
- input datafile copy RECID=7 STAMP=1028023998 file name=+DATA/clone2/datafile/sysaux.256.1028023983
- datafile 3 switched to datafile copy
- input datafile copy RECID=8 STAMP=1028023999 file name=+DATA/clone2/datafile/undotbs1.272.1028023983
- datafile 4 switched to datafile copy
- input datafile copy RECID=9 STAMP=1028023999 file name=+DATA/clone2/datafile/users.284.1028023983
- datafile 5 switched to datafile copy
- input datafile copy RECID=10 STAMP=1028023999 file name=+DATA/clone2/datafile/tbstrans1.275.1028023981
- contents of Memory Script:
- {
- set until scn 1623324;
- recover
- clone database
- skip forever tablespace "TBSTRANS2" delete archivelog
- ;
- }
- executing Memory Script
- executing command: SET until clause
- Starting recover at 2019-12-26:10:13:21
- Executing: alter database datafile 6 offline drop
- starting media recovery
- channel c1: starting archived log restore to default destination
- channel c1: restoring archived log
- archived log thread=1 sequence=30
- channel c1: reading from backup piece /home/oracle/clone1/4hukc5nh_1_1
- channel c1: piece handle=/home/oracle/clone1/4hukc5nh_1_1 tag=TAG20191226T043248
- channel c1: restored backup piece 1
- channel c1: restore complete, elapsed time: 00:00:01
- archived log file name=+FRA/clone2/archivelog/2019_12_26/thread_1_seq_30.478.1028024009 thread=1 sequence=30
- channel clone_default: deleting archived log(s)
- archived log file name=+FRA/clone2/archivelog/2019_12_26/thread_1_seq_30.478.1028024009 RECID=1 STAMP=1028024009
- media recovery complete, elapsed time: 00:00:02
- Finished recover at 2019-12-26:10:13:32
- Oracle instance started
- Total System Global Area 730714112 bytes
- Fixed Size 2256832 bytes
- Variable Size 486539328 bytes
- Database Buffers 234881024 bytes
- Redo Buffers 7036928 bytes
- contents of Memory Script:
- {
- sql clone "alter system set db_name =
- ''CLONE2'' comment=
- ''Reset to original value by RMAN'' scope=spfile";
- sql clone "alter system reset db_unique_name scope=spfile";
- shutdown clone immediate;
- startup clone nomount;
- }
- executing Memory Script
- sql statement: alter system set db_name = ''CLONE2'' comment= ''Reset to original value by RMAN'' scope=spfile
- sql statement: alter system reset db_unique_name scope=spfile
- Oracle instance shut down
- connected to auxiliary database (not started)
- Oracle instance started
- Total System Global Area 730714112 bytes
- Fixed Size 2256832 bytes
- Variable Size 486539328 bytes
- Database Buffers 234881024 bytes
- Redo Buffers 7036928 bytes
- allocated channel: c1
- channel c1: SID=70 device type=DISK
- allocated channel: c2
- channel c2: SID=131 device type=DISK
- allocated channel: c3
- channel c3: SID=192 device type=DISK
- allocated channel: c4
- channel c4: SID=6 device type=DISK
- allocated channel: c5
- channel c5: SID=71 device type=DISK
- allocated channel: c6
- channel c6: SID=132 device type=DISK
- allocated channel: c7
- channel c7: SID=193 device type=DISK
- allocated channel: c8
- channel c8: SID=7 device type=DISK
- sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONE2" RESETLOGS ARCHIVELOG
- MAXLOGFILES 16
- MAXLOGMEMBERS 3
- MAXDATAFILES 100
- MAXINSTANCES 8
- MAXLOGHISTORY 292
- LOGFILE
- GROUP 1 ( '+DATA', '+FRA' ) SIZE 50 M ,
- GROUP 2 ( '+DATA', '+FRA' ) SIZE 50 M ,
- GROUP 3 ( '+DATA', '+FRA' ) SIZE 50 M
- DATAFILE
- '+DATA/clone2/datafile/system.278.1028023981'
- CHARACTER SET AL32UTF8
- contents of Memory Script:
- {
- set newname for tempfile 1 to
- "+data";
- switch clone tempfile all;
- catalog clone datafilecopy "+DATA/clone2/datafile/sysaux.256.1028023983",
- "+DATA/clone2/datafile/undotbs1.272.1028023983",
- "+DATA/clone2/datafile/users.284.1028023983",
- "+DATA/clone2/datafile/tbstrans1.275.1028023981";
- switch clone datafile all;
- }
- executing Memory Script
- executing command: SET NEWNAME
- renamed tempfile 1 to +data in control file
- cataloged datafile copy
- datafile copy file name=+DATA/clone2/datafile/sysaux.256.1028023983 RECID=1 STAMP=1028024100
- cataloged datafile copy
- datafile copy file name=+DATA/clone2/datafile/undotbs1.272.1028023983 RECID=2 STAMP=1028024100
- cataloged datafile copy
- datafile copy file name=+DATA/clone2/datafile/users.284.1028023983 RECID=3 STAMP=1028024101
- cataloged datafile copy
- datafile copy file name=+DATA/clone2/datafile/tbstrans1.275.1028023981 RECID=4 STAMP=1028024101
- datafile 2 switched to datafile copy
- input datafile copy RECID=1 STAMP=1028024100 file name=+DATA/clone2/datafile/sysaux.256.1028023983
- datafile 3 switched to datafile copy
- input datafile copy RECID=2 STAMP=1028024100 file name=+DATA/clone2/datafile/undotbs1.272.1028023983
- datafile 4 switched to datafile copy
- input datafile copy RECID=3 STAMP=1028024101 file name=+DATA/clone2/datafile/users.284.1028023983
- datafile 5 switched to datafile copy
- input datafile copy RECID=4 STAMP=1028024101 file name=+DATA/clone2/datafile/tbstrans1.275.1028023981
- contents of Memory Script:
- {
- Alter clone database open resetlogs;
- }
- executing Memory Script
- database opened
- Dropping offline and skipped tablespaces
- Executing: drop tablespace "TBSTRANS2" including contents cascade constraints
- Finished Duplicate Db at 2019-12-26:10:16:18
- released channel: c1
- released channel: c2
- released channel: c3
- released channel: c4
- released channel: c5
- released channel: c6
- released channel: c7
- released channel: c8
- Recovery Manager complete.
- [oracle@station76 ~]$
复制代码
|
|