How to create restore point and flashback Oracle database

1- Create Restore Point

Connect as SYSDBA

- Run script for create restore point:
Code:
SQL> create restore point RP_B4_UPLOAD guarantee flashback database;

- Run script shows restore point that created:
Code:
SQL> select * from v$restore_point order by time;

2- Flashback restore point

Remote to server by console: Using tool (Secure CRT, Putty…)

- List all databases name
Code:
$ cat /etc/oratab

- Select database
Code:
$ . oraenv
ORACLE_SID = [DBNAME] ? DBNAME1

The Oracle base remains unchanged with value /u01/app/oracle
$

- Logon database admin
Code:
$ sqlplus / as sysdba

- Show database name
Code:
SQL> select name from v$database;

NAME
-----------------
DBNAME1

- Shutdown database
Code:
SQL> shut immediate;

- Startup mount database
Code:
SQL> startup mount

- Flash back database with startup mount
Code:
SQL> flashback database to restore point RP_B4_UPLOAD;

- Startup database by open resetlogs
Code:
SQL> alter database open resetlogs;
Database altered
SQL>