Flashback database to restore point
I use this procedure when it is needed to test some DDL and DML statements on a test database. If changes did not work properly, you can flashback database to a point in time before changes started. SQL> SELECT INST_ID, flashback_on, log_mode FROM gv$database; INST_ID FLASHBACK_ON LOG_MODE ---------- ------------------ ------------ 1 NO NOARCHIVELOG So, it is needed to activate flashback and archivelog mode to do that, please see Activate archivelog mode on a database Second step is to enable flashback: SQL> alter database flashback on; Database altered. And after that, we can see RVWR oracle process is started. [oracle@ODIGettingStarted flash_recovery_area]$ ps -ef | grep -i rvwr oracle 10163 1 0 06:04 ? 00:00:00 ora_rvwr_orcl To make sure we can rollback database to restoration point, we make a guarantee restore point, witch means that database will stop in case flashback destination becomes full.. SQL> create res...