Sunday, January 30, 2011

alter database open resetlogs error ORA-00349

After restore & recovery I got error:

alter database open resetlogs
*
ERROR at line 1:
ORA-00349: failure obtaining block size for
'+ASMDG01/XXX/onlinelog/redo_g1_a'

in alert.log:

Sun Jan 30 06:01:07 2011
Errors in file /oracle/admin/XXX/udump/XXX_ora_3115.trc:
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_b'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_b
ORA-15173: entry 'redo_g4_b' does not exist in directory 'XXX'
ORA-00312: online log 4 thread 1: '+DG01/XXX/redo_g4_a'
ORA-17503: ksfdopn:2 Failed to open file +DG01/XXX/redo_g4_a
ORA-15173: entry 'redo_g4_a' does not exist in directory 'XXX'


Solution:


Saturday, January 29, 2011

This database instance failed to turn on flashback database

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 01/29/2011 00:40:41
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashback database


Solution:

Friday, January 7, 2011

ORA-29701: unable to connect to Cluster Manager

SQL> startup
ORA-29701: unable to connect to Cluster Manager


[oracle@xxx]/oracle/product/10.2/bin$ ./localconfig delete
You must be logged in as root to run ./localconfig.
Log in as root and restart ./localconfig execution.
exit from oracle account or execute su/sudo

bash-3.00# cd /oracle/product/10.2/bin/
bash-3.00# ./localconfig delete
Stopping CSSD.
Unable to communicate with the CSS daemon.
Shutdown has begun. The daemons should exit soon.
bash-3.00# ./localconfig add
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
Configuration for local CSS has been initialized

Adding to inittab
Startup will be queued to init within 30 seconds.
Checking the status of new Oracle init process...
Expecting the CRS daemons to be up within 600 seconds.
Giving up: Oracle CSS stack appears NOT to be running.
Oracle CSS service would not start as installed
Automatic Storage Management(ASM) cannot be used until Oracle CSS service is started