Oracle 视图 V$FOREIGN_ARCHIVED_LOG 官方解释,作用,如何使用详细说明
V$FOREIGN_ARCHIVED_LOG 视图用于查看网络环境中的远程 AVDF 实例中产生的归档日志信息。
它可以用来查看归档文件名、归档文件状态、归档文件应用点和其他信息,帮助用户管理远程 AVDF 实例中的归档文件。
使用该视图时,用户可以按照「INSTANCE_NAME」和「SEQUENCE#」字段来查看远程 AVDF 实例中产生的每一个归档文件。
官方英文解释V$FOREIGN_ARCHIVED_LOG can be queried on a logical standby database to find out the list of foreign archived logs received by a database.
No rows are returned for this view on a physical standby database.
Archived log file name. If set to NULL, either the log file was cleared before it was archived or an RMAN BACKUP command with the delete input option was executed to back up archivelog all (RMAN backup archivelog all delete input;).
Original destination from which the archive log was generated. The value is 0 if the destination identifier is not available
Redo log block size. This is the logical block size of the archived log, which is the same as the logical block size of the online log from which the archived log was copied. The online log logical block size is a platform-specific value that is not adjustable by the user.
Indicates whether the online redo log was archived (YES) or whether RMAN only inspected the log and created a record for future application of redo logs during recovery (NO).
Indicates whether the archivelog has been applied to its corresponding standby database (YES) or not (NO). The value is always NO for local destinations.
This column is meaningful at the standby site for the ARCHIVED_LOG entries with REGISTRAR="RFS" (which means this log is shipped from the primary to the standby database). If REGISTRAR="RFS" and APPLIED is NO, then the log has arrived at the standby but has not yet been applied. If REGISTRAR="RFS" and APPLIED is YES, the log has arrived and been applied at the standby database.
You can use this field to identify archivelogs that can be backed up and removed from disk.
Indicates whether an RMAN DELETE command has physically deleted the archived log file from disk, as well as logically removing it from the control file of the target database and from the recovery catalog (YES) or not (NO)
Indicates whether the log contains the start of a LogMiner dictionary (YES) or not (NO)
Indicates whether the log contains the end of a LogMiner dictionary (YES) or not (NO)
Indicates whether the archived redo log contains the end of all redo information from the primary database () or not ()
Redo thread number of the instance that performed the archival operation. This column differs from the THREAD# column only when a closed thread is archived by another instance.
Indicates whether the file was created in the fast recovery area (YES) or not (NO)
Indicates whether the archive log was generated as the result of a FAL request (YES) or not (NO)
Possible values are as follows:
SWITCHOVER Shows archived redo log files that are produced at the end of a switchover
TERMINAL Shows archived redo log files produced after a failover
RESETLOGS Shows online redo log files archived on the primary database after an ALTER DATABASE OPEN RESETLOGS statement is issued
ACTIVATION Shows any log files archived on a physical standby database after an ALTER DATABASE ACTIVATE STANDBY DATABASE statement is issued
empty string Any empty string implies that the log is just a normal archival and was not archived due to any of the other events
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$FOREIGN_ARCHIVED_LOG 官方解释,作用,如何使用详细说明
相关文章
- ORA-01197: thread string only contains one log ORACLE 报错 故障修复 远程处理
- ORA-04940: unsupported optimization of Oracle binary, check alert log for more info ORACLE 报错 故障修复 远程处理
- Oracle 视图 V$FLASHBACK_DATABASE_LOG 官方解释,作用,如何使用详细说明
- Oracle 视图 V$LOG 官方解释,作用,如何使用详细说明
- Oracle 参数 LOG_ARCHIVE_DEST 官方解释,作用,如何配置最优化建议
- Oracle异地备份技术极致保障数据安全(oracle异地备份)
- Oracle 等待事件 Log archive I/O 官方解释,作用,如何使用及优化方法
- Oracle 等待事件 log file sequential read 官方解释,作用,如何使用及优化方法
- Oracle 等待事件 log file switch (checkpoint incomplete) 官方解释,作用,如何使用及优化方法
- 支持Oracle官方电话支持:尽在其中!(oracle官方电话)
- 快速查看数据库信息:Oracle视图的作用(oracle视图的作用)
- 求Oracle中MAX函数的最大值(oracle取最大值函数)
- Oracle查看表注释的简单方法(oracle查看表的注释)
- 成为Oracle官方认证培训机构的机会与优势(oracle官方认证培训机构)
- MSSQL与Oracle:数据库管理系统备选方案比较(mssql与oracle)
- Oracle中使用正则表达式的实践(oracle的正则表达式)
- Oracle官方中文版下载—随时随地!(oracle中文官网下载)
- 如何关闭Oracle回收站?(关闭oracle回收站)
- Oracle数据库:高效追踪SQL语句的工具分享(oracle跟踪sql工具)
- Oracle关闭后的启动之路(oracle 关闭后启动)
- 数据库使用C语言轮询Oracle数据库(c 轮询oracle)
- Oracle官方JDK下载可靠安全快捷(jdk官网oracle)
- 数据库迁移ADS导入Oracle(ads导入oracle)
- 了解Oracle的基本主要功能(oracle 主要功能)
- 事务处理Oracle数据库支持实现(oracle事物支持)
- Oracle数据库中查看伪列的方法(oracle 伪列查看)
- 使用Oracle构建自增主键方案(oracle主键自增方式)
- 深度挖掘Oracle性能优化日志(oracle优化log)
- 的空间Oracle分配不足4GB存储空间的技巧(oracle中小于4GB)
- Oracle中间产品丰富多元化提升数据管理能力(oracle中间产品)
- Oracle作业管理详情披露(oracle job明细)