关于rman恢复的一些问题
SQL> alter database backup controlfile to trace;Database altered.
SQL> select t.value from v$diag_info t where t.name='Default Trace File';
VALUE
--------------------------------------------------------------------------------
/u01/app/oracle/diag/rdbms/lote/lote/trace/lote_ora_4427.trc
CREATE CONTROLFILE REUSE DATABASE "LOTE" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/lote/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/lote/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/lote/redo03.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/lote/system01.dbf',
'/u01/app/oracle/oradata/lote/sysaux01.dbf',
'/u01/app/oracle/oradata/lote/undotbs01.dbf',
'/u01/app/oracle/oradata/lote/users01.dbf',
'/u01/app/oracle/oradata/lote/example01.dbf'
CHARACTER SET ZHS16GBK
;
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
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
CREATE CONTROLFILE REUSE DATABASE "LOTE" NORESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/lote/redo01.log' SIZE 50M BLOCKSIZE 512,
GROUP 2 '/u01/app/oracle/oradata/lote/redo02.log' SIZE 50M BLOCKSIZE 512,
GROUP 3 '/u01/app/oracle/oradata/lote/redo03.log' SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oracle/oradata/lote/system01.dbf',
'/u01/app/oracle/oradata/lote/sysaux01.dbf',
'/u01/app/oracle/oradata/lote/undotbs01.dbf',
'/u01/app/oracle/oradata/lote/users01.dbf',
'/u01/app/oracle/oradata/lote/example01.dbf'
CHARACTER SET ZHS16GBK
19 ;
CREATE CONTROLFILE REUSE DATABASE "LOTE" NORESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01189: file is from a different RESETLOGS than previous files
ORA-01517: log member: '/u01/app/oracle/oradata/lote/redo01.log'
查询官方文档得出以下结论：
ORA-01189: file is from a different RESETLOGS than previous files
Cause: In a CREATE CONTROLFILE command either this file or all previous files were backups from before the last RESETLOGS. This may also occur if this is a file that is offline and has been offline since before the last RESETLOGS.
Action: If the file was taken offline normal before the last RESETLOGS, and is still offline, omit it from the CREATE CONTROLFILE command. Rename and online the file after the database is open. Otherwise find the version of the mentioned file consistent with the rest of the datafiles and resubmit the command.
不甚理解，没有牵涉到offline数据文件的情况，求大神指点啊！ 你贴的内容并不完整
页:
[1]