SQL> show parameter recover

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +DATA
db_recovery_file_dest_size           big integer 2G
recovery_parallelism                 integer     0
SQL> alter database recover managed standby database cancel;

数据库已更改。

SQL> create restore point before_app guarantee flashback database;

还原点已创建。

primary:
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=DEFER;

SQL> alter database activate standby database;

数据库已更改。

SQL> startup mount force;
ORACLE 例程已经启动。

Total System Global Area 167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              67110244 bytes
Database Buffers           96468992 bytes
Redo Buffers                2945024 bytes
数据库装载完毕。
SQL> alter database set standby database to maximize performance;

数据库已更改。

SQL> alter database open;

数据库已更改。

SQL> select open_mode from v$database;

OPEN_MODE
----------
READ WRITE

SQL> startup mount force
ORACLE 例程已经启动。

Total System Global Area 167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              67110244 bytes
Database Buffers           96468992 bytes
Redo Buffers                2945024 bytes
数据库装载完毕。
SQL> flashback database to restore point before_app;

闪回完成。

SQL> alter database convert to physical standby;

数据库已更改。

SQL> startup mount force;
ORACLE 例程已经启动。

Total System Global Area 167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              67110244 bytes
Database Buffers           96468992 bytes
Redo Buffers                2945024 bytes
数据库装载完毕。
SQL> alter database recover managed standby database disconnect;

数据库已更改。

primary:
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

ITPub博客

open physical standby 为read write

最新文章