We're here to help!

list_v$database.txt

Follow

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



Have more questions? Submit a request

Comments