A legújabb Oracle őrület : azaz bug 4483084

Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.
Symptoms
ORA-600 [LibraryCacheNotEmptyOnClose] is reported in the alert.log on shutdown.
The trace file shows the call stack trace:

kglshu kqlnfy kscnfy ksmshu
opistp_real opistp opiodr ttcpip opitsk opiino opiodr opidrv
sou2o opimai_real main libc_start_main

and will also include a System State.

Cause
This is due to unpublished Bug 4483084 'ORA-600 [LIBRARYCACHENOTEMPTYONCLOSE]'

This is a bug in that an ORA-600 error is reported when it is found that something is still going
on during shutdown. It does not indicate any damage or a problem in the system.

Solution

At the time of writing, it is likely that the fix will be to report a more meaningful external error, although this has not been finalised.
The error is harmless so it is unlikely that this will be backported to 10.2.
The error can be safely ignored as it does not indicate a problem with the database.

Ha NORCHIVELOG módban megy egy szerver és így menteném RMAN-nal :

[11:24] Ice: oracle@sgc2 > cat back_vsgc2db_full.rcv
connect target /

run {
shutdown immediate;
startup mount;
allocate channel disk1 type disk format '/vsgcdata/backup/%U';
backup database;
alter database open;
}

Akkor a shutdown immediatenél szépen elfüstől hibával ...

Valaki nem tud valami egyszerű megoldást arra, hogy akkor scriptből hogyan mentsek RMAN-nal ?

Előre is köszi ...

Hozzászólások