ASM

Storage
RAID stripe size
   power of 2 and <= ASM allocation unit (1MB in 10g)

Check diskgroup and by default REPAIR.
alter diskgroup data check all
SQL> /

Diskgroup altered.

Windows, cannot start not cluster asm with error:
SQL> startup;
ORA-29701: unable to connect to Cluster Manager
Solution
C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>C:\oracle\product\10.2.0\db_1\BIN\localconfig delete
Step 1:  stopping local CSS stack
Step 2:  deleting OCR repository
successfully deleted local CSS setup

C:\oracle\product\10.2.0\db_1\RDBMS\ADMIN>C:\oracle\product\10.2.0\db_1\BIN\localconfig add
Step 1:  creating new OCR repository
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'ausmirnov', privgrp ''..
Operation successful.
Step 2:  creating new CSS service
successfully created local CSS service
successfully added CSS to home
Windows, cannot start asmcmd 10g
(UNKNOWN OCI STATUS 1804) OCIInitialize. Check ORACLE_HOME and NLS settings etc.
Solution

Wrong perl version from 11g, should be
set Path=C:\oracle\product\10.2.0\db_1\perl\5.8.3\bin\perl\5.8.3\bin;%Path%

--asmcmd find all files, ls with size
ASMCMD [+TESTDB_DATA1] > find . *
+TESTDB_DATA1/NEW10G/
+TESTDB_DATA1/NEW10G/DATAFILE/
+TESTDB_DATA1/NEW10G/DATAFILE/TEST_ASM.257.774528235
+TESTDB_DATA1/NEW10G/DATAFILE/USERS.256.770656241
ASMCMD [+TESTDB_DATA1/NEW10g/DATAFILE] > ls -s
Block_Size  Blocks      Bytes      Space  Name
      8192     385    3153920    8388608  TEST_ASM.257.774528235
      8192   16768  137363456  277872640  USERS.256.770656241
--list clients (databases using that asm)
ASMCMD [+TESTDB_DATA1/NEW10g/DATAFILE] > lsct
DB_Name   Status        Software_Version  Compatible_version  Instance_Name
new10g    CONNECTED           10.2.0.4.0          10.2.0.3.0  new10g
--list disk groups
ASMCMD [+TESTDB_DATA1/NEW10g/DATAFILE] > lsdg
State    Type    Rebal  Unbal  Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Name
MOUNTED  NORMAL  N      N         512   4096  1048576       594      159              198             -19              0  TESTDB_DATA1/



Комментариев нет:

Отправить комментарий

Update BLOB

set define off DECLARE    vb1 CLOB := 'long text';    vb2 CLOB :=                 'long text';    vb3 CLOB :=              ...