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

ADG repository v$archived_log view update:

The reason is that the v$archived_log view sequence will not be updated after cleaning up and archiving, and many file paths are empty, which makes it inconvenient to query.

Briefly write down the steps to clean up and update the view

Query the archiving life information of the database:

{

Col name for a70

Set linesize 200

Select name,sequence#,status,applied from v$archived_log

}

Step 1: clear all the information in the v$archived_log view

Sql > execute sys.dbms_backup_restore.resetCfileSection (11)

After execution, the v$archived_log view is nullified

Step 2: re-register the archive file information

RMAN > catalog start with 'PATH'

If you inquire again, you will find

Wait a while, the archive will automatically applied

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.