oracle数据库恢复案例收藏Oracle数据库恢复案例收藏.doc

文档介绍：oracle数据库恢复案例收藏(Oracle数据库恢复案例收藏)
Own some small experiments, summed up the 10 kinds of Oracle file damage and recovery se;
Recover database:
SQL, alter database open';
Release channel cl:
}
Sqlplus sys as SYSDBA
Select, instance_name, status, from, v$instance:
INSTANCE_NAME STATUS
Dbnms OPEN
Restore temporary files:
Alter, database, tempfile, , /u02/oradata/dbnms/temp01. dbf' , drop;
Alter, tablespace, temp, add, tempfile, ' /u02/oradata/dbnms/temp01. dbf' , size, 50M, AUTOEXTEND, on, , next, 5M, maxsize, unlimited:
recovery was successful
damage to non current online log members
(1) fault simulation
Delete log file: RM /u02/oradata/dbnms/
Close database: shutdown immediate:
Start database: startup:
Select * from v$logfile:
GROUP#, STATUS, TYPE, MEMBER, IS_
3 ONLINE /u02/oradata/dbnms/redo03. log NO
STALE, ONLINE, /u02/oradata/dbnms/redo02. log, NO
1, INVALID, ONLINE, /u02/oradata/dbnms/redo01. log, NO
1, STALE, ONLINE, /u02/oradata/dbnms/redoll. log, NO
STALE, ONLINE, /u02/oradata/dbnms/redo21. log, NO
STALE, ONLINE, /u02/oradata/dbnms/redol2. log, NO 3 ONLINE /u02/oradata/dbnms/redol3. log NO
2, STALE, ONLINE, /u02/oradata/dbnms/redo22. log, NO
ONLINE /u02/oradata/dbnms/redo23. log NO
ONLINE /u02/oradata/dbnms/redo31. log NO
4 ONLINE /u02/oradata/dbnms/redo32. log NO GROUP#, STATUS, TYPE, MEMBER, IS_
4 在线/ U02 / oradata / dbnms / redo33. log 没有
(2)恢复步骤
删除日志成员/ U02 / oradata / dbnms / redoOl 日志”；
添加日志成员/ U02 / oradata / dbnms / redoOl日志组1；
恢复成功
4。损坏非当前联机日志组
(1)故障模拟
1的所有文件删除日志文件组：
RM / U02 / oradata / dbnms / redoll, log
RM / U02 / oradata / dbnms / redo21. log
关闭数据库：立即关闭；
启动数据库：启动；
数据库安装。
ora-00313：开放为线程1组1成员登录失败
ora-00312：在线日志 1 线程 1: / / / / redoll U02 oradata dbnms 日志”。
ora-00312：在线日志 1 线程 1: / / / / redo21 U02 oradata dbnms 日志”。
ora-00312：在线日志 1 线程 1： / / / / redoO 1 U02 oradata dbnms 日志”。
(2)恢复步骤
更改数据库清除日志组1;
如果该日志组还没有归档，则用：
明确一个数据库日志组1;
打开数据库:
打开数据库;
恢复成功
5o损坏全部联机日志
故障模拟
删除日志文件：RM / U02 / orad