dbsuper

0 积分	0 好友	3 主题

发消息

[物理/逻辑坏块] 关于rman恢复的一些问题

1^#

发表于 2015-2-5 11:22:12 | 查看: 2051| 回复: 1

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数据文件的情况，求大神指点啊！

分享0