Oracle 视图 V$RESTORE_POINT 官方解释,作用,如何使用详细说明
Oracle视图V$RESTORE_POINT用于查看当前实例的备份点,以及备份点的关联的数据文件。该视图主要包含以下几个字段:NAME,SCN,TIMESTAMP,DATABASE_INCARNATION#,DROPBOXTARGET,CREATION_TYPE,RESETLOGS_TIME等字段。
使用方法:
1、使用SQL查询备份点:SELECT * FROM V$RESTORE_POINT;
2、创建备份点:CREATE RESTORE POINT ;
3、删除备份点:DROP RESTORE POINT ;
4、手动管理备份点:ALTER RESTORE POINT OPTION1=VAL1 OPTION2=VAL2
官方英文解释V$RESTORE_POINT displays information about restore points.
Indicates whether flashback log files will be kept to ensure a flashback to this point (YES) or not (NO)
Approximate number of bytes of disk space currently tied up supporting this restore point, and which would no longer be tied up if this restore point is the oldest restore point and it is dropped. This will always be zero for non-guaranteed restore points.
Time that was specified when the restore point was created. If a time was not specified, this value is NULL.
Indicates whether the restore point must be explicitly deleted (YES) or not (NO)
Indicates whether there is a clean PDB restore point for this PDB (YES) or not (NO)
Pluggable database (PDB) incarnation number. This value is meaningful only for PDB restore points.
This column is useful in Oracle Data Guard environments. It indicates the method by which a restore point was created. Possible values:
YES The restore point was automatically replicated from the primary database to this database when this database was a standby database. The string _PRIMARY is appended to the name of such a restore point.
NO The restore point was created by a user and was not replicated from the primary database.
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$RESTORE_POINT 官方解释,作用,如何使用详细说明
相关文章
- Oracle 视图 V$SQL_PLAN_STATISTICS_ALL 官方解释,作用,如何使用详细说明
- Oracle 等待事件 rdbms ipc message 官方解释,作用,如何使用及优化方法
- Oracle数据库默认用户名密码解析(oracle默认用户名密码)
- Oracle时间数据分组技术实践(oracle时间分组)
- Win7快速连接Oracle数据库(win7连接oracle)
- 使用Oracle模拟器驾驭精准细节(oracle模拟器)
- 如何编写高效的Oracle插入存储过程?(oracle插入存储过程)
- 「Oracle官方教材」全面提升你的数据库技能!(oracle官方教材)
- 使用Oracle批量删除记录的简便之道(oracle批量删除)
- Oracle实现关联图片数据的有效方法(oracle关联图片数据)
- Oracle全连接语句的使用与技巧(oracle全连语句)
- C3PO连接Oracle构建强大的数据管理系统(c3po连接oracle)
- 探索 Oracle,打开全新的互联世界(by oracle)
- Oracle中最佳实践使用链接符号进行SQL合并(oracle中链接符)
- 深入了解Oracle二进制可视化(oracle二进制怎么看)
- Oracle 快捷使用指南(oracle使用方法)
- 掌握Oracle使用库语法,轻松操作数据库(oracle使用库语法)
- 怎样在Oracle中执行包(oracle中包怎么执行)
- Oracle中Q的使用技巧精彩纷呈(oracle中q的使用)
- 解决Oracle SH密码重置困境(oracle sh密码)
- Oracle 24550错误如何轻松缓解(oracle 24550)