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

This article mainly shows you "how to solve the Oracle database archive log full disk space problem", the content is easy to understand, clear, hope to help you solve the doubt, the following let the editor lead you to study and learn "how to solve the Oracle database archive log full disk space problem" this article.

1. The database cannot be started

SQL > startup

The ORACLE routine has been started.

Total System Global Area 289406976 bytes

Fixed Size 1248576 bytes

Variable Size 83886784 bytes

Database Buffers 197132288 bytes

Redo Buffers 7139328 bytes

The database is loaded.

ORA-16038: log 2 serial number 44 cannot be archived

ORA-19809: the limit on the number of files recovered has been exceeded

ORA-00312: online log 2 thread 1:

'd:\ ORACLE\ PRODUCT\ 10.2.0\ ORADATA\ ORCL\ REDO02.LOG'

2. View the $ORACLE_HOME\ admin\ SID\ bdump\ alert_SID.log log

Thu Feb 19 09:45:33 2009

Errors in file d:\ oracle\ product\ 10.2.0\ admin\ orcl\ bdump\ orcl_arc1_660.trc:

ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 99.95% used, and has 1129472 remaining bytes available.

Thu Feb 19 09:45:33 2009

Errors in file d:\ oracle\ product\ 10.2.0\ admin\ orcl\ udump\ orcl_ora_4708.trc:

ORA-19815: warning: 99.95% of db_recovery_file_dest_size bytes (a total of 2147483648 bytes) have been used, and there are still 1129472 bytes available.

Thu Feb 19 09:45:33 2009

*

You have following choices to free up space from flash recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard

Thu Feb 19 09:45:33 2009

*

Then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

You have following choices to free up space from flash recovery area:

BACKUP RECOVERY AREA command.

3. Add disk space and increase db_recovery_file_dest_size parameter to

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard

Reflect the new space.

Then consider changing RMAN ARCHIVELOG DELETION POLICY.

4. Delete unnecessary files using RMAN DELETE command. If an operating

System command was used to delete files, then use RMAN CROSSCHECK and

2. Back up files to tertiary device such as tape using RMAN

DELETE EXPIRED commands.

*

BACKUP RECOVERY AREA command.

Thu Feb 19 09:45:34 2009

Errors in file d:\ oracle\ product\ 10.2.0\ admin\ orcl\ bdump\ orcl_arc1_660.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 44217856 bytes disk space from 2147483648 limit

From the above information, we know that the default 2G space in the flash recovery area flashback recovery space is full of archived logs, and there is no space to store archived logs. [NextPage]

3. Exit sqlplus and enter rman

SQL > exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, OLAP and Data Mining options disconnected

C:\ Documents and Settings\ mengzhaoliang > rman target/

Recovery Manager: Release 10.2.0.1.0-Production on Thursday February 19 09:57:48 2009

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

Connected to the target database: ORCL (DBID=1193443472, not open)

4. View the archive log

RMAN > list archivelog all

Replace the recovery directory with the target database control file

List of archived log copies

Keyword Thrd Seq S short time name

40 11 A 17-November-08 D:\ ORACLE\ PRODUCT\ 10.2.0\ FLASH_RECOVERY_AREA\ O

RCL\ ARCHIVELOG\ 2008 / 11 / 18\ O1_MF_1_1_4L44Z9CQ_.ARC

41 1 2 A 18-November-08 D:\ ORACLE\ PRODUCT\ 10.2.0\ FLASH_RECOVERY_AREA\ O

RCL\ ARCHIVELOG\ 2008 / 11 / 18\ O1_MF_1_2_4L4W4O0H_.ARC

42 1 3 A 18-November-08 D:\ ORACLE\ PRODUCT\ 10.2.0\ FLASH_RECOVERY_AREA\ O

5. You can back up the archive log to another space first, and then delete the archive log with rman

RMAN > delete archivelog all

Released channel: ORA_DISK_1

Assigned channel: ORA_DISK_1

Channel ORA_DISK_1: sid=151 devtype=DISK

List of archived log copies

Keyword Thrd Seq S short time name

40 11 A 17-November-08 D:\ ORACLE\ PRODUCT\ 10.2.0\ FLASH_RECOVERY_AREA\ O

RCL\ ARCHIVELOG\ 2008 / 11 / 18\ O1_MF_1_1_4L44Z9CQ_.ARC

Are you sure you want to delete the above objects (enter YES or NO)? Yes

Deleted archive log

Archive log file name = D:\ ORACLE\ PRODUCT\ 10.2.0\ FLASH_RECOVERY_AREA\ ORCL\ ARCHIVELOG\ 200

_ 11room18\ O1_MF_1_1_4L44Z9CQ_.ARC record ID=40 timestamp = 671101294

6. Exit rman, enter sqlplus, and open the database

RMAN > exit

The recovery Manager is complete.

C:\ Documents and Settings\ mengzhaoliang > sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0-Production on Thursday February 19 10:03:02 2009

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

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production

With the Partitioning, OLAP and Data Mining options

SQL > alter database open

The database has changed.

The database is open!

The above is all the contents of the article "how to solve the problem of Oracle database archive logs taking up full disk space". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.