export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=s174358 PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN 2) Задать метод аутентификации администратора cd $ORACLE_HOME/dbs orapwd file=orapws174358 3)Создать конфигурационные файлы, необходимые для инициализации и запуска экземпляра Oracle cd $ORACLE_BASE; mkdir p admin/orcl/adump mkdir flash_recovery_area mkdir /u01/jkr17 mkdir $ORACLE_HOME/dbs/inits1743358.ora inits1743358.ora db_name='longuser' memory_target=300M sga_target=90M db_block_size=8192 #Configuration for replica log_archive_dest_1='LOCATION=/u01/jkr17/logs/' log_archive_dest_state_1=ENABLE log_archive_format=%t_%s_%r.arc chown oracle:oinstall /u01/jkr17 chmod 775 /u01/jkr17 cd /u01/jkr17 mkdir logs; mkdir longuser cd longuser mkdir node01 node02 node03 node04 4) Запустить экземпляр Oracle. lsnrctl start sqlplus /nolog SQL> connect / as sysdba SQL> create SPFILE from PFILE='$ORACLE_HOME/dbs/inits174358.ora'; SQL> startup nomount; 5) Создать новую базу данных CREATE DATABASE longuser USER SYS IDENTIFIED BY admin USER SYSTEM IDENTIFIED BY admin LOGFILE GROUP 1 ('/u01/jkr17/logs/redo01a.log') SIZE 10M, GROUP 2 ('/u01/jkr17/logs/redo02a.log') SIZE 10M, GROUP 3 ('/u01/jkr17/logs/redo03a.log') SIZE 10M, GROUP 4 ('/u01/jkr17/logs/redo04a.log') SIZE 10M MAXLOGFILES 5 MAXLOGMEMBERS 5 MAXLOGHISTORY 10 MAXDATAFILES 50 CHARACTER SET UTF8 NATIONAL CHARACTER SET UTF8 EXTENT MANAGEMENT LOCAL DATAFILE '/u01/jkr17/longuser/node03/uripo74.dbf' SIZE 100M REUSE AUTOEXTEND ON, '/u01/jkr17/longuser/node04/idubi57.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED SYSAUX DATAFILE '/u01/jkr17/longuser/node02/wus98.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TABLESPACE users DATAFILE '/u01/jkr17/longuser/node02/ixaqoda794.dbf' SIZE 50M REUSE AUTOEXTEND ON, '/u01/jkr17/longuser/node02/apuruye842.dbf' SIZE 50M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE temp TEMPFILE '/u01/jkr17/longuser/temp01.dbf' SIZE 100M REUSE UNDO TABLESPACE undotbs1 DATAFILE '/u01/jkr17/longuser/undotbs1.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED; 6) Создать дополнительные табличные пространства CREATE TABLESPACE WET_BLUE_ROAD DATAFILE '/u01/jkr17/longuser/node04/wetblueroad01.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/busygoldbird02.dbf' SIZE 10M, '/u01/jkr17/longuser/node02/wetblueroad02.dbf' SIZE 10M, '/u01/jkr17/longuser/node02/wetblueroad03.dbf' SIZE 10M; CREATE TABLESPACE OLD_GOLD_SOUP DATAFILE '/u01/jkr17/longuser/node03/oldgoldsoup01.dbf' SIZE 10M, '/u01/jkr17/longuser/node03/oldgoldsoup02.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/oldgoldsoup03.dbf' SIZE 10M, '/u01/jkr17/longuser/node01/oldgoldsoup04.dbf' SIZE 10M; CREATE TABLESPACE BIG_WHITE_FOOD DATAFILE '/u01/jkr17/longuser/node02/bigwhitefood01.dbf' SIZE 10M, '/u01/jkr17/longuser/node01/bigwhitefood02.dbf' SIZE 10M, '/u01/jkr17/longuser/node04/bigwhitefood03.dbf' SIZE 10M; 7) Сформировать представления словаря данных. cd $ORACLE_HOME/rdbms/admin; sqlplus /nolog SQL> connect / as sysdba SQL> @catalog.sql SQL> @catproc.sql @?/rdbms/admin/catalog.sql; @?/rdbms/admin/catproc.sql; grant sysdba to sys; ASM export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/11.2.0/grid export ORACLE_SID=+ASM export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN cd $ORACLE_HOME vi init+ASM.ora iinstance_type=asm ASM_POWER_LIMIT=9 ASM_DISKSTRING='/u01/carelesschicken/*','/u01/dangerousfrog/*' remote_login_passwordfile=exclusive large_pool_size=12M _ASM_ALLOW_ONLY_RAW_DISKS=FALSE cat init+ASM.ora mkdir /u01/carelesschicken mkdir /u01/dangerousfrog "carelesschicken[7]", "dangerousfrog[6]". 1) dd if=/dev/zero of=/u01/carelesschicken/carelesschicken0 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken1 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken2 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken3 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken4 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken5 bs=1k count=100000 dd if=/dev/zero of=/u01/carelesschicken/carelesschicken6 bs=1k count=100000 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken0 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken1 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken2 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken3 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken4 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken5 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken6 2) dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog0 bs=1k count=100000 dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog1 bs=1k count=100000 dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog2 bs=1k count=100000 dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog3 bs=1k count=100000 dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog4 bs=1k count=100000 dd if=/dev/zero of=/u01/dangerousfrog/dangerousfrog5 bs=1k count=100000 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog0 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog1 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog2 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog3 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog4 /usr/sbin/lofiadm -a /u01/dangerousfrog/dangerousfrog5 chown oracle:dba /u01/carelesschicken/* chown oracle:dba /u01/dangerousfrog/* crsctl start resource ora.cssd sqlplus / as sysasm startup pfile='/u01/app/11.2.0/grid/init+ASM.ora' select path,mount_status from v$asm_disk; select group_number, name, total_mb, free_mb, state, type from v$asm_diskgroup; select ASMNAME_KFDSK, GRPNUM_KFDSK from x$KFDSK where GRPNUM_KFDSK = (select NUMBER_KFGRP from x$kfgrp where NAME_KFGRP='CARELESSCHICKEN'); DROP DISKGROUP carelesschicken INCLUDING CONTENTS; create diskgroup carelesschicken normal redundancy disk '/u01/carelesschicken/carelesschicken0', '/u01/carelesschicken/carelesschicken1', '/u01/carelesschicken/carelesschicken2', '/u01/carelesschicken/carelesschicken3', '/u01/carelesschicken/carelesschicken4', '/u01/carelesschicken/carelesschicken5', '/u01/carelesschicken/carelesschicken6'; create diskgroup dangerousfrog normal redundancy disk '/u01/dangerousfrog/dangerousfrog0', '/u01/dangerousfrog/dangerousfrog1', '/u01/dangerousfrog/dangerousfrog2', '/u01/dangerousfrog/dangerousfrog3', '/u01/dangerousfrog/dangerousfrog4', '/u01/dangerousfrog/dangerousfrog5'; create tablespace testspace datafile '+CARELESSCHICKEN' size 10m autoextend on next 100m extent management local segment space management auto; export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/11.2.0/grid export ORACLE_SID=+ASM export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib export NLS_LANG=American_America.UTF8 export NLS_SORT=AMERICAN export NLS_DATE_LANGUAGE=AMERICAN _______________________________________________ 2-й этап ( ALTER DISKGROUP dangerousfrog MOUNT; ALTER DISKGROUP carelesschicken MOUNT; ) 1)Удалить диск #2 из группы "carelesschicken". alter diskgroup carelesschicken drop disk carelesschicken_0001; 2)Удалить диск #6 из группы "carelesschicken". alter diskgroup carelesschicken drop disk carelesschicken_0006; 3)Добавить новую дисковую группу "interestingsnake[3]"; размер AU - 2 МБ. mkdir /u01/interestingsnake/ dd if=/dev/zero of=/u01/interestingsnake/interestingsnake0 bs=1k count=100000 dd if=/dev/zero of=/u01/interestingsnake/interestingsnake1 bs=1k count=100000 dd if=/dev/zero of=/u01/interestingsnake/interestingsnake2 bs=1k count=100000 /usr/sbin/lofiadm -a /u01/interestingsnake/interestingsnake0 /usr/sbin/lofiadm -a /u01/interestingsnake/interestingsnake1 /usr/sbin/lofiadm -a /u01/interestingsnake/interestingsnake2 chown oracle:dba /u01/interestingsnake create diskgroup interestingsnake normal redundancy disk '/u01/interestingsnake/interestingsnake0', '/u01/interestingsnake/interestingsnake1', '/u01/interestingsnake/interestingsnake2' ATTRIBUTE 'AU_SIZE'='2M'; 4)Добавить новый диск в группу carelesschicken. dd if=/dev/zero of=/u01/carelesschicken/carelesschicken7 bs=1k count=100000 /usr/sbin/lofiadm -a /u01/carelesschicken/carelesschicken7 chown oracle:dba /u01/carelesschicken/carelesschicken7 alter diskgroup carelesschicken add disk '/u01/carelesschicken/carelesschicken7'; 5)Удалить дисковую группу "interestingsnake". DROP DISKGROUP interestingsnake INCLUDING CONTENTS; 6) Пересоздать группу "carelesschicken", сконфигурировав в ней избыточность следующим образом: Размер группы - 9 элементов. Тип избыточности - "HIGH"; количество failure-групп - 3. Равномерно распределить диски по failure-группам. DROP DISKGROUP carelesschicken INCLUDING CONTENTS; CREATE DISKGROUP carelesschicken HIGH REDUNDANCY FAILGROUP failure_group_1 DISK '/u01/carelesschicken/carelesschicken0' NAME carelesschicken0, '/u01/carelesschicken/carelesschicken1' NAME carelesschicken1, '/u01/carelesschicken/carelesschicken2' NAME carelesschicken2 FAILGROUP failure_group_2 DISK '/u01/carelesschicken/carelesschicken3' NAME carelesschicken3, '/u01/carelesschicken/carelesschicken4' NAME carelesschicken4, '/u01/carelesschicken/carelesschicken5' NAME carelesschicken5 FAILGROUP failure_group_3 DISK '/u01/carelesschicken/carelesschicken6' NAME carelesschicken6, '/u01/carelesschicken/carelesschicken7' NAME carelesschicken7, '/u01/carelesschicken/carelesschicken8' NAME carelesschicken8; 7)Одной командой удалить дисковую группу "carelesschicken" и добавить новую дисковую группу "thinowl[5]"; размер AU - 4 МБ. DROP DISKGROUP carelesschicken INCLUDING CONTENTS; create diskgroup thinowl normal redundancy disk '/u01/thinowl/thinowl0', '/u01/thinowl/thinowl1', '/u01/thinowl/thinowl2', '/u01/thinowl/thinowl3', '/u01/thinowl/thinowl4' ATTRIBUTE 'AU_SIZE'='4M'; 8)Добавить новую дисковую группу "sadkangaroo[3]"; размер AU - 4 МБ. create diskgroup interestingsnake normal redundancy disk '/u01/sadkangaroo/sadkangaroo0', '/u01/sadkangaroo/sadkangaroo1', '/u01/sadkangaroo/sadkangaroo2' ATTRIBUTE 'AU_SIZE'='4M';