Oracle enable and disable archiving logs

Enable archiving to ensure that log_archive_starttrue Enables automatic archiving. Otherwise, you can only manually archive the file. If archive is disabled, set this parameter to false. Note: If the OPSRAC environment is used, comment out parallel_servertrue first, then, execute the following steps, and use this parameter to restart 1. Enable archive. shut down database shutdowni

Enable archiving to ensure log_archive_start = true enable automatic archiving. Otherwise, you can only manually archive the archive. If archive is disabled, set this parameter to false. Note: If the archive is in the OPS/RAC environment, you need to comment out parallel_server = true first, then perform the following steps, and then use this parameter to restart 1. Enable archive. shut down database shutdown I

Enable archiving to ensure log_archive_start = true enable automatic archiving. Otherwise, you can only manually archive the archive. If archive is disabled, set this parameter to false.

Note: In the OPS/RAC environment, you must first comment out parallel_server = true, then perform the following steps, and then restart with this parameter.

1. Enable Archiving

A. Shut down the database shutdown immediate.

B. startup mount

C. alter database archivelog

D. alter database opne

2. Archive prohibited

A. Shut down the database shutdown immediate.

B. startup mount

C. alter database noarchivelog

D. alter database open

You can view the archived information using the following statement:

SQL> archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination E: \ Oracle \ ora92 \ database \ archive

Oldest online log sequence 131

Next log sequence to archive 133

Current log sequence 133