oracle v$recover_file,Oracle 10g 裸设备数据文件恢复，ORA-19501、ORA-27063

拷贝到服务器上，恢复数据

SQL> alter database rename file '/dev/rdata_03' to '/Oracle/oradata/orcl/rdata_03_ct';

Database altered.

SQL> select * from v$recover_file;

no rows selected

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /

System altered.

SQL> select file_id,file_name,tablespace_name,ONLINE_STATUS from dba_data_files where online_status='OFFLINE';

FILE_ID FILE_NAME TABLESPACE_NAME ONLINE_

---------- ---------------------------------------- ------------------------------ -------

10 /oracle/oradata/orcl/xx xxx OFFLINE

35 /oracle/oradata/orcl/xx xx OFFLINE

56 /oracle/oradata/orcl/xx xxx OFFLINE

发现10,35,56数据文件offline

SQL> alter database datafile 56,35,10 online;

alter database datafile 56,35,10 online

*

ERROR at line 1:

ORA-01190: control file or data file 56 is from before the last RESETLOGS

ORA-01110: data file 56: '/oracle/oradata/orcl/rmdpt141'

SQL> recover datafile 10;

ORA-00279: change 12539662247608 generated at 11/05/2013 09:24:09 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2617_817156252.dbf

ORA-00280: change 12539662247608 for thread 1 is in sequence #2617

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 12539666248541 generated at 11/05/2013 09:45:21 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2618_817156252.dbf

ORA-00280: change 12539666248541 for thread 1 is in sequence #2618

ORA-00278: log file '/oracle/arch/1_2617_817156252.dbf' no longer needed for this recovery

Log applied.

Media recovery complete.

SQL> alter database datafile 10 online;

Database altered.

SQL> recover datafile 35;

ORA-00279: change 12539662247608 generated at 11/05/2013 09:24:09 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2617_817156252.dbf

ORA-00280: change 12539662247608 for thread 1 is in sequence #2617

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 12539666248541 generated at 11/05/2013 09:45:21 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2618_817156252.dbf

ORA-00280: change 12539666248541 for thread 1 is in sequence #2618

ORA-00278: log file '/oracle/arch/1_2617_817156252.dbf' no longer needed for this recovery

Log applied.

Media recovery complete.

SQL> alter database datafile 35;

alter database datafile 35

*

ERROR at line 1:

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

SQL> alter database datafile 35 online ;

Database altered.

SQL> recover datafile 56;

ORA-00279: change 12539662247608 generated at 11/05/2013 09:24:09 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2617_817156252.dbf

ORA-00280: change 12539662247608 for thread 1 is in sequence #2617

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 12539666248541 generated at 11/05/2013 09:45:21 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2618_817156252.dbf

ORA-00280: change 12539666248541 for thread 1 is in sequence #2618

ORA-00278: log file '/oracle/arch/1_2617_817156252.dbf' no longer needed for this recovery

Log applied.

Media recovery complete.

SQL> alter database datafile 56;

alter database datafile 56

*

ERROR at line 1:

ORA-01916: keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected

SQL> alter database datafile 56 online;

Database altered.

SQL> alter database rename file '/dev/rlog11_1g' to '/oracle/oradata/orcl/rlog11_1g';

Database altered.

SQL> alter database rename file '/dev/rlog12_1g' to '/oracle/oradata/orcl/rlog12_1g';

alter database rename file '/dev/rlog21_1g' to '/oracle/oradata/orcl//rlog21_1g';

Database altered.

alter database rename file '/dev/rlog22_1g' to '/oracle/oradata/orcl/rlog22_1g';SQL>

Database altered.

SQL> alter database rename file '/dev/rlog31_1g' to '/oracle/oradata/orcl/rlog31_1g';

Database altered.

SQL>

alter database rename file '/dev/rlog32_1g' to '/oracle/oradata/orcl/rlog32_1g';

Database altered.

SQL>

Database altered.

SQL> recover database using backup CONTROLFILE until cancel;

ORA-00279: change 12539662247608 generated at 11/05/2013 09:24:09 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2617_817156252.dbf

ORA-00280: change 12539662247608 for thread 1 is in sequence #2617

Specify log: {=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/oradata/orcl/rsystems_2g'

ORA-01112: media recovery not started

SQL> recover database using backup CONTROLFILE until cancel;

ORA-00279: change 12539662247608 generated at 11/05/2013 09:24:09 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2617_817156252.dbf

ORA-00280: change 12539662247608 for thread 1 is in sequence #2617

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 12539666248541 generated at 11/05/2013 09:45:21 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2618_817156252.dbf

ORA-00280: change 12539666248541 for thread 1 is in sequence #2618

ORA-00278: log file '/oracle/arch/1_2617_817156252.dbf' no longer needed for this recovery

ORA-00279: change 12539666769915 generated at 11/05/2013 09:48:47 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2619_817156252.dbf

ORA-00280: change 12539666769915 for thread 1 is in sequence #2619

ORA-00278: log file '/oracle/arch/1_2618_817156252.dbf' no longer needed for this recovery

ORA-00308: cannot open archived log '/oracle/arch/1_2619_817156252.dbf'

ORA-27037: unable to obtain file status

IBM AIX RISC System/6000 Error: 2: No such file or directory

Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 3 needs more recovery to be consistent

ORA-01110: data file 3: '/oracle/oradata/orcl/rsysaux_2g'

SQL> recover database using backup CONTROLFILE until cancel;

ORA-00279: change 12539666769915 generated at 11/05/2013 09:48:47 needed for thread 1

ORA-00289: suggestion : /oracle/arch/1_2619_817156252.dbf

ORA-00280: change 12539666769915 for thread 1 is in sequence #2619

Specify log: {=suggested | filename | AUTO | CANCEL}

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 3 needs more recovery to be consistent

ORA-01110: data file 3: '/oracle/oradata/orcl/rsysaux_2g'

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01194: file 3 needs more recovery to be consistent

ORA-01110: data file 3: '/oracle/oradata/orcl/rsysaux_2g'

_allow_resetlogs_corruption说明：

Oracle隐含参数，可能造成数据库中的数据不一致，某些查询如果涉及到这些不一致的数据会遇到ora-600 错误，打开数据库后建议重建数据库。

使用这个参数后，数据库在使用resetlogs的选项是才会生效，否则会忽略这个参数。