Quote Originally Posted by LKBrwn_DBA

Just restore the cotrolfile:
PHP Code:
CONNECT TARGET /
CONNECT CATALOG RMANCAT/FOOBAR@RMAN
STARTUP FORCE NOMOUNT PFILE
=$ORACLE_HOME/DBS/INIT.ORA
RUN 
{
 
ALLOCATE CHANNEL CH1 TYPE DISK;
 [
B]SET UNTIL SCN=1447485626;[/B]
 
RESTORE CONTROLFILE;
 
SQL ‘ALTER DATABASE MOUNT’;



is Scn# optional or mandatory?
if SCN# is mandatory then how can we determine the SCN No?