Troubleshooting

Oracle

Audience
Public
Technology Integrations
Oracle
Source Type
Documentation

Check v$dataguard_status

Assuming that the standby is archive dest 2. If not, change the filter condition accordingly.


SQL > select severity,error_code,message,to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') from v$dataguard_status where dest_id=<Archive Dest. ID>;