1，数据库状态检查

show configuration

validate database pdb;

validate database sbpdb; Author：Yuchong.Xu Email:vc.123@qq.com 测试文档，若有问题请及时沟通。

2，归档日志管理

只有备库应用日志之后主库才可以删除归档日志：

CONFIGURE ARCHIVELOG DELETION POLICY TO applied on all standby

3，redo,standby redo 日志管理

Online Redo Logs on Physical Standby (文档 ID 740675.1)

Operation on Redo logs in Physical Standby:

1. Add Redologs on Standby

2. Drop Redologs on Standby

3. Sync Redologs on Primary and Standby

Add Redo Logs on Standby

1. Stop Redo apply:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

2. Set STANDBY_FILE_MANAGEMENT to MANUAL.

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='MANUAL';

3. Add Redolog File Group:

SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('\U01\oracle\stdby10g\redo04.log') SIZE

100M;

Add as many Redo Logfile Groups (or Members) you want to add. Author：Yuchong.Xu Email:vc.123@qq.com 测试文档，若有问题请及时沟通。

4. Set STANDBY_FILE_MANAGEMENT to AUTO.

SQL> ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT='AUTO';

5. Start Redo Apply (Managed Recovery):

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM

SESSION;

4，temp tablespace 表空间管理

Data Guard Physical Standby - Managing temporary tablespace tempfiles (文档 ID 1514588.1)

临时文件不会自动创建，当主数据库添加临时文件，需要备库手动参数添加临时文件。

5，应用日志进程管理，开启实时查询

日志应用状态检查：

show database sbpdb;

关闭日志应用进程：

edit database sbpdb SET STATE='APPLY-OFF';

对应数据库命令：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL Author：Yuchong.Xu Email:vc.123@qq.com 测试文档，若有问题请及时沟通。

启动日志应用进程：

edit database sbpdb SET STATE='APPLY-ON';

对应数据库命令：

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT NODELAY

开启实时查询数据库：

DGMGRL> edit database sbpdb set state='read-only';

DGMGRL> edit database sbpdb SET STATE='APPLY-ON';

DGMGRL> show database sbpdb;