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

oracle 数据库恢复案例收藏（Oracle数据库恢复案例收藏） Own some small experiments, summed up the 10 kinds of Oracle file damage and recovery process I. Basic Situation of database server OS:RHEL 3 CPU:4 Intel (R), Xeon (TM), MP, CPU, 2.70GHz Mem:8G Swap:16G Disk:120G Oracle, Database, 10g, Enterprise, Edition, Release, 10.1.0.3.0 Two, backup mode The database runs in archive mode and RMAN multilevel incremental backups. Strategy is as follows: Set automatic backup of control files. Make a full backup of the database every three months (including all the databases and read-only tablespace), and back up the archive logs. Make a zero - level backup (not including read-only tablespace) every month, and backup the archive log. Do one level backup once a week and backup archived logs. Do a two level backup every day, and backup the archive log. Three, restore case All the prerequisites for recovery: complete backup of the database (including archive logs), control files, and SPFILE automatic backups. 1. corrupt a data file (1) fault simulation Delete data file: RM /u02/oradata/dbnms/users01.dbf Close database: shutdown immediate; ORA-01116:, error, in, opening, database, file, 4 ORA-01110:, data, file, 4:,/u02/oradata/dbnms/users01.dbf ora-27041：无法打开文件 Linux错误：2：没有这样的文件或目录 补充资料：3 强行关闭：sutdown中止； 启动数据库：启动； ora-01157：无法识别/锁定数据文件4看DBWR跟踪文件 ora-01110：数据文件4：/ / / / users01 U02 oradata dbnms DBF”。 （2）恢复步骤 RMAN目标系统”dbnms目录rmanuser @催化剂 运行{ 分配通道C1类型磁盘； 恢复数据文件4； 恢复数据文件4； SQL的数据库文件4在线”； 打开SQL数据库； 释放通道C1； } 目前作为数据库系统 选择instance_name，V $实例状态； instance_name状态 ---------------- ------------ dbnms开放 恢复成功 2。损坏全部数据文件 （1）故障模拟 删除数据文件：RM / U02 / oradata / dbnms / *。 DBF Force off: sutdown abort; Start database: startup; ORA-01157:, cannot, identify/lock, data, file, 1 - see, DBWR,, trace, file ORA-01110:, data, file, 1:,/u02/oradata/dbnms/system01.dbf (2) recovery step RMAN, target, sys@dbnms, catalog, rmanuser@cata Run{ Allocate, channel, C1, type, disk; Restore database; Recover database; SQLalter database open