Prerequisites for Flashback Database and Guaranteed Restore Points
Flashback Database
Configure the following database settings before enabling Flashback Database:
-Your database must be running in ARCHIVELOG mode.
-You must have a fast recovery area enabled.
-For Oracle Real Application Clusters (Oracle RAC) databases, the fast recovery area must be in a clustered file system or in ASM.
Guaranteed Restore Points
To use guaranteed restore points,the COMPATIBLE initialization parameter must be set to 10.2.0 or greater.
Steps to enable Flashback Database:
1. Connect to sqlplus as sysdba and set the desired value for Flashback retention target using below command.
SQL>ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320;
Here, Flashback retention target is set to window of 3 days(4320 Minutes), default value is 1 day (1440 Minutes).
2. Enable the Flashback Database feature for the whole database using the following command:
SQL>ALTER DATABASE FLASHBACK ON;
3.Use the following command to check if Flashback Database is enabled for your target database:
SQL>SELECT FLASHBACK_ON FROM V$DATABASE;
Howdy are using WordPress for your blog platform? I’m new to the blog world but I’m trying to
get started and set up my own. Do you need any html
coding expertise to make your own blog? Any help
would be greatly appreciated!
Also visit my web page; nordvpn coupons inspiresensation (http://tinyurl.com)
Hello there! I could have sworn I’ve been to this website before but after browsing through some of the post I
realized it’s new to me. Anyways, I’m definitely delighted I
found it and I’ll be book-marking and checking back often!
My web blog – nordvpn coupons inspiresensation
Have you ever thought about creating an e-book or guest authoring on other sites?
I have a blog centered on the same topics you discuss and would
really like to have you share some stories/information. I know
my viewers would value your work. If you are
even remotely interested, feel free to shoot me an e mail.
my web-site … Nordvpn Coupons Inspiresensation
You could certainly see your enthusiasm
within the article you write. The world hopes for even more
passionate writers such as you who aren’t afraid to mention how they believe.
Always follow your heart.
my web page :: nordvpn coupons inspiresensation – http://ur.link/nordvpn-coupons-inspiresensation–92771 –