8、通过日志发现DG库中是正常的,可以通过在主库中做日志切换观察备库中的日志是否打印,若能正常打印则是正常的
在主库中做日志切换:
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 115
Next log sequence to archive 117
Current log sequence 117
SQL> alter system switch logfile;
SQL> /
System altered.
SQL> /
System altered.