Re: Archive Logs

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 Fri Dec 10 1999 - 09:33:48 CST