拐拐许珈颖,古剑奇谭白方几何,找保姆照顾老人在廊坊
案例：rename一个数据文件后做不完全恢复
sql>startup mount； //启动到mount状态
sql> show parameter control_files //查看控制文件的位置信息
name type value
------------------------------------ ----------- ------------------------------
control_files string +data/metro/controlfile/backup
.268.848861257
sql> select name from v$datafile;
//查看数据文件的信息
name
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/metro/system01.dbf
/u01/app/oracle/oradata/metro/undotbs01.dbf
/u01/app/oracle/oradata/metro/sysaux01.dbf
/u01/app/oracle/oradata/metro/users01.dbf
/u01/app/oracle/oradata/metro/example01.dbf
sql> alter database rename file '/u01/app/oracle/oradata/metro/system01.dbf' to '+data/metro/datafile/system.257.848858337';
//更改数据文件的信息
sql> select status from v$instance;
//查看当前状态
status
------------
mounted
sql> alter database open; //尝试启库，报出需要resetlogs提示
alter database open
*
error at line 1:
ora-01589: must use resetlogs or noresetlogs option for database open
sql> alter database open resetlogs;//以resetlogs形式启库，提示数据文件1不
alter database open resetlogs
*
error at line 1:
ora-01152: file 1 was not restored from a sufficiently old backup
ora-01110: data file 1: '+data/metro/datafile/system.257.848858337'
sql> select checkpoint_change# from v$datafile; //检查控制文件中各数据文件scn
checkpoint_change#
------------------
862849
862849
862849
862849
862849
sql> select checkpoint_change# from v$datafile_header; //检查实际文件的scn号
checkpoint_change#
------------------
861998
863385
863385
863385
863385
sql> recover datafile 1;
ora-00283: recovery session canceled due to errors
ora-01610: recovery using the backup controlfile option must be done
sql> recover datafile 1 using backup controlfile;
ora-00274: illegal recovery option using
sql> recover database; //提示需使用备份的控制文件
ora-00283: recovery session canceled due to errors
ora-01610: recovery using the backup controlfile option must be done
sql> recover database using backup controlfile; //使用备份的控制文件恢复数据库
ora-00279: change 861998 generated at 05/29/2014 15:02:17 needed for thread 1
ora-00289: suggestion : /u01/app/oracle/arch1/1_15_848741495.dbf
ora-00280: change 861998 for thread 1 is in sequence #15 //提示恢复需要sequence号为15的日志
specify log: {<ret>=suggested | filename | auto | cancel}
ora-00308: cannot open archived log '/u01/app/oracle/arch1/1_15_848741495.dbf'
ora-27037: unable to obtain file status
ibm aix risc system/6000 error: 2: no such file or directory
additional information: 3
sql> select * from v$log; //查看日志组信息
group# thread# sequence# bytes members arc status
---------- ---------- ---------- ---------- ---------- --- ----------------
first_change# first_tim
------------- ---------
1 1 14 52428800 2 yes inactive
859720 29-may-14
3 1 13 52428800 2 yes inactive
858472 29-may-14
2 1 15 52428800 2 no current
859846 29-may-14
sql> select group#,member from v$logfile;
group#
----------
member
--------------------------------------------------------------------------------
3
/u01/app/oracle/oradata/metro/redo03.log
2
/u01/app/oracle/oradata/metro/redo02.log
1
/u01/app/oracle/oradata/metro/redo01.log
group#
----------
member
--------------------------------------------------------------------------------
1
/disk1/metro/redofile/redo01a.log
2
/disk1/metro/redofile/redo02a.log
3
/disk1/metro/redofile/redo03a.log
6 rows selected.
sql> recover database using backup controlfile;
ora-00279: change 861998 generated at 05/29/2014 15:02:17 needed for thread 1
ora-00289: suggestion : /u01/app/oracle/arch1/1_15_848741495.dbf
ora-00280: change 861998 for thread 1 is in sequence #15
specify log: {<ret>=suggested | filename | auto | cancel}
/disk1/metro/redofile/redo02a.log //输入查找到sequence号为15对应的日志
log applied.
media recovery complete.
sql> select checkpoint_change# from v$datafile_header; //恢复完成后检查点的scn
checkpoint_change#
------------------
863385
863385
863385
863385
863385
sql> alter database open
2 ;
alter database open
*
error at line 1:
ora-01589: must use resetlogs or noresetlogs option for database open
sql> alter database open resetlogs; //使用resetlogs打开库
database altered.
sql> select name from v$datafile //查看数据文件信息
2 ;
name
--------------------------------------------------------------------------------
+data/metro/datafile/system.257.848858337
/u01/app/oracle/oradata/metro/undotbs01.dbf
/u01/app/oracle/oradata/metro/sysaux01.dbf
/u01/app/oracle/oradata/metro/users01.dbf
/u01/app/oracle/oradata/metro/example01.dbf
sql>
如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！
点击进行留言回复
我要评论
网友评论