Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs

Re: Archive Logs

From: Pawe³ Kokot <pkokot_at_zg.szczecin.pl>
Date: Mon, 13 Dec 1999 11:27:50 +0100
Message-ID: <832hao$4c6$1@sunsite.icm.edu.pl>


Thanx, but I want to REDO operations wroten into archivelogs.

--
Pawe³ Kokot
STAR-SOFT Cieszyn
Jeff Hunter <jeffh_at_btitelecom.net> wrote in message news:38511d80_at_defiant.btitelecom.net...
>
> There's two things you need to do to start automatic archiving. First,
you
> have to put three parameters in your init.ora file:
>
> log_archive_start = true
> log_archive_dest_1 = "location=/u02/core"
> log_archive_format = %t_%s.arc
>
> The first parameter tells oracle that you want to automatically archive
your
> redo log files. The second parameter signifies where you want your
archived
> log files to go and the third parameter tells oracle what you want the
file
> naming convention to be. These parameters are probably already in your
> init.ora file, you just have to uncomment them. Shutdown your database.
>
> When you bring your database back up, you have to put the database in
> archivelog mode. From a svrmgrl prompt, issue:
> SVRMGRL> alter database archivelog;
>
> Pawe³ Kokot wrote in message <82qihh$oh1$1_at_sunsite.icm.edu.pl>...
> >Hi,
> >how to redo all archive logs automaticly?
> >
> >--
> >Paweł Kokot
> >STAR-SOFT Cieszyn
> >
> >
>
>
Received on Mon Dec 13 1999 - 04:27:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US