Re: mirroring online transaction logs
Date: 1996/11/06
Message-ID: <32813677.6056_at_bangate1.tek.com>#1/1
ythorne_at_acs.neu.edu wrote:
>
> I'm not an ORACLE DBA, but have installed software that uses ORACLE for
> it's database engine. Using the information in the ORACLE7 Server
> Administrator's Guide and the Concepts Guide, I tried to mirror the 3
> redo logs.
> alter database
> add logfile member '/harvest1/log1mhrvs.dbf' to group 1;
> alter database
> add logfile member '/harvest1/log2mhrvs.dbf' to group 2;
> alter database
> add logfile member '/harvest1/log3mhrvs.dbf' to group 3;
>
> The following three messages were returned:
> 'database altered'.
> The three files were created in the correct directory.
> A select on the v$logfile table shows the status of the three mirrored
> logs as 'invalid'.
> The lgwr trace file has the following errors:
> ora-00313: open failed for members of log group 1 of thread 1
> ora-00313: open failed for members of log group 2 of thread 1
> ora-00313: open failed for members of log group 3 of thread 1
>
> What am I doing wrong? Any ideas?
>
> Thanks ahead for your help.I'm no DBA either but just took a class on Oracle 7 Architechture so
maybe I can help. Looks to me like you left the 'size' clause off your
alter database statements. I'm not sure what Oracle does without that
but perhaps created files of 0 (zero) size?
HTH
Dan
Opinions expressed are not necessarily those of my employer
Received on Wed Nov 06 1996 - 00:00:00 CET