Delete several checks before the Oracle archive log

This article is an original article,

Reprint please indicate the source

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

To delete an archive log, you need to confirm several points in advance:

1. Whether it is a DG environment: if the DG Environment, you need to confirm that the archive log on the standby library is applied to complete.
2. Is there a logical replication software such as Ogg: Need to confirm on which archive log the read checkpoint (ggsci> info extfull showch) of the Ogg extraction process

3. Whether there is a datafile (v$recover_file view) of the recover state: The query result of this view should be 0 is the best, 0 means there is no need to recover datafile.

As a result, it is better to have an archive full or MV.

Delete several checks before the Oracle archive log