How to enable/disable oracle Archiving

To enable and disable oracle archive, if the OPSRAC environment is used, You Need To comment out parallel_servertrue first, then perform the following steps, and use this parameter to restart 1. Enable archive. disable shutdownimmediateb. startupmountc. alterdatabasearchivelogd. alterdatabaseopne

How to enable/disable oracle Archiving

In the OPS/RAC environment, You Need To comment out parallel_server = true first, then perform the following steps, and then restart with this parameter.

1. Enable Archiving

A. Disable 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: oracleora92databasearchive

Oldest online log sequence 131

Next log sequence to archive 133

Current log sequence 133