首页 / FLASH / orale flashback

orale flashback

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了orale flashback，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含2778字，纯文字阅读大概需要4分钟。

内容图文

使用oracle的FLASHBACK功能在SAP项目升级中极大的缩短了项目升级失败回滚的时间

设置flashback 的系统查询

SQL>col NAME for A30
SQL>col value for A30
SQL> select NAME,value from v$parameter where name =‘db_flashback_retention_target‘or name =‘db_recovery_file_dest‘or name =‘db_recovery_file_dest_size‘;

NAME                           VALUE
------------------------------ ------------------------------db_recovery_file_dest
db_recovery_file_dest_size     0
db_flashback_retention_target  1440

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------
NO

设置flashback,按以下顺序哦，不然会出错哦

SQL> alter system set db_recovery_file_dest_size=4000M scope=both;

System altered.

SQL>alter system set db_recovery_file_dest = ‘/oracle/C11/flashback_dest‘ scope=both;

System altered.

SQL> alter system set db_flashback_retention_target=2880 scope=both ;

System altered.

SQL>select NAME,value from v$parameter where name = ‘db_flashback_retention_target‘ or name = ‘db_recovery_file_dest‘ or name = ‘db_recovery_file_dest_size‘;

NAME                           VALUE
------------------------------ ------------------------------
db_recovery_file_dest          /oracle/C11/flashback_dest 
db_recovery_file_dest_size     4194304000
db_flashback_retention_target  2880


SQL>select flashback_on from v$database;

FLASHBACK_ON
------------------NO

SQL> create restore point C11_FB guarantee flashback database ;

Restore point created.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------RESTORE POINT ONLY

SQL>alter database flashback on ;

Database altered.

SQL>select flashback_on from v$database;

FLASHBACK_ON
------------------
YES

查看使用情况

SQL> select name,(space_used/1024/1024),(space_limit/1024/1024) from v$recovery_file_dest;

NAME                           (SPACE_USED/1024/1024) (SPACE_LIMIT/1024/1024)
------------------------------ ---------------------- -----------------------/oracle/C11/flashback_dest                   10004000

系统回滚

            flashback database to restore point C11_FB

            

            alter database open resetlogs ;

            drop restore point C11_FB;

 

系统升级之后删除flashback

SQL>  drop restore point C11_FB;

Restore point dropped.

SQL>alter system reset db_recovery_file_dest_size scope=spfile ;

System altered.
SQL>alter system reset db_recovery_file_dest scope=spfile ;

System altered.

SQL> select flashback_on from v$database;

FLASHBACK_ON
------------------RESTORE POINT ONLY


SQL> alter database flashback off;

Database altered.

SQL>select flashback_on from v$database;

FLASHBACK_ON
------------------NO

SQL> select NAME from v$restore_point;

no rows selected


SQL>select name,(space_used/1024/1024),(space_limit/1024/1024) from v$recovery_file_dest;

NAME                           (SPACE_USED/1024/1024) (SPACE_LIMIT/1024/1024)
------------------------------ ---------------------- -----------------------/oracle/C11/flashback_dest                      04000

原文：https://www.cnblogs.com/tingxin/p/12197286.html

内容总结

以上是互联网集市为您收集整理的orale flashback全部内容，希望文章能够帮你解决orale flashback所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/1289691.html

来源：【匿名】