Re: urgent!!!!!!!!!

From: Slavica Sadzakovic <sslavica_at_dkts.co.yu>
Date: Mon, 11 Sep 2000 08:17:49 +0200
Message-Id: <10616.116608@fatcity.com>

We have changed the disc and after that we copied from old disc to new and data base running normaly. I didn't do recovery. I think that everything is OK , but I'm new in Oracle (I work as DBA only two months).

Fri Sep 8 15:38:31 2000
SMON: enabling cache recovery
SMON: enabling tx recovery
Fri Sep 8 15:38:34 2000
Completed: ALTER DATABASE OPEN
Fri Sep 8 16:58:57 2000
LGWR: prodding the archiver
Thread 1 advanced to log sequence 7666
Current log# 2 seq# 7666 mem# 0: /oracle/u04/oradata/telispro/redo02.log Fri Sep 8 16:58:57 2000
Current log# 2 seq# 7666 mem# 1:
/export/home/oracle/oradata/telispro/redo02b.log Fri Sep 8 16:58:57 2000
ARC0: received prod
Fri Sep 8 16:58:57 2000

ARC0: Beginning to archive log# 4 seq# 7665
ARC0: Completed archiving log# 4 seq# 7665
ARC0: re-scanning for new log files
ARC0: prodding the archiver
ARC0: received prod

Fri Sep 8 18:24:11 2000
LGWR: prodding the archiver
Thread 1 advanced to log sequence 7667
Current log# 1 seq# 7667 mem# 0: /oracle/u04/oradata/telispro/redo01.log Fri Sep 8 18:24:11 2000
Current log# 1 seq# 7667 mem# 1:
/export/home/oracle/oradata/telispro/redo01b.log Fri Sep 8 18:24:11 2000
ARC0: received prod
Fri Sep 8 18:24:11 2000

ARC0: Beginning to archive log# 2 seq# 7666
ARC0: Completed archiving log# 2 seq# 7666
ARC0: re-scanning for new log files
ARC0: prodding the archiver
ARC0: received prod

Fri Sep 8 19:49:17 2000
LGWR: prodding the archiver
Thread 1 advanced to log sequence 7668
Current log# 3 seq# 7668 mem# 0: /oracle/u04/oradata/telispro/redo03.log Current log# 3 seq# 7668 mem# 1:
/export/home/oracle/oradata/telispro/redo03b.log Fri Sep 8 19:49:17 2000

ARC0: received prod
ARC0: Beginning to archive log# 1 seq# 7667
ARC0: Completed archiving log# 1 seq# 7667
ARC0: re-scanning for new log files
ARC0: prodding the archiver
ARC0: received prod

----- Original Message -----
From: Trassens Christian <trassenc_at_TELEFONICA.COM.AR> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, September 08, 2000 5:46 PM Subject: RE: urgent!!!!!!!!!

> Slavica,
>
> I suppose you've got the database running in a Sun. Why don't you test
with
> root privileges the comand "format" and the option "repair" of the exact
> block you've got in traces ?.
>
> Regards.
>
> > -----Mensaje original-----
> > De: Galleri, Mariana [SMTP:MGalleri_at_uniFON.com.ar]
> > Enviado el: Viernes 8 de Septiembre de 2000 04:45
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: RE: urgent!!!!!!!!!
> >
> > It seems a disk error. Did you check the disks?
> >
> >
> > -----Mensaje original-----
> > De: Slavica Sadzakovic [mailto:sslavica_at_dkts.co.yu]
> > Enviado el: Viernes 8 de Septiembre de 2000 04:00
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: urgent!!!!!!!!!
> >
> >
> > What I have to do ?
> >
> > Thu Sep 7 09:39:04 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 7661
> > Current log# 4 seq# 7661 mem# 0:

/oracle/u04/oradata/telispro/redo04.log
> > Current log# 4 seq# 7661 mem# 1:
> > /export/home/oracle/oradata/telispro/redo04b.log
> > Thu Sep 7 09:39:04 2000
> > ARC0: received prod
> > ARC0: Beginning to archive log# 3 seq# 7660
> > ARC0: Completed archiving log# 3 seq# 7660
> > ARC0: re-scanning for new log files
> > ARC0: prodding the archiver
> > ARC0: received prod
> > Thu Sep 7 10:50:17 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 7662
> > Current log# 2 seq# 7662 mem# 0:

/oracle/u04/oradata/telispro/redo02.log
> > Current log# 2 seq# 7662 mem# 1:
> > /export/home/oracle/oradata/telispro/redo02b.log
> > Thu Sep 7 10:50:17 2000
> > ARC0: received prod
> > ARC0: Beginning to archive log# 4 seq# 7661
> > ARC0: Completed archiving log# 4 seq# 7661
> > ARC0: re-scanning for new log files
> > ARC0: prodding the archiver
> > ARC0: received prod
> > Thu Sep 7 11:26:57 2000
> > LGWR: prodding the archiver
> > Thread 1 advanced to log sequence 7663
> > Current log# 1 seq# 7663 mem# 0:

/oracle/u04/oradata/telispro/redo01.log
> > Thu Sep 7 11:26:57 2000
> > Current log# 1 seq# 7663 mem# 1:
> > /export/home/oracle/oradata/telispro/redo01b.log
> > Thu Sep 7 11:26:57 2000
> > ARC0: received prod
> > Thu Sep 7 11:26:57 2000
> > ARC0: Beginning to archive log# 2 seq# 7662
> > ARC0: Completed archiving log# 2 seq# 7662
> > ARC0: re-scanning for new log files
> > ARC0: prodding the archiver
> > ARC0: received prod
> > Thu Sep 7 15:20:52 2000
> > Errors in file
> > /opt/Programs/oracle/admin/telispro/bdump/orcl_ckpt_940.trc:
> > ORA-01110: data file 1: '/oracle/u02/oradata/telispro/system01.dbf'
> > ORA-01114: IO error writing block to file 1 (block # 1)
> > ORA-27072: skgfdisp: I/O error
> > SVR4 Error: 5: I/O error
> > Additional information: 1
> >
> --
> Author: Trassens Christian
> INET: trassenc_at_TELEFONICA.COM.AR
>
> 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
Received on Mon Sep 11 2000 - 01:17:49 CDT