Re: tablespace recovery - Newbie

Error: ORA 308
Text: cannot open archived log <name>

Cause: The system cannot access a required archived redo log file. Action: Check that the off line log exists, the storage device is online, and

        the archived file is in the correct location.
        Then attempt to continue recovery or restart the recovery session.

It may be that the file you're after hasn't yet been archived. Can you tell us what the log number is that it's trying to get? Also, do an archive log list and see if it is an online file.

I assume the tablespace being recovered is offline?

HTH. Pete

farrellyr_at_my-deja.com wrote:

> NT4 - Oracle7.3
>
> When I try to recovery tablespace 'name', I get ORA-00308 - cannot open
> archive log. These file are written to this location, but for some
> reason cannot be read, any ideas why?? Is a RAID1 disk. Is there no way
> to recover this tablespace? Or can I move the the archive log to a
> different location and then specify which file to use for tablespace
> recovery, if so how? Any suggestions would be appreciated.
>
> My steps were
>
> set autorecovery on.
> recover tablespace 'name'
>
> Maybe I'm missing a step?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--

Regards

Pete

Received on Fri Jun 18 1999 - 14:50:07 CDT