Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Log Question
By checking out the exact syntax for
alter database add logfile member
at http://tahiti.oracle.com
-- Sybrand Bakker Senior Oracle DBA to reply remove '-verwijderdit' from my e-mail address "Chucky" <chuck.carson_at_syrrx.com> wrote in message news:3E05D398.7010208_at_syrrx.com...Received on Sun Dec 22 2002 - 09:27:37 CST
>
> How would I add more logs per group on a database that has already been
> created and is up and running?
>
> Thx,
> CC
>
> Howard J. Rogers wrote:
> > "Chuckster" <chuckycarson_at_networkcloud.com> wrote in message
> > news:3E04A739.5020503_at_networkcloud.com...
> >
> >>When you have your redo logs created as follows:
> >>LOGFILE
> >> GROUP 1 '/u01/oradata/syrlims/redo01.log' SIZE 10M,
> >> GROUP 2 '/u02/oradata/syrlims/redo02.log' SIZE 10M,
> >> GROUP 3 '/u03/oradata/syrlims/redo03.log' SIZE 10M,
> >> GROUP 4 '/u04/oradata/syrlims/redo04.log' SIZE 10M
> >
> >
> > Correct. No redundancy. If you wanted redundancy, it would look like
this:
> >
> > LOGFILE
> > GROUP 1
> > ('/u01/oradata/syrlims/redo1a.log','/u05/blahblahblah/redo1b.log') SIZE
> > 10M,
> > GROUP 2 ('/u02/oradata/syrlims/redo2a.log','/u06/bbb/redo2b.log')
SIZE
> > 10M,
> > GROUP 3 ('/u03/oradata/syrlims/redo3a.log','/u07/bbb/redo3b.log')
SIZE
> > 10M,
> > GROUP 4 ('/u04/oradata/syrlims/redo4a.log','/u08/bbb/redo4b.log')
SIZE
> > 10M
> >
> > Extra groups buy you time before you start over-writing earlier logs
(and,
> > specifically, buys ARCH time to archive the earlier logs before your try
and
> > re-use them).
> >
> > Extra members per group buys you resilience and redundancy.
> >
> > And I've renamed your original files so that the number indicates the
group
> > and the letter indicates the member, which I find easier to manage than
the
> > 'official' recommendation of, for example, REDO0101 and REDO0102.
> >
> > Regards
> > HJR
> >
> >
> >>
> >>This is merely 4 different log files with no redundancy correct? If I
> >>wanted path redundancy, I would need to add more log files per group and
> >> make sure they are on different volume groups/spindles correct?
> >>
> >>Thanks,
> >>CC
> >>
> >>
> >>
> >>-----------== Posted via Newsfeed.Com - Uncensored Usenet News
> >
> > ==----------
> >
> >> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> >>-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
> >
> > =-----
> >
> >
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=-----