I am running
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Seem it not Enterprise edition, so I not able to use flashback features
SQL> ALTER DATABASE FLASHBACK ON;
ALTER DATABASE FLASHBACK ON
*
ERROR at line 1:
ORA-00439: feature not enabled: Flashback Database
SQL> SELECT flashback_on, log_mode FROM v$database;
FLASHBACK_ON |LOG_MODE
-------------|-------------
NO |NOARCHIVELOG
As you see my database are running with NOARCHIVELOG mode and my filesystem is ext3
I had to do CRUD test with my system + another vendor. and after that I want to revert back to the state of "restore point" (before testing). In short word, I don't want to keep test data inside my database.
There is discussion here, but this is using flashback features. But how about for my case?
Is there any solution suitable for me?
Best Answer
Without archivelog mode and depending on size of database and downtime you have only two options either volume snapshot or rman cold backup.
Below is steps by using rman cold backup.
Edit:You can skip creating restore point and just restore and recover database with rman