Re: Help! Can't open a database

Try...

svrmgr> connect internal
svrmgr> startup mount pfile= (type full path of init file)
svrmgr> recover database until cancel  (type cancel when asked for file)
svrmgr> alter database open resetlogs

sonya

In article <8cfp9a$mhk$1_at_diana.bcn.ttd.net>,   "Nobody" <nobody_at_anyone.com> wrote:
>
> Hi all:
> The system was rebooted before the database came down completely and
when I
> try to open the database this errors appears:
>
> ORA-00314: log 2 of thread 1, expected sequence# doesn't match
> ORA-00312: online log 2 thread 1: '/u02/oradata/srv/redosrv02.log'
>
> my alert file show me this:
>
> Wed Apr 5 17:19:00 2000
> alter database open
> Wed Apr 5 17:19:00 2000
> Errors in file /oracle/admin/srv/bdump/lgwr_1141.trc:
> ORA-00314: log 2 of thread 1, expected sequence# 1016 doesn't match
1019
> ORA-00312: online log 2 thread 1: '/u02/oradata/srv/redosrv02.log'
> Wed Apr 5 17:19:00 2000
> Errors in file /oracle/admin/srv/bdump/lgwr_1141.trc:
> ORA-00314: log 2 of thread 1, expected sequence# 1016 doesn't match
1019
> ORA-00312: online log 2 thread 1: '/u02/oradata/srv/redosrv02.log'
> Wed Apr 5 17:19:00 2000
> ORA-314 signalled during: alter database open
> --
> Saludos.
> jorge_at_tice.es
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Apr 05 2000 - 14:28:48 CDT