• Arun Kumar

RMAN Point-In-Time-Recovery PITR

Take DB FULL Backup


Connect to the target DB and take DB full backup


RMAN> backup database plus archivelog;

Once backup is completed, check backup tag via below command:


RMAN> list backup of database summary;

In our case, the backup tag is: TAG20170115T105254


Create New User & Table


SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;

2017-01-15 10:54:53

SQL> create user ngr identified by ngr;
SQL> grant connect, resource, create session to ngr;
SQL> conn ngr/ngr
SQL> create table test(serial number(2),name varchar2(5));
SQL> insert into test values(1,'one');
SQL> insert into test values(2,'Two');
SQL> insert into test values(3,'Three');
SQL> insert into test values(4,'Four');
SQL> commit;

Simulate Failure


Delete all the datafiles from server. Connect as sysdba and


SQL> select name from v$datafile;

rm -rf <DF locations>

Start RMAN PITR


Kill the DB instance, if running. You can do shut abort or kill pmon at OS level

Start the DB instance and take it to Mount stage

Connect to RMAN and issue below command:


RMAN> RUN
{
RESTORE DATABASE from tag TAG20170115T105254;
RECOVER DATABASE UNTIL TIME "TO_DATE('2017-01-15 10:54:53', 'YYYY-MM-DD HH24:MI:SS')";
sql 'ALTER DATABASE OPEN RESETLOGS';
}


211 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir