Please keep in mind till the Transactions are in Undo until then the DB can be restored ..
To take Restore Point ..
SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
NO
SQL> Alter database flashback on;
CREATE RESTORE POINT Jan07_2107;
conn / as sysdba
shutdown immediate;
startup mount;
flashback database to restore point Jan07_2107;
alter database open resetlogs;
desc V$RESTORE_POINT;
select NAME,SCN,STORAGE_SIZE,TIME from V$RESTORE_POINT;
NAME SCN STORAGE_SIZE TIME
——— ——– ———————- ———————————————
TEST 2861296 0 26-MAR-18 07.45.02.000000000 PM
drop RESTORE POINT TEST;
Guaranteed Restorepoint can be taken using below command :
CREATE RESTORE POINT Jan07_2107 GUARANTEE FLASHBACK DATABASE;
11 thoughts on “FLASHBACK DATABASE”
carvedilol 6.25mg usa carvedilol cheap buy generic amitriptyline
order amoxicillin 250mg online order stromectol 6mg generic ivermectin 6mg oral
buy pepcid 20mg pill oral remeron 15mg remeron 30mg pill
tricor 200mg uk cheap viagra pill viagra pills
cialis 20mg ca pills for ed top rated ed pills
serophene canada buy prednisolone 40mg online cheap prednisolone 20mg without prescription
erection pills that work order sildenafil 100mg for sale order proscar 1mg online cheap
order isotretinoin 20mg online order ampicillin ampicillin without prescription
ondansetron 4mg pill sulfamethoxazole oral trimethoprim oral
buy modafinil 100mg without prescription lisinopril sale purchase lopressor online cheap
prednisolone 5mg usa buy prednisolone 40mg without prescription buy lasix without prescription diuretic