配置快照数据库:
1)确保Primary和Standby启用了闪回(主要是Standby)
点击(此处)折叠或打开
- select FLASHBACK_ON from v$database;
FLASHBACK_ON
------------------------------------
YES
点击(此处)折叠或打开
- alter database flashback on;
点击(此处)折叠或打开
- alter database recover managed standby database cancel;
点击(此处)折叠或打开
- alter database convert to snapshot standby;
点击(此处)折叠或打开
- select DATABASE_ROLE from v$database;
DATABASE_ROLE
--------------------------------
SNAPSHOT STANDBY
5. 此时可以读写方式打开快照备用数据库。
点击(此处)折叠或打开
- ALTER DATABASE OPEN;
点击(此处)折叠或打开
- alter database convert to physical standby;
点击(此处)折叠或打开
- alter database recover managed standby database using current logfile disconnect;
可以看到,此时Standby有:
点击(此处)折叠或打开
- select DATABASE_ROLE from v$database;
DATABASE_ROLE
--------------------------------
PHYSICAL STANDBY