Shulou(Shulou.com)05/31 Report--

Editor to share with you how to open archiving under the stand-alone environment of Oracle+ASM. I hope you will get something after reading this article. Let's discuss it together.

In a stand-alone ASM environment, the easiest way to turn on archiving.

Environment: oracle11g 11.2.0.4

Log in to sqlplus

[oracle@udevasm ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 8 18:20:41 2017

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

To start the Oracle database to the Open state

SQL > startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes

Variable Size 331350920 bytes

Database Buffers 729808896 bytes

Redo Buffers 5517312 bytes

Database mounted.

Database opened.

View ASM space usage

SQL > select group_number,name,total_mb,free_mb from v$asm_diskgroup

GROUP_NUMBER NAME TOTAL_MB FREE_MB

-

1 DGDATA01 22520 260

2 DGDATA02 20472 14132

3 DGRECOVERY 21500 21420

4 DGSYSTEM 20472 20392

5 GRID1 10232 10144

View archive status

SQL > archive log list

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination / oracle/app/oracle/product/11.2.0/dbs/arch

Oldest online log sequence 9

Current log sequence 14

SQL > show user

USER is "SYS"

Close the library, or use the command: shutdown immediate to close

SQL > shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

Open the library to mount

SQL > startup mount

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size 2260088 bytes

Variable Size 331350920 bytes

Database Buffers 729808896 bytes

Redo Buffers 5517312 bytes

Database mounted.

View the status of the current node

SQL > select status from gv$instance

STATUS

-

MOUNTED

Open archiving for nodes. Open archiving.

SQL > alter database archivelog

Database altered.

Check the archive status and find that the archive log path is incorrect, which is not the default path in ASM

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination / oracle/app/oracle/product/11.2.0/dbs/arch

Oldest online log sequence 9

Next log sequence to archive 14

Current log sequence 14

Modify the archive path

SQL > ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=+DGRECOVERY/' SCOPE=SPFILE SID='udevasm'

View the current modified path

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination + DGRECOVERY/arc

Oldest online log sequence 9

Next log sequence to archive 14

Current log sequence 14

Node open library

SQL > alter database open

Database altered.

SQL > select status from v$instance

STATUS

-

OPEN

Let's take a look. By default, the information of the archive path points directly to the path in ASM.

SQL > show parameter log_archive_dest

NAME TYPE VALUE

-

Log_archive_dest string

Log_archive_dest_1 string LOCATION=+DGRECOVERY/ARC

Log_archive_dest_10 string

Log_archive_dest_11 string

Log_archive_dest_12 string

Log_archive_dest_13 string

Log_archive_dest_14 string

Log_archive_dest_15 string

Log_archive_dest_16 string

Log_archive_dest_17 string

Log_archive_dest_18 string

Go to ASM and take a look at the archives.

ASMCMD > lsdg

State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name

MOUNTED EXTERN N 512 4096 4194304 22520 260 0 260 0 N DGDATA01/

MOUNTED EXTERN N 512 4096 4194304 20472 14132 0 14132 0 N DGDATA02/

MOUNTED EXTERN N 512 4096 4194304 21500 21420 0 21420 0 N DGRECOVERY/

MOUNTED EXTERN N 512 4096 4194304 20472 20392 0 20392 0 N DGSYSTEM/

MOUNTED EXTERN N 512 4096 4194304 10232 10144 0 10144 0 N GRID1/

SMCMD > cd 2017 / 06 / 08 /

ASMCMD > l

Thread_1_seq_14.256.946154499

Thread_1_seq_15.257.946154499

Thread_1_seq_16.258.946154499

Thread_1_seq_17.259.946154499

Thread_1_seq_18.260.946154501

Thread_1_seq_19.261.946154523

Thread_1_seq_20.262.946154571

After reading this article, I believe you have a certain understanding of "how to turn on filing in Oracle+ASM stand-alone environment". If you want to know more about it, please follow the industry information channel. Thank you for your reading!

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.