###################################
# Perte d'un redolog - Récupération
#
# 08.05.2003 - SKoller
###################################

sqlplus "/as sysdba"

startup mount;

# redolog current or not.
#select * from v$logfile;
select * from v$log;

# si le redolog est "inactive", alors:
alter database clear logfile '/oracle/oradata/bd02/redo01.log';
alter database open;

sinon...

#si le redolog est "current", alors:
recover database until cancel;
alter database open resetlogs;

shutdown immediate;
startup