rman 恢复实例.docVIP

rman 恢复实例 rman 恢复实例 个人分类：数据库原理 1. 模拟： 数据文件丢失 1） 备份数据库 RMAN backup database format H:\INTEL_DB_DUMPS\O07DMS0\rman\O07DMS0_full_%U; 2）模拟数据库操作 A105024@O07DMS0create table test (id number); Table created. A105024@O07DMS0insert into test values(1); 1 row created. A105024@O07DMS0commit; Commit complete. 3） 模拟数据文件丢失 RMAN shutdown immediate; 在OS删除文件： I:\INTEL_DATA\O07DMS0\USERS_01.O07DMS0 尝试启动数据库失败： RMAN startup connected to target database (not started) Oracle instance started database mounted RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of startup command at 10/14/2011 05:03:25 ORA-01157: cannot identify/lock data file 4 - see DBWR trace file ORA-01110: data file 4: I:\INTEL_DATA\O07DMS0\USERS_01.O07DMS0 4） 执行恢复 RMAN restore datafile 4; Starting restore at 14-OCT-11 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=135 device type=DISK channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00004 to I:\INTEL_DATA\O07DMS0\USERS_01.O07DMS0 channel ORA_DISK_1: reading from backup piece H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1KMP27FQ_1_1 channel ORA_DISK_1: piece handle=H:\INTEL_DB_DUMPS\O07DMS0\RMAN\O07DMS0_FULL_1KMP27FQ_1_1 tag=TA045833 channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:00:35 Finished restore at 14-OCT-11 RMAN recover datafile 4; Starting recover at 14-OCT-11 using channel ORA_DISK_1 starting media recovery media recovery complete, elapsed time: 00:00:00 Finished recover at 14-OCT-11 5） 打开数据库验证 RMAN alter database open; database opened A105024@O07DMS0select * from test; ID ---------- 1 2. 模拟：控制文件丢失 1） 备份数据库 RMAN backup database format H:\INTEL_DB_DUMPS\O07DMS0\rman\O07DMS0_full_