这里需要注意,因为控制文件记录的联机日志是放在ASM中,我们需要修改控制文件中联机日志的位置,可以通过rename 来修改,也可以通过重建控制文件来修改,这里我们使用重建控制文件:
CREATE CONTROLFILE REUSE DATABASE "SOURCEDB" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/Oracle/oradata/sourcedb/redo01.log' SIZE 50M,
GROUP 2 '/u01/oracle/oradata/sourcedb/redo02.log' SIZE 50M,
GROUP 3 '/u01/oracle/oradata/sourcedb/redo03.log' SIZE 50M
DATAFILE
'/u01/oracle/oradata/sourcedb/system01.dbf',
'/u01/oracle/oradata/sourcedb/undotbs301.dbf',
'/u01/oracle/oradata/sourcedb/sysaux01.dbf',
'/u01/oracle/oradata/sourcedb/users01.dbf',
'/u01/oracle/oradata/sourcedb/example01.dbf',
'/u01/oracle/oradata/sourcedb/gguser.dbf'
CHARACTER SET ZHS16GBK
;
Alter database open resetlogs;
恢复完毕。