Oracle Security Question:

Download Job Interview Questions and Answers PDF

How to enable automatic archiving?

Oracle Security Interview Question
Oracle Security Interview Question

Answer:

1. shutdown the database with normal/emmidiate/transactional
2. modify/include the parameter log_archive_start=true,
log_archive_dest= (location to which the redo log file
group is archived), log_archive_format=(in which format you
want to apper the archive log file)
3. start up the database

Download Oracle Security Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are the steps to switch a databases archiving mode between NO ARCHIVELOG and ARCHIVELOG mode?How to specify the Archived log file name format and destination?