export NLS_DATE_FORMAT='MON DD YYYY HH24:MI:SS'

we use backup controlfile for start rman session

rman nocatalog 

Recovery Manager: Release 8.1.7.4.0 - Production

RMAN> connect target

RMAN-06005: connected to target database: SMAP (DBID=1172039280)
RMAN-06009: using target database controlfile instead of recovery catalog


RMAN> @restore_controlfile
RMAN> @restore_system.rmn
RMAN> @restore_rbs.rmn


shutdown
cp /tmp/ctl.ctl /opt/oracle/oradata/smap/control02.ctl
startup mount


sqlplus /nolog
connect internal


SQL> @offline_drop.lst

Database altered.



SQL> recover database using backup controlfile;
ORA-00279: change 9293746 generated at 08/12/2003 01:41:02 needed for thread 1
ORA-00289: suggestion : /data1/arch/arch_1_6019.arc
ORA-00280: change 9293746 for thread 1 is in sequence #6019


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00279: change 9297787 generated at 08/12/2003 04:08:40 needed for thread 1
ORA-00289: suggestion : /data1/arch/arch_1_6020.arc
ORA-00280: change 9297787 for thread 1 is in sequence #6020
ORA-00278: log file '/data1/arch/arch_1_6019.arc' no longer needed for this
recovery


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/data1/oradata/smap/system01.dbf'


QL> recover database until change 9297790 using backup controlfile;
ORA-00279: change 9297787 generated at 08/12/2003 04:08:40 needed for thread 1
ORA-00289: suggestion : /data1/arch/arch_1_6020.arc
ORA-00280: change 9297787 for thread 1 is in sequence #6020


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

Log applied.
Media recovery complete.



alter database open resetlogs