Re: RESETLOGS w/o incomplete recovery

From: Bob <orcl_at_comcast.net>
Date: Mon, 24 Apr 2006 21:11:03 -0400
Message-ID: <444D7727.8060006@comcast.net>

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

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."

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 24 2006 - 20:11:03 CDT