Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: !ArchiveLog ON?
Examples could be:
LOG_ARCHIVE_DEST = /instora/ora001/app/oracle/admin/prod/arch
LOG_ARCHIVE_FORMAT= 'prod%s'.arch
(here %s will be the system change number, you can prefix it with
anything, makes sense to use
SID)
Have fun,
Raman Batra, Oracle DBA
Greg Parsons wrote:
>
> Hi,
> If you do a:
> select name, value from v$parameters where name like 'LOG%';
> you'll likely see both of these. I know that the DEST parm is o/s
> specific, but they get defaulted in correctly for the o/s your on even
> if the:
> log_archive_start =false
> HTH,
> Greg
>
> T. Hereford wrote:
>
> > I'm looking for an example of :
> >
> > LOG_ARCHIVE_DEST =
> > LOG_ARCHIVE_FORMAT =
> >
> > --
> > (__) ( Thomas Hereford, Plymouth, MI
> > (oo) ( therefor_at_pobox.com
> > /---------\/ --< ( Product Data Manager,
> > /| || ( Simpson Industries, Inc.
> > * ||-------||
> > ~~ ~~
> > "My opinions are my own. Flames >/dev/null"
> >
> > *************************************************
> > "There are two ways of meeting difficulties:
> > you alter the difficulties or you alter
> > yourself meeting them."
> > *************************************************
Received on Fri Jun 12 1998 - 00:00:00 CDT