asm单机oracle,RAC+ASM 还原到单机

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 10.2.0.5 - Release: 10.2 to 10.2

SUSE \ UnitedLinux x86-64

***Checked for relevance on 25-Jul-2010***

Symptoms

The archiver is getting stuck with ORA-19502 and ORA-27061

.

- Verified the issue by the trace file , which displays

ORA-19502: write error on file "/oralog/flash_recovery_area/emrep/1_2027_599924366.dbf", blockno 79873 (blocksize=512)

ORA-27061: waiting for async I/Os failed

Linux Error: 28: No space left on device

- Verified the issue by the alert log file which displays

ORA-19502: write error on file "/oralog/flash_recovery_area/emrep/1_2127_599924366.dbf", blockno 24577 (blocksize=512)

ORA-27061: waiting for async I/Os failed

Linux Error: 5: Input/output error Additional information: -1 Additional information: 1048576

.

ARC1: I/O error 19502 archiving log 14 to '/oralog/flash_recovery_area/emrep/1_2127_599924366.dbf'

- Verified the issue by the dbwriter trace which displays

WARNING:Oracle process running out of OS kernel I/O resources

*** 2006-10-14 22:42:21.572

WARNING:Oracle process running out of OS kernel I/O resources

*** 2006-10-15 15:42:57.426

WARNING:Oracle process running out of OS kernel I/O resources

*** 2006-10-15 22:43:27.470

WARNING:Oracle process running out of OS kernel I/O resources

Cause

Filed bug.5609038 for this issue.

Development team advised that this issue should be a known bug in SLES9/SP2 and also affects SLES10..

This is OS related issue.

https://bugzilla.novell.com/show_bug.cgi?id=114454

Solution

To implement the solution, please execute the following steps:

1. Upgrade your OS kernel packages.  Contact Novell for the appropriate patch for your version.

-OR-

2. Set these parameters as a workaround:

disk_asynch_io = false

filesystemio_options = none

References

BUG:5609038 - WARNING:ORACLE PROCESS RUNNING OUT OF OS KERNEL IO RESOURCES ORA-19502 ORA-27061

Related

--------------------------------------------------------------------------------

Products

--------------------------------------------------------------------------------

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

Keywords

--------------------------------------------------------------------------------

FILESYSTEMIO_OPTIONS; DISK_ASYNCH_IO; NO SPACE LEFT ON DEVICE; ARCHIVED LOGS

Errors

--------------------------------------------------------------------------------

ORA-19502; ORA-27061; ERROR 19502