Oracle11gR2 Aactive DataGuard(手动)安装部署及维护文档（二）之快照及管理

概要：

第三部分：快照standby数据库

第四部分: 物理备库转换为逻辑备库

第五部分: 管理physical dataguard

 

内容：

l          第三部分：快照standby数据库

快照备库的作用：

可以暂时将物理备用数据库转换为可更新的数据库，称为快照备用数据库 (Snapshot Standby Database)。在这一模式中，可以运行您的应用程序（它可能会更改许多表），然后再分析其影响。评估影响后，您可以将数据库转换为备用数据库，然后进行常规恢复。您可以在数据库中创建一个恢复点来完成这一过程，使用 Flashback 数据库特性“闪回”至该点，恢复所有的更改。、

 

转换快照备库的步骤：

1.        在备库启动恢复进程。

SQL> alter database recover managed standby database disconnect;

数据库已更改。

2.        终止恢复进程。

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

SQL> alter database recover managed standby database cancel;

数据库已更改。

 

3.        转换为快照备用数据库。

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

SQL> alter database convert to snapshot standby;

数据库已更改。

 

Alter日志内容：

alter database convert to snapshot standby

Starting background process RVWR

Thu Jun 23 17:07:55 2011

RVWR started with pid=30, OS id=13133

Allocated 7814440 bytes in shared pool for flashback generation buffer

Created guaranteed restore point SNAPSHOT_STANDBY_REQUIRED_06/23/2011 17:07:53

krsv_proc_kill: Killing 4 processes (all RFS)

Thu Jun 23 17:08:04 2011

CLOSE: killing server sessions.

CLOSE: all sessions shutdown successfully.

Thu Jun 23 17:08:05 2011

SMON: disabling cache recovery

Begin: Standby Redo Logfile archival

End: Standby Redo Logfile archival

RESETLOGS after incomplete recovery UNTIL CHANGE 5788110

Resetting resetlogs activation ID 962622994 (0x39607612)

Online log /u01/app/ora11g/oradata/PRIDB1/onlinelog/o1_mf_1_6mf7b92o_.log: Thread 1 Group 1 was previously cleared

Online log /u01/app/ora11g/fla/PRIDB1/onlinelog/o1_mf_1_6mf7bbdv_.log: Thread 1 Group 1 was previously cleared

Online log /u01/app/ora11g/oradata/PRIDB1/onlinelog/o1_mf_2_6mf7bds9_.log: Thread 1 Group 2 was previously cleared

Online log /u01/app/ora11g/fla/PRIDB1/onlinelog/o1_mf_2_6mf7bfp2_.log: Thread 1 Group 2 was previously cleared

Online log /u01/app/ora11g/oradata/PRIDB1/onlinelog/o1_mf_3_6mf7bhsx_.log: Thread 1 Group 3 was previously cleared

Online log /u01/app/ora11g/fla/PRIDB1/onlinelog/o1_mf_3_6mf7bjrt_.log: Thread 1 Group 3 was previously cleared

Standby became primary SCN: 5788108