Shulou(Shulou.com)06/01 Report--

Main library

1.1 check error view v$ ARCHIVE_DEST

Col dest_name for a30

Set line 220

Col error for a30

Select dest_name,status,error from v$ ARCHIVE_DEST

To run the example, an error ORA-12541: TNS:no listener is reported in error. The reason is that the destination LISTENER is not started, and the error will disappear after starting.

After startup

Run the above query again and the error disappears

Note: the above error can also be found in the alert log

1.2 check whether the archive has been applied applied represents yes has been applied

Alter session set nls_date_format='yyyy-mm-dd hh34:mi:ss'

Col name for a55

SELECT THREAD#, name,SEQUENCE#, applied,next_time FROM V$ARCHIVED_LOG where next_time > '2020-05-01'

Run the example (the slave database has not been applied since the 38th archive log because it did not start the log application command.)

1.3 check roles

Select open_mode,database_role from v$database

Prepare the database to query whether there is a MRP0 process

SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#, BLOCKS FROM V$MANAGED_STANDBY

Examples are as follows:

Note: if the slave startup does not execute the following command, there will be no MRP0 process

Alter database recover managed standby database using current logfile disconnect

Prepare the database to view the log application.

Alter session set nls_date_format='yyyy-mm-dd hh34:mi:ss'

Col name for a50

SELECT THREAD#, name,SEQUENCE#, applied,next_time FROM V$ARCHIVED_LOG where next_time > '2020-05-01'

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.