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

1. Environment description AIX platform, Oracle 11g 2-node RAC, using ASM format

Archiving is also stored under ASM.

L archiving record

Second, the purpose of modification is to modify the archives of 2 nodes to the local file system.

Node 1 archived to / arch2

Node 2 archived to / arch3

3. Preparation 1) create a local file system and grant permissions

[rac1] root#chown-R oracle:oinstall / arch2

[rac1] root#chmod-R 775 / arch2

[rac2] root#chown-R oracle:oinstall / arch3

[rac2] root#chmod-R 775 / arch3

2) back up pfile files

4. Modify and archive 1) record parameter configuration

SQL > conn / as sysdba

Connected.

SQL > show parameter log_archive_dest_1

NAME TYPE VALUE

-

Log_archive_dest_1 string

2) modify archiving

SQL > ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/arch2' SCOPE=SPFILE SID='sdzy1'

SQL > ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/arch3' SCOPE=SPFILE SID='sdzy2'

3) restart the library to mount status

Node 1:

Node 2:

4) Open the library

Both nodes are open.

SQL > alter database open

5) View Archive

Node 1:

Node 2:

6) Log switching test

Node 1:

Node 2:

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.