Wednesday, September 14, 2011

ERROR: PST-initiated MANDATORY DISMOUNT of group DATA

It means ASM  is not able to offline the disks having issues so it dismount the entire diskgroup -


https://twiki.cern.ch/twiki/bin/view/PSSGroup/ASM_Internals



  • PST - Partner Status Table. Maintains info on disk-to-diskgroup membership.
  • COD - Continuing Operation Directory. The COD structure maintains the state of active ASM operations or changes, such as disk or datafile drop/add. The COD log record is either committed or rolled back based on the success of the operation. (source Oracle whitepaper)
  • ACD - Active Change Directory. The ACD is analogous to a redo log, where changes to the metadata are logged. The ACD log record is used to determine point of recovery in the case of ASM operation failures or instance failures. (source Oracle whitepaper)
  • OSM Oracle Storage Manager, legacy name, synonymous of ASM
  • CSS Cluster Synchronization Services. Part of Oracle clusterware, mandatory with ASM even in single instance. CSS is used to heartbeat the health of the ASM instances.
  • RBAL - Oracle backgroud process. In an ASM instance coordinated rebalancing operations. In a DB instance, opens and mount diskgroups from the local ASM instance.
  • ARBx - Oracle backgroud processes. In an ASM instance, a slave for rebalancing operations
  • PSPx - Oracle backgroud processes. In an ASM instance, Process Spawners
  • GMON - Oracle backgroud processes. In an ASM instance, diskgroup monitor.
  • ASMB - Oracle backgroud process. In an DB instance, keeps a (bequeath) persistent DB connection to the local ASM instance. Provides hearthbeat and ASM statistics. During a diskgroup rebalancing operation ASM communicates to the DB AU changes via this connection.
  • O00x - Oracle backgroud processes. Slaves used to connected from the DB to the ASM instance for 'short operations'.

Tuesday, May 17, 2011

ALTER DATABASE RECOVER TO LOGICAL STANDBY struck

738643.1

one of the many reason - the

DBMS_LOGSTDBY.BUILD;

didnt finish yet.

Monday, May 16, 2011

orapwd and alter user for sys

alter user for sys updates the orapwd file .
but changing the password thru orapwd do not change the data dictionary (sys password) - again this is my assumption on my observation ( check out?)

Sunday, May 1, 2011

physical standby on realtime apply

SQL> recover managed standby database using current logfile disconnect from session;

Thursday, March 31, 2011

ORA-15110: no diskgroups mounted

check if you are on spfile or not .

rman duplicate from active database

1- TNS entry on both side
2- listener configuration is done
3- password for target and auxiliary should be same ( my personal observation)
4- use TNS(@ for both target and auxiliary
5- check the service name(dbms_service/listener)

Wednesday, March 23, 2011

ORA-16211: unsupported record found in the archived redo log

getting
ORA-16211: unsupported record found in the archived redo log

on the logical standby database can be due to having force logging not enabled.

Thursday, March 10, 2011

asm dropping disk

for
ORA-01948: identifier's name length (31) exceeds maximum (30)

use the name from

select group_number, name, TOTAL_MB, FREE_MB
from V$asm_disk_stat;

in

alter diskgroup tan1_1 drop disk ' TAN1_2_0008';

Wednesday, March 2, 2011

Monday, February 28, 2011

oracle restart - asm status

somehow it doesn't show online after adding into crs stack

srvctl add asm -l LISTENER

but after bouncing the asm it shows properly

crsctl start resource ora.asm - forces a bounce.

Monday, February 14, 2011

alter system switch logfile hung

most of the time

ALTER SYSTEM ARCHIVE LOG CURRENT clears it

Saturday, February 5, 2011

unmounting asm diskgroup do not release the file descriptor

issuing
select * from v$asm_disk in 11gR2 after the unmount/drop disk command. or apply the one off patch in 10g clears the file descriptor.

can be verified lsof /dev/rdisk/disk44 ( or if there is LVM lsof -d /dev/dgsap01 of lsof /dev/dgsap01/rasm* )

metalink Note - 402526.1

Thursday, January 6, 2011

ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]

in 11gR2
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131


m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: srvctl add asm -l LISTENER
m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs:

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: sqlplus '/as sysasm'

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 6 09:43:53 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> create spfile from memory;

File created.

ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]

in 11gR2
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131


m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: srvctl add asm -l LISTENER
m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: crsctl stat res
NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.asm
TYPE=ora.asm.type
TARGET=OFFLINE
STATE=OFFLINE

NAME=ora.cssd
TYPE=ora.cssd.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.diskmon
TYPE=ora.diskmon.type
TARGET=ONLINE
STATE=ONLINE on m3p131

NAME=ora.evmd
TYPE=ora.evm.type
TARGET=ONLINE
STATE=ONLINE on m3p131

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs:

m3p131:+ASM:/apps/oracle/product/11.2.0/grid/dbs: sqlplus '/as sysasm'

SQL*Plus: Release 11.2.0.2.0 Production on Thu Jan 6 09:43:53 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> create spfile from memory;

File created.

Wednesday, January 5, 2011

RMAN-06024 during duplicate database for standby

RMAN-06024 during duplicate database for standby

RMAN-06024: no backup or copy of the control file found to restore

alter system switch logfile on target should fix this


RMAN Duplicate For Standby Fails with Rman-06024: No Backup Or Copy Of The Control File Found To Restore [ID 466321.1]