Oracle通过rman进行克隆(3)

contents of Memory Script:
{
  sql clone "alter system set  db_name =
 ''ORA235'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
  sql clone "alter system set  db_unique_name =
 ''ORA235'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
  shutdown clone immediate;
  startup clone force nomount
  backup as copy current controlfile auxiliary format  '/u01/app/oradata/ora235/control01.ctl';
  restore clone controlfile to  '/u01/app/oradata/ora235/control02.ctl' from
 '/u01/app/oradata/ora235/control01.ctl';
  alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''ORA235'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''ORA235'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area    780824576 bytes

Fixed Size                    2257312 bytes
Variable Size                511708768 bytes
Database Buffers            264241152 bytes
Redo Buffers                  2617344 bytes

Starting backup at 16-AUG-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=/u01/app/oracle/dbs/snapcf_ora235.f tag=TAG20180816T232148 RECID=6 STAMP=984352909
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 16-AUG-18

Starting restore at 16-AUG-18
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=18 device type=DISK

channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 16-AUG-18

database mounted
RMAN-05538: WARNING: implicitly using DB_FILE_NAME_CONVERT

contents of Memory Script:
{
  sql clone 'alter database flashback off';
  set newname for datafile  1 to
 "/u01/app/oradata/ora235/system01.dbf";
  set newname for datafile  2 to
 "/u01/app/oradata/ora235/sysaux01.dbf";
  set newname for datafile  3 to
 "/u01/app/oradata/ora235/undotbs01.dbf";
  set newname for datafile  4 to
 "/u01/app/oradata/ora235/users01.dbf";
  set newname for datafile  5 to
 "/data/oracle/data/lottu01.dbf";
  backup as copy reuse
  datafile  1 auxiliary format
 "/u01/app/oradata/ora235/system01.dbf"  datafile
 2 auxiliary format
 "/u01/app/oradata/ora235/sysaux01.dbf"  datafile
 3 auxiliary format
 "/u01/app/oradata/ora235/undotbs01.dbf"  datafile
 4 auxiliary format
 "/u01/app/oradata/ora235/users01.dbf"  datafile
 5 auxiliary format
 "/data/oracle/data/lottu01.dbf"  ;
  sql 'alter system archive log current';
}
executing Memory Script

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

Starting backup at 16-AUG-18
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/data/oracle/data/lottu01.dbf
output file name=/data/oracle/data/lottu01.dbf tag=TAG20180816T232159
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:01:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/u01/app/oradata/ora235/system01.dbf
output file name=/u01/app/oradata/ora235/system01.dbf tag=TAG20180816T232159
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/u01/app/oradata/ora235/sysaux01.dbf
output file name=/u01/app/oradata/ora235/sysaux01.dbf tag=TAG20180816T232159
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u01/app/oradata/ora235/undotbs01.dbf
output file name=/u01/app/oradata/ora235/undotbs01.dbf tag=TAG20180816T232159
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/u01/app/oradata/ora235/users01.dbf
output file name=/u01/app/oradata/ora235/users01.dbf tag=TAG20180816T232159
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 16-AUG-18

sql statement: alter system archive log current

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/c0be451f3b76a8a3d6c1dccc0ca26127.html