Oracle教程 2023-02-24

Oracle 视图 DBA_REGISTERED_ARCHIVED_LOG 官方解释，作用，如何使用详细说明

对象

Oracle视图DBA_REGISTERED_ARCHIVED_LOG用来显示登记的归档日志信息，它的目的是为了实现数据库回滚和数据库恢复操作。它维护归档日志，其中包含归档日志的信息，比如归档日志的名称、归档日志的地址等。

使用此视图，一般可以用来查看登记的归档日志信息，可以获取当前对应库中活动该归档日志文件信息，例如归档日志文件名、归档日志文件大小等；也可以用来删除未使用的自动归档日志，以空间释放出来，并可以用来构建RMAN的备份和恢复方案。

DBA_REGISTERED_ARCHIVED_LOG displays information about all registered archived logfiles in the database.

Column	Datatype	NULL	Description
`CONSUMER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Consumer name of the archived logs
`SOURCE_DATABASE`	`VARCHAR2(128)`		Name of the database which generated the redo logs
`THREAD#`	`NUMBER`	`NOT NULL`	Thread number of the archived redo log. The thread number is `1` for a single instance. For Real Application Clusters, this column will contain different numbers.
`SEQUENCE#`	`NUMBER`	`NOT NULL`	Sequence number of the archived redo log file
`FIRST_SCN`	`NUMBER`	`NOT NULL`	System change number (SCN) of the current archived redo log
`NEXT_SCN`	`NUMBER`		System change number (SCN) of the next archived redo log
`FIRST_TIME`	`DATE`		Date and time of the current archived redo log
`NEXT_TIME`	`DATE`		Date and time of the next archived redo log
`NAME`	`VARCHAR2(513)`		Name of the archived redo log
`MODIFIED_TIME`	`DATE`		Time when the archived redo log was registered
`DICTIONARY_BEGIN`	`VARCHAR2(3)`		Indicates whether the beginning of the dictionary build is in the archived redo log (`YES`) or not (`NO`)
`DICTIONARY_END`	`VARCHAR2(3)`		Indicates whether the end of the dictionary build is in the archived redo log (`YES`) or not (`NO`)
`PURGEABLE`	`VARCHAR2(3)`		Indicates whether the redo log can be permanently removed (`YES`) or not (`NO`)
`RESET_LOGS_CHANGE#`	`NUMBER`	`NOT NULL`	Resetlogs change number of the database when the log was written
`RESET_TIMESTAMP`	`NUMBER`	`NOT NULL`	Resetlogs time of the database when the log was written

分享到：