Recovery of User Data

Contents: Recover from User Errors (Dropped table or Deleted Data) with RMAN using SCN, Time.

Recover from user errors dropped table or deleted data.

Steps

Scenario i.e

 è Take fresh backup.

 è Estimate time or SCN before deleted data or user errors.

Sql> select to_char(sysdate,’DD-MON-RRRR HH24:mi:SS’) from dual;

Or

Sql> select current_Scn from v$database;

 è Sql> conn hr/hr

 è Sql> delete from employees;

 è Sql> commit;

 è Sql> conn sys as sysdba

Recovery by using time

 è $>rman target / catalog rman_user/rman_user@catalog

 è Rman> run

  {

  Shutdown immediate;

  Startup mount;

  Restore database;

  Set until time ‘to_date(‘specify earlier time’,’dd-mon-rrrr hh24:mi:ss’);

  Recover database;

  Alter database open resetlogs;

  }

Recovery by using SCN

 è $>rman target / catalog rman_user/rman_user@catalog;

 è Rman> run

  {

  Shutdown immediate;

  Startup mount;

  Restore database;

  Set until scn ‘scn_number’;

  Recover database;

  Alter database open resetlogs;

  }