关于一个冷备恢复的案例
关于一个冷备恢复的案例，1）
冷备2）
建一张表T13）
切两次日志，三组REDO日志状态为两个ACTIVE一个CURRENT4）
Shutdown abort5）
删除所有dbf文件6）
恢复7）
验证表T1是否存在
1.数据库冷备SQL> shutdownimmediateORACLE instanceshut down.
SQL>host cp/u01/data/prod /u01/data/prod2
2.打开数据库新建一张表T1并切换日志为两个active一个current
SQL> startupORACLE instance started.
Total System Global Area
285212672 bytesFixed Size
1218968 bytesVariable Size
79693416 bytesDatabase Buffers
197132288 bytesRedo Buffers
7168000 bytesDatabase mounted.Database opened.SQL> select group#,status from v$log;
GROUP# STATUS---------- --------------------------------
1 INACTIVE
2 CURRENT
3 INACTIVE
SQL> create table t1 as select * fromdba_objects;
Table created.
SQL> select group#,status from v$log;
GROUP# STATUS---------- --------------------------------
1 INACTIVE
2 CURRENT
3 INACTIVE
SQL> alter system switch logfile;
System altered.
SQL> select group#,status from v$log;
GROUP# STATUS---------- --------------------------------
1 INACTIVE
2 ACTIVE
3 CURRENT
SQL> alter system switch logfile;
System altered.
SQL> select group#,status from v$log;
GROUP# STATUS---------- --------------------------------
1 CURRENT
2 ACTIVE
3 ACTIVE
SQL> shutdown abortORACLE instance shut down.
3.删除数据库所有dbf文件，模拟数据文件丢失故障SQL>host rm –rf /u01/data/prod/*.dbf
4.数据恢复SQL>host cp –rf /u01/data/prod2/*.dbf/u01/data/prod/SQL> startupORACLE instance started.
Total System Global Area
285212672 bytesFixed Size
1218968 bytesVariable Size
79693416 bytesDatabase Buffers
197132288 bytesRedo Buffers
7168000 bytesDatabase mounted.ORA-01113: file 1 needs media recoveryORA-01110: data file 1:'/u01/data/prod/system01.dbf'
SQL> recover database;Media recovery complete.SQL> alter database open;
Database altered.
SQL> select count(*) from t1;
COUNT(*)----------
50315
数据库得到完全恢复 谢谢LZ,最好多分享一些 生产环境中冷备很少用吧，不过感谢分享
页:
[1]