Check items before deleting oracle archive logs, oracle Archive

Check items before deleting oracle archive logs, oracle Archive

This article is an original article,

Reprinted please indicate the source

Http://blog.csdn.net/msdnchina/article/details/41413313

To delete archived logs, you must confirm the following in advance:

1. Whether it is a dg Environment: if it is a dg Environment, check whether the archived logs have been applied to the slave database.
2. Whether logical replication software such as ogg is installed: Check the archive log of the ogg Extraction Process's read checkpoint (ggsci> info extfull showch ).

3. Check whether the recover status of datafile (v $ recover_file view) exists: the query result of this view should be 0, and 0 indicates that there is no datafile to be recovered.

Therefore, when the archive is full, the mv is wonderful.