In this article we will explain how to restore the database to point in time using rman tape backup.
NOTE – This restore method will overwrite the existing database.(as we are restoring the database to same location). Please take necessary backup if required.

1. start the database in mount :


SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 8754618368 bytes
Fixed Size                  4646288 bytes
Variable Size            4160756336 bytes
Database Buffers         4429185024 bytes
Redo Buffers              160030720 bytes
Database mounted.
SQL> exit

2. connect to catalog db
rman target sys/oracle@TESTDBA catalog RMAN_cat/rman@catalogdb

Recovery Manager: Release - Production on Thu Jan 21 09:31:19 2016

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TESTDB(DBID=1258953048, not open)
connected to recovery catalog database
recovery catalog schema release is newer than RMAN release


3. Execute the below rman run block
run {
allocate channel t1 type SBT_TAPE;
allocate channel t2 type SBT_TAPE;
allocate channel t3 type SBT_TAPE;
set until time "TO_DATE('2016-01-20 16:00:00','yyyy-mm-dd hh24:mi:ss')";
restore database;
recover database;
release channel t1;
release channel t2;
release channel t3;


4. Open the database with resetlog:
RMAN> alter database open resetlogs;

Statement processed
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete