Re: Oracle 8i crashed: system ts needs more recovery - how do I recover from this?

From: Mark Burgess <mark_at_burgess-consulting.com.au>
Date: Thu, 31 Oct 2013 22:27:31 +1100
Message-Id: <05D64426-E0FC-4D88-A6D8-0FA19B26A0B9_at_burgess-consulting.com.au>

Hi Tony,
For the recover command use until cancel and then cancel when prompted for the first arch log:

recover database until cancel using backup controlfile;

Cancel when prompted. Then open reset logs.

Any idea if these data files were in backup mode since 9-8-2013? It might explain why the checkpoint scn has been frozen since then.

Regards,

Mark

> On 31 Oct 2013, at 9:49 pm, De DBA <dedba_at_tpg.com.au> wrote:
>
> Hi Mark,
>
> Unfortunately, no difference. What bugs me as well is the difference between the controlfile (20-10-2013) and the checkpoint time of the datafiles (9-8-2013) It's almost as if I've got to versions of the database mixed up, even though this is a copy of a SAN lun that was last changed by the server which is now dead (according my information, that is). How could that happen?
>
> SQL> _at_recreate_controlfile.dba
> ORACLE instance started.
>
> Total System Global Area 70723612 bytes
> Fixed Size 75804 bytes
> Variable Size 29609984 bytes
> Database Buffers 40960000 bytes
> Redo Buffers 77824 bytes
>
> Control file created.
>
> SQL> recover database using backup controlfile;
> ORA-00279: change 84406636 generated at 08/09/2013 01:48:39 needed for thread 1
> ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC07062.001
> ORA-00280: change 84406636 for thread 1 is in sequence #7062
>
>
> Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
> auto
> ORA-00308: cannot open archived log 'E:\ORACLE\ORA81\RDBMS\ARC07062.001'
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
>
> SQL> alter database open resetlogs;
> alter database open resetlogs
> *
> ERROR at line 1:
> ORA-01113: file 1 needs media recovery
> ORA-01110: data file 1: 'E:\ORADATA\SUN\SYS1SUN.DBF'
>
> Cheers,
> Tony
>

>> On 31/10/13 19:52, Mark Burgess wrote:
>> Hi Tony,
>> 
>> Just a thought on the sequence of commands. What happens if you:
>> 
>> 1. Create cf.
>> 2. Recover database until cancel using backup controlfile.
>> 3. Open reset logs.
>> 
>> 
>> Regards,
>> 
>> Mark

>

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

Received on Thu Oct 31 2013 - 12:27:31 CET