Shulou(Shulou.com)06/01 Report--

SQL > alter system set log_archive_dest='+LWK/archivelog' scope=spfile sid='*'

Then close the two instances, start the instance, and change the database to archive mode:

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 1258291200 bytes

Fixed Size 1978336 bytes

Variable Size 352325664 bytes

Database Buffers 889192448 bytes

Redo Buffers 14794752 bytes

Database mounted.

SQL > alter database archivelog

Database altered.

SQL > alter database open

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination / opt/oracle/archive

Oldest online log sequence 83

Next log sequence to archive 84

Current log sequence 84

Next, start another node to complete the change process of the archive mode.

In RAC environment, the choice of archive path is worth considering, and if you use the shared archive directory as the archive path, you can reduce the complexity of backup. If you use a separate directory, special handling is required when backing up.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.