Create an oracle Restore Point and restore the database to the specified Restore Point

To implement the Restore point function of the Oracle database, the Oracle database must run in archivelog mode and be enabled
Flashback logging.

 

Procedure:

1. Shut down the Database Service: shutdown immediate;

2. Start the Database Service and mount:
Startup Mount;

3. Transfer the database to archievelog mode: Alter database archivelog;

4. Enable flashback logging: Alter database flashback on;

5. Open the database connection: Alter database open;

6. Create restore point: Create Restore Point restore_point_1;

7. modify some data at will

 

Before restoring data to the Restore point, you must restart the database to the Mount mode.

1. Shut down the database: shutdown immediate;

2. Start the database to the Mount mode: startup Mount;

3. Restore the database to restore_point_1: flashback database to restore point qa_gold;

 

Open the database and check whether the database data has been recovered.