oracle数据库查看归档路径,Oracle RAC开启归档模式及设置归档路径

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;

Database altered.

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