ORA-01078: failure in processing system parameters

Merhaba,

Bugün karşılaştığım bir hatanın çözümünü paylaşmak istiyorum.

Asm instance'ına bağlandıktan sonra,  startup komutunu verdiğimde,  db mount olamadı.

Çözümü crsctl servisinin start'ından geçiyor.

[oracle@ rom]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid 

[oracle@ rom]$ export ORACLE_SID=+ASM 

[oracle@ rom]$ sqlplus "/as sysasm" 

SQL*Plus: Release 11.2.0.1.0 Production on TH FEB 21 11:14:29 2013 

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

Connected to an idle instance. 

SQL> startup 

ORA-01078: failure in processing system parameters 

ORA-29701: unable to connect to Cluster Synchronization Service 

Solutions:

[oracle@rom-+ASM bin] ./crsctl start resource ora.cssd

CRS-2672: Attempting to start 'ora.cssd' on 'rom'

CRS-2679: Attempting to clean 'ora.diskmon' on 'rom'

CRS-2681: Clean of 'ora.diskmon' on 'rom' succeeded

CRS-2672: Attempting to start 'ora.diskmon' on 'rom'

CRS-2676: Start of 'ora.diskmon' on 'rom' succeeded

CRS-2676: Start of 'ora.cssd' on 'rom' succeeded

Finish:

SQL> startup

ASM instance started

Total System Global Area  384565544 bytes

Fixed Size                  2336036 bytes

Variable Size             358063644 bytes

ASM Cache                  25165824 bytes

ASM diskgroups mounted

Günün İpucu(Oracle): Oracle Backup Sql Sorgusu

Merhaba,

Günün İpucu: Oracle tarafında rman kullanarak, devam eden bir restore'unuz var ise, alttaki sql'i kullanarak restore'un devam edip etmediğini, inmekte olan datafile'ların % kaç'ının tamamlandığını alttaki sql sorgusunu kullanarak görebilirsiniz.


SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM  V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0   AND SOFAR <> TOTALWORK;

Örnek Backup başlattığınızda:


RMAN> backup incremental level 1 for recover of copy with tag 'app_incr' database;

Starting backup at 2013-04-17:14:08:47
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 5 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 6 found
no parent backup or copy of datafile 8 found
no parent backup or copy of datafile 7 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=+DATA/orcl/datafile/system.260.734893311



output file name=+FRA/orcl/datafile/system.277.812988549 tag=APP_INCR RECID=6 STAMP=812989209
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:11:06
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.261.734893313



Durumu:

SQL> r
  1* SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM  V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0   AND SOFAR <> TOTALWORK

       SID    SERIAL#    CONTEXT      SOFAR  TOTALWORK %_COMPLETE
---------- ---------- ---------- ---------- ---------- ----------
        33       1245          1      42110      70400      59.82

Teşekkürler
Fahrettin

Günün İpucu(Oracle): DataGuard Status

Merhaba,

Günün ipucu: Dataguard Statusunu merak ediyorsanız,  alttaki sql ile sorgulayabilirsiniz.

SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE;

Teşekkürler

Fahrettin

Günün İpucu(Oracle) : Oracle Dataguard Db Zamanı Sorgulama

Merhaba,

Bugün vereceğim ipucu, standby database'inizin, hangi saatte olduğunu gösteriyor,  merak ediyorsanızalttaki sql işinizi görecektir...

select to_char(START_TIME,'dd.mm.yyyy hh24:mi:ss') "Recover baslangic",to_char(item)||' = '||to_char(sofar)||' '||to_char(units)||' '|| to_char(TIMESTAMP,'dd.mm.yyyy hh24:mi') "Degerler" from v$recovery_progress where start_time=(select max(start_time) from v$recovery_progress);

İyi Çalışmalar...