Re: Redo log groups

Hi Joao

You create additional members for a redo log group to safegaurd youself against disk failure. You put the members of a group on different disks, so that should one disk crash, the member or members on the other disks allow your log group to carry on functioning. Add log groups to prevent you logwriter LGWR from being held up waiting for a log group to become available. This problem is usually encountered when running the database in archivelog mode, and LGWR needs to write to a log group that has not been archived yet. Add a group to see if the situation improves. Regards
Paulo da Cruz

Joao Ricardo B Oliveira wrote:
>
> hi there:
>
> Anyone can explain when we need to create more Redo Log members or Redo
> Log groups ?
>
> Another question is :
>
> If i submit several jobs in the OEM, like this :
>
> 1.broadcast message 'Shutdown in 10 minutes'
> 2.shutdown immediate everyday at 18:00
> 3.backup database when database down at 18:10
>
> if one of them fails, for example the shutdown, the backup also
> fails ?
>
> if i want to backup directly to a tape (HP Surestore Dat8) the backup
> manager asks for the Tape Device ID... where can i find it ?
>
> Thankx
>
> jricardo_at_ipb.pt
>
> "Oracle the edge @ side ..." by me...
Received on Wed Jul 21 1999 - 05:32:19 CDT