Hey, thanks Mark that did the trick, Ill have to play with the control
file as well, although this is the fast way
###########################################
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Apr 24 21:03:02 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
startup
ORACLE instance started.
Total System Global Area 289406976 bytes Fixed Size 1248576 bytes Variable Size 96469696 bytes Database Buffers 184549376 bytes Redo Buffers 7139328 bytes Database mounted. Database opened.
archive log list;
Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 2 Current log sequence 2
shutdown immediate
Database closed. Database dismounted. ORACLE instance shut down.
startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes Fixed Size 1248576 bytes Variable Size 100664000 bytes Database Buffers 180355072 bytes Redo Buffers 7139328 bytes Database mounted.
recover database until cancel;Media recovery complete.
NO NEED TO CANCEL HERE...
alter database open resetlogs;
Database altered.
archive log list;
Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 1 Next log sequence to archive 1 Current log sequence 1
-- "Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."
-- //www.freelists.org/webpage/oracle-l