To obtain the current status and other information about each destination for an instance, query the V$ARCHIVE_DEST view.
Like, select dest_id, dest_name , status from v$archive_dest;
Archive Destination may have following status.
1)VALID: The user has properly initialized the destination, which is available for archiving.
2)INACTIVE: The user either has not provided or has deleted the destination information.
3)ERROR: An error occurred creating or writing to the destination file. If you see search for ERROR column for more detail.
4)FULL: Destination is full (no disk space).
5)DEFERRED: The user manually and temporarily disabled the destination.
6)DISABLED: The user manually and temporarily disabled the destination following an error; Look at ERROR column.
7)BAD PARAM: A parameter error occurred; refer to error column.
Related Link:
------------------
Change Archive Mode
No comments:
Post a Comment