dataguard备份与恢复测试.docxVIP

dataguard 备份与恢复测试直被公司的 dataguard 的备份所困扰，备份主库，夜 晚的同事不满意，不备份又不放心，因为我这里有需要恢复 到当天的前几天，几周的可能性。所以，测试了在standby 到当天的前几天，几周的可能性。所以，测试了在 standby database 备份数据文件， 在 primary database 做控制文件， 日志文件备份， 以及恢复的测试。 1, 将 standby database 至 为只读模式，然后备份全部的数据文件 run{ allocate channel c1 type disk ; backup database format c:\back\full%d_%t_%s_%p.bak; release channel c1; }2 ，备份完成后，对 primary database 做控制文件， 日志文 件的备份 run{ allocate channel c1 type disk ; sql alter system archive log current; backup archivelog all format c:\arch%d_%t_%s_%p.bak ; release channel c1; backup current controlfile format c:\con%d_%t_%s_%p.bak;3 ，假设所有的库都不能用，重 新找台机器恢复 SQL*Plus: Release 10.1.0.2.0 - Production on 星期四 3 月 22 10:07:47 2007Copyright (c) 1982, 2004, Oracle. All rights reserved.SQLgt; connect sys/oracle@db001 as sysdba ; Connected to an idle instance. SQLgt; create spfile from pfile=c:\init.bak;File created.SQLgt; startup nomount; ORACLE instance started.Total System Global Area Fixed Size171966464 bytes Fixed Size 787988 bytes Variable Size Variable Size 145750508 bytes Variable Size Variable Size 145750508 bytes Database Buffersbytes Redo Buffers 262144 bytes SQLgt; exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr oduction With the Partitioning, OLAP and Data Mining options 恢复 控制文件 C:\Documents and Settings\Administratorgt;rman target sys/oracle@db001Recovery Manager: Release 10.1.0.2.0 - ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.connected to target database: db001 (not mounted)RMANgt; restore controlfile from C:\CONTROL.BAK;Starting restore at 22-3 月 -07 using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=160 devtype=DISKchannel ORA_DISK_1: restoring controlfile channel ORA_DISK_1: restore complete output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB00 1\CONTROL01.CTL output filename=C:\ORACLE\PRODUCT\10.1.0\ORADATA\DB00 1\CONTROL02.CTL output filename=C:\ORACLE\PRODUCT\10.1