node-)rmantoRAC(迁移) - 数据库编程

all; 11> } 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 21-JUN-14 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=42 instance=dominic1 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to +DATA_DISK channel ORA_DISK_1: restoring datafile 00002 to +DATA_DISK channel ORA_DISK_1: restoring datafile 00003 to +DATA_DISK channel ORA_DISK_1: restoring datafile 00004 to +DATA_DISK channel ORA_DISK_1: restoring datafile 00005 to +DATA_DISK channel ORA_DISK_1: restoring datafile 00006 to +DATA_DISK channel ORA_DISK_1: reading from backup piece /dba/app/rmanbak/DOMINIC_dbfull_08p9pjgn_20140601.DB channel ORA_DISK_1: piece handle=/dba/app/rmanbak/DOMINIC_dbfull_08p9pjgn_20140601.DB tag=TAG20140601T232615 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:01:26 Finished restore at 21-JUN-14 datafile 1 switched to datafile copy input datafile copy RECID=10 STAMP=850855528 file name=+DATA_DISK/dominic/datafile/system.263.850855443 datafile 2 switched to datafile copy input datafile copy RECID=11 STAMP=850855529 file name=+DATA_DISK/dominic/datafile/sysaux.262.850855443 datafile 3 switched to datafile copy input datafile copy RECID=12 STAMP=850855529 file name=+DATA_DISK/dominic/datafile/undotbs1.261.850855443 datafile 4 switched to datafile copy input datafile copy RECID=13 STAMP=850855529 file name=+DATA_DISK/dominic/datafile/users.265.850855443 datafile 5 switched to datafile copy input datafile copy RECID=14 STAMP=850855529 file name=+DATA_DISK/dominic/datafile/example.264.850855443 datafile 6 switched to datafile copy input datafile copy RECID=15 STAMP=850855529 file name=+DATA_DISK/dominic/datafile/dominic_tbs.260.850855443 =================================================== ASMCMD> pwd +data_disk/dominic/datafile ASMCMD> ls DOMINIC_TBS.260.850855443 EXAMPLE.264.850855443 SYSAUX.262.850855443 SYSTEM.263.850855443 UNDOTBS1.261.850855443 USERS.265.850855443

select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --- 3 ONLINE /dba/app/oracle/oradata/dominic/redo03.log NO 2 ONLINE /dba/app/oracle/oradata/dominic/redo02.log NO 1 ONLINE /dba/app/oracle/oradata/dominic/redo01.log NO 1 ONLINE /dba/app/oracle/redolog/redo01-a.log NO 2 ONLINE /dba/app/oracle/redolog/redo02-a.log NO 3 INVALID ONLINE /dba/app/oracle/redolog/redo03-a.log NO 6 rows selected.

SQL> alter database rename file '/dba

node-)rmantoRAC(迁移)(四)