通过使用resetlog恢复控制文件恢复数据库(三)
racle/product/10.2.0/oradata/cuug/system01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/undotbs01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/sysaux01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/users01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/rmans01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/cuug01.dbf
/opt/oracle/product/10.2.0/db_1/dbs/UNNAMED00007
SQL>alter database rename file '/opt/oracle/product/10.2.0/db_1/dbs/UNNAMED00007'to '/opt/oracle/product/10.2.0/oradata/cuug/test01.dbf';
SQL>select name from v$datafile; www.2cto.com
NAME
--------------------------------------------------------------------------------
/opt/oracle/product/10.2.0/oradata/cuug/system01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/undotbs01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/sysaux01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/users01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/rmans01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/cuug01.dbf
/opt/oracle/product/10.2.0/oradata/cuug/test01.dbf
目前数据文件还不一致，需要进行介质恢复，但是不用using子句
SQL>recover database using backup controlfile;
ORA-00279:change 708399 generated at 06/26/2012 12:11:13 needed for thread 1
ORA-00289:suggestion :
/opt/oracle/product/10.2.0/flash_recovery_area/CUUG/archivelog/2012_06_26/o1_mf_
1_10_%u_.arc
ORA-00280:change 708399 for thread 1 is in sequence #10
Specifylog: {=suggested | filename | AUTO | CANCEL}
/opt/oracle/product/10.2.0/oradata/cuug/redo02.log
Mediarecovery complete
SQL>alter database open resetlogs;
Databasealtered.
查询恢复状态
selectfile_name,tablespace_name,bytes/1024/1024 MB fromdba_data_files
www.2cto.com
FILE_NAME TABLESPACE_NAME MB
------------------------------------------------------------------------------------------ ----------
/opt/oracle/product/10.2.0/oradata/cuug/cuug01.dbf CUUG 200
/opt/oracle/product/10.2.0/oradata/cuug/rmans01.dbf RMANS 500
/opt/oracle/product/10.2.0/oradata/cuug/users01.dbf USERS 5
/opt/oracle/product/10.2.0/oradata/cuug/sysaux01.dbf SYSAUX 250
/opt/oracle/product/10.2.0/oradata/cuug/undotbs01.dbf UNDOTBS1 25
/opt/oracle/product/10.2.0/oradata/cuug/system01.dbf SYSTEM 480
/opt/oracle/product/10.2.0/oradata/cuug/test01.dbf TEST 100 www.2cto.com
SQL>select count(*) from scott.a
2 ;
COUNT(*)
----------
3642
SQL>select count(*) from scott.aa;
COUNT(*)
----------
3642
恢复完成。
作者 Dream19881003