Explain The Steps To Perform The Point In Time Recovery With A Backup

1.	Explain The Steps To Perform The Point In Time Recovery With A Backup Which Is Taken Before The Resetlogs Of The Db?
Answer» We NEED to LIST the database incarnations by using list incarnation command. shutdown the database startup mount the database Issue reset database to incarnation to reset the incarnation. Restore the database using restore command (e.g restore until scn 23243) recover database Open the database using resetlogs command RMAN> list incarnation of database; RMAN>reset database to incarnation 5; RUN { SET until scn 234345; restore database; rec …. RMAN> list incarnation of database; RMAN>reset database to incarnation 5; run { set until scn 234345; restore database; rec ….

Explain The Steps To Perform The Point In Time Recovery With A Backup Which Is Taken Before The Resetlogs Of The Db?

Answer»

RMAN> list incarnation of database;
RMAN>reset database to incarnation 5;
RUN
{
SET until scn 234345;
restore database;
rec ….

RMAN> list incarnation of database;
RMAN>reset database to incarnation 5;
run
{
set until scn 234345;
restore database;
rec ….