No Archiver Stuck on 11g

[Former Member]

Hello.

I am trying to "achieve" a archiver stuck situation on an Oracle 11g installation (running SAP ERP 6.0).

However i am unable to make the database hang, something that is straight-forward with 10g.

I have browsed some documentation for 11g without finding any info on what's new in this regard.

Can someone tell me why the Oracle database does not hang when the archive directory is full (log_archive_dest_1) on 11g ?

This is a common problem on earlier versions, the SAP system hangs, no logon is possible and the alert_monitor triggers an unavailability alert.

[Former Member · Accepted solution]

Archive logs are also created in 11g. May be you can simulate this by copying/creating huge files in archive directory.

[Former Member]

Nothing has changed, fill up your archive directory. Then the online redo has to be full as well so you might have to run some dummy statement like 'update <large_table> set fieldx = fieldx' to achieve that.

Cheers Michael

Edit: or switch the logfiles...