FLASHBACK ON while database open in Oracle 11.2 (11gR2)
Starting in Oracle 11gR2 high availability is further enhanced allowing enabling and disabling Flashback database while database is online. In Oracle 11gR2 the database does not need to be restarted to enable Flashback Database.
SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production CORE 11.2.0.1.0 Production TNS for 64-bit Windows: Version 11.2.0.1.0 - Production NLSRTL Version 11.2.0.1.0 - Production SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO SQL> select status from v$instance; STATUS ------------ OPEN SQL> alter database flashback on; Database altered. SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ YES SQL>
2 Comments »
Leave a Reply to ali Cancel reply
-
Archives
- February 2017 (1)
- November 2016 (1)
- October 2016 (1)
- May 2016 (2)
- March 2016 (3)
- December 2014 (2)
- July 2014 (1)
- June 2014 (6)
- May 2014 (5)
- February 2014 (1)
- December 2012 (2)
- November 2012 (8)
-
Categories
-
RSS
Entries RSS
Comments RSS
Please notify me of any new posts you put on your blogs. I like this blog very much. It is a great job done!!!!
Hi,
The users manage their subscriptions using the Email Subscription
Regards,