try alter database open resetlogs
>From: Dan Todor <todor.dan_at_romobtec.ro>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Recovery
>Date: Tue, 02 May 2000 01:22:51 -0800
>
>Hello, everybody!
>
>I have a 'little' problem with backup and recovery. I'm just testing our
>backup and recovery strategy, and I'm geting some errors when I try to
>make a complete recovery. Here is the framework:
>
>BACKUP:
>- database running in archivelog
>- the backup script is like in the docs, with alter tablespace begin
>backup, host copy, alter end backup, then backup controlfile to...., and
>then archiving to tape, including archived logs
>
>RECOVERY:
>- I restore all the files from tape;
>- startup nomount the database;
>- set autorecovery on;
>- recover database using backup controlfile;
>- the Oracle server applies succesfully all the archived logs;
>- alter database open -> here I get 'file sys01.ora needs media
>recovery'- it's the file that contains the system tablespace ...... :-(
>
>Anybody , any ideas ?
>
>--
>Best regards,
>Dan Todor
>---
>
>
>--
>Author: Dan Todor
> INET: todor.dan_at_romobtec.ro
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Tue May 02 2000 - 05:30:21 CDT
