【Oracle】DG中物理备库、快照备库的相互转换

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SHUTDOWN IMMEDIATE

STARTUP MOUNT;

SHOW PARAMETER db_recovery_file_dest;

#如何没有配置快速恢复区，请使用以下SQL语句配置：

ALTER SYSTEM SET db_recovery_file_dest_size=大小;

ALTER SYSTEM SET b_recovery_file_dest=’目录’;

ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

ALTER DATABASE OPEN;

二、快照备库切换物理备库

1.如果是rac环境，只保留一个实例，关闭其他实例

2.确保数据库状态为MOUNTED

3.使用如下SQL语句完成切换

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

4.切换后数据库状态为NOMOUNT,此时必须重启数据库，也就是SHUT DOWN IMMEDIATE然后再STARTUP,如果直接ALTER
DATABASE OPEN,会报如下错误。

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00750: database has been previously mounted and dismounted

5.物理备库应用日志

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

巴特西