list_v$database.txt
This file contains the output of the Oracle Data Dictionary view V$DATABASE. This information may useful when looking to troubleshooting problems.
Sample file:
List V$DATABASE select * from v$database DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_TIME LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE# CONTROLFILE_TYPE CONTROLFILE_CREATED CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE# CONTROLFILE_TIME OPEN_RESETLOGS VERSION_TIME OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL REMOTE_ARCHIVE ACTIVATION# SWITCHOVER# DATABASE_ROLE ARCHIVELOG_CHANGE# ARCHIVELOG_COMPRESSION SWITCHOVER_STATUS DATAGUARD_BROKER GUARD_STATUS SUPPLEMENTAL_LOG_DATA_MIN SUPPLEMENTAL_LOG_DATA_PK SUPPLEMENTAL_LOG_DATA_UI FORCE_LOGGING PLATFORM_ID PLATFORM_NAME RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN FLASHBACK_ON SUPPLEMENTAL_LOG_DATA_FK SUPPLEMENTAL_LOG_DATA_ALL DB_UNIQUE_NAME STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_STATUS FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD FS_FAILOVER_OBSERVER_PRESENT FS_FAILOVER_OBSERVER_HOST CONTROLFILE_CONVERTED PRIMARY_DB_UNIQUE_NAME SUPPLEMENTAL_LOG_DATA_PL MIN_REQUIRED_CAPTURE_CHANGE# CDB CON_ID PENDING_ROLE_CHANGE_TASKS CON_DBID FORCE_FULL_DB_CACHING 961058349 SRC 2015-08-02 22:32:13 1594143 2015-08-02 22:32:15 1 2014-07-07 05:38:47 ARCHIVELOG 6302728 6294409 CURRENT 2015-08-02 22:32:13 190920 6305567 2017-02-01 19:15:03 NOT ALLOWED 2015-08-02 22:32:13 READ WRITE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE ENABLED 961079853 961079853 PRIMARY 6302728 DISABLED NOT ALLOWED DISABLED NONE YES NO NO NO 13 Linux x86 64-bit 2 2 6306078 NO NO NO src 0 DISABLED 0 NO NO YES 0 NOT APPLICABLE 907256101 NO