Storage
RAID stripe size
power of 2 and <= ASM allocation unit (1MB in 10g)
Check diskgroup and by default
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/
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/
Комментариев нет:
Отправить комментарий