switch between physical snapshot standby database在物理快照备用数据库之间切换.pdf

建立快照备库

参考文档DataGuardConceptsand?Administration9.7ManagingaSnapshotStandbyDatabase

建立snapshotstandby

9.7.1ConvertingaPhysicalStandbyDatabaseintoaSnapshotStandbyDatabase

1.SYS@ysdb2sb1selectdatabase_rolefromv$database;

DATABASE_ROLE

PHYSICALSTANDBY

2.stopredoapplyifitisactive

SYS@ysdb2sb1alterdatabaserecovermanagedstandbydatabasecancel;

Databasealtered.

3.inanoraclerealapplicationcluster(oracleRAC)database,shutdownalloneinstance;

SYS@ysdb2sb1shutdownimmediate;

closed.

Databasedismounted.

ORACLEinstanceshutdown.

4.ensurethedatabaseismountedbutnotopen

SYS@ysdb2sb1startupmount;

ORACLEinstancestarted.

TotalSystemGlobalArea795127808bytes

FixedSize1347876bytes

VariableSize465571548bytes

DatabaseBuffers322961408bytes

RedoBuffers5246976bytes

Databasemounted

5.ensurethatthefastrecoverareahasbeenconfigured.Itisnotnecessaryforflashback

databasetobrenable;

SYS@ysdb2sb1shorameterdb_recovery_file_;

NAMETYPEVALUE