Flashback recovery Vs Rman

Question

Dear all,

REQ: Actually my requirement is to recover data of particular table which is deleted before 1 hour.

 I have configured RMAN and runnig my script for every 4 hours which takes the backup of particular tablespace.

I found the particular sid,sql_text,terminal from v$sql.

Now is it possible to find the system change number with the help of SID. 

Is it possible to recover with flashback recover.?

&

(Could any one please update the difference between flashback recovery and rman inconsistent.)

SOL: 

Thanks in advance.

Answer 1

Flashback : is meant for fastrecovery

if drop/delete operation happens unintentionally to bring back the object or objects's data..Flashback comes into picture without distrubing entire database  u can restore the object to prior point in time.

to get the object back: flashback table table_name to before drop;

to get back the data based on time/scn : falshback table table_name to scn 'scn_no';

for timestamp syntax go through unirac document or google it.

using Rman also we can do the same it's somehow confusing for the beginners...u can get the syntax from google also..

 

I found the particular sid,sql_text,terminal from v$sql ...? >>> what is dat u  found from this and why dis v$sql came into picture when u are thinking about recovery.....

 

Now is it possible to find the system change number with the help of SID >>> what is this question...?

to find the scn of the database...use select current_scn from v$database;