Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs
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
![]() |
![]() |