ÔÚ RHEL3 ÉϽ«µ¥Ò»ÊµÀýÊý¾Ý¿âת»»Îª RAC (002)
ÉÏһƪ / ÏÂһƪ 2007-02-06 00:00:00 / ¸öÈË·ÖÀࣺ11g&Grid
1a.¼ìÑéÈí¼þ³ÌÐò°ü°æ±¾¡£
°²×°ËùÐèµÄ³ÌÐò°ü¡£
[root@salmon1]# rpm -qa | grep -i compat compat-libstdc++-7.3-2.96.128 compat-gcc-c++-7.3-2.96.128 compat-libstdc++-devel-7.3-2.96.128 compat-db-4.0.14-5 compat-glibc-7.x-2.2.4.32.6 compat-slang-1.4.5-5 compat-gcc-7.3-2.96.128 compat-pwdb-0.62-3 [root@salmon1]# [root@salmon1]# rpm -qa | grep openmotif openmotif-2.2.3-3.RHEL3 [root@salmon1]# [root@salmon1]# rpm -qa | grep -i gcc gcc-gnat-3.2.3-42 gcc-c++-ssa-3.5ssa-0.20030801.48 compat-gcc-c++-7.3-2.96.128 libgcc-ssa-3.5ssa-0.20030801.48 gcc-3.2.3-42 gcc-g77-3.2.3-42 gcc-java-3.2.3-42 gcc-ssa-3.5ssa-0.20030801.48 gcc-g77-ssa-3.5ssa-0.20030801.48 gcc-objc-ssa-3.5ssa-0.20030801.48 libgcc-3.2.3-42 gcc-c++-3.2.3-42 gcc-objc-3.2.3-42 gcc-java-ssa-3.5ssa-0.20030801.48 compat-gcc-7.3-2.96.128
1b.¼ìÑéÄں˲ÎÊý¡£
¼ìÑéÒÔÏÂÄں˲ÎÊý¡£
[root@salmon1]# sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648
[root@salmon1]# sysctl -a | grep sem
kernel.sem = 250 32000 100 128
[root@salmon1]# sysctl -a | grep -i ip_local
net.ipv4.ip_local_port_range = 1024 65000
[root@salmon1]# sysctl -a | grep -i file-max
fs.file-max = 65536
ÔÚµÚÒ»¸ö½ÚµãÉÏʹÓÃÏÂÃæµÄÐÅÏ¢£¬ÔÚµÚ¶þ¸ö½ÚµãÉÏ´´½¨ oracle Óû§ÒÔ¼° oinstall ºÍ dba ×é¡£
[oracle@salmon1]$ hostname salmon1.dbsconsult.com [oracle@salmon1]$ [oracle@salmon1]$ id uid=500(oracle) gid=500(dba) groups=500(dba),501(oinstall) [oracle@salmon1]$ [oracle@salmon1]$ echo $ORACLE_BASE /u01/app/oracle1d.±à¼ oracle Óû§»·¾³Îļþ¡£
[oracle@salmon1]$ more .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi export PATH=$PATH:$HOME/bin export ORACLE_SID=prod1 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.1.0 export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH umask 0221e.ÅäÖà oracle Óû§ shell ÏÞÖÆ¡£
[root@salmon1]# more /etc/security/limits.conf * soft nproc 2047 * hard nproc 16384 * soft nofile 1024 * hard nofile 65536 [root@salmon1]# grep pam_limits /etc/pam.d/login session required /lib/security/pam_limits.so1f.ÅäÖù«¹²ÍøÂçºÍרÓÃÍøÂç¡£
ʹÓÃÏÂÃæµÄÐÅÏ¢¶ÔÍøÂç½Ó¿ÚÉ豸 eth0£¨¹«¹²£©ºÍ eth1£¨×¨Ó㩽øÐбØÐèµÄ¸ü¸Ä¡£
[root@salmon1]# redhat-config-network
Ö÷»úÃû | IP µØÖ· | ÀàÐÍ |
|---|---|---|
| salmon1.dbsconsult.com | 192.168.0.184 | ¹«¹² (eth0) |
| salmon2.dbsconsult.com | 192.168.0.185 | ¹«¹² (eth0) |
| salmon1.dbsconsult.com | 10.10.10.84 | רÓà (eth1) |
| salmon2.dbsconsult.com | 10.10.10.85 | רÓà (eth1) |
| salmon1-vip.dbsconsult.com | 192.168.0.186 | ÐéÄâ |
| salmon2-vip.dbsconsult.com | 192.168.0.187 | ÐéÄâ |
1g.±à¼ the /etc/hosts Îļþ¡£
127.0.0.1 localhost.localdomain localhost 10.10.10.84 sallocal1.dbsconsult.com sallocal1 10.10.10.85 sallocal2.dbsconsult.com sallocal2 192.168.0.184 salmon1.dbsconsult.com salmon1 192.168.0.185 salmon2.dbsconsult.com salmon2 192.168.0.186 salmon1-vip.dbsconsult.com salmon1-vip 192.168.0.187 salmon2-vip.dbsconsult.com salmon2-vipÑéÖ¤Ö÷»úÃûºÍÅäÖõÄÍøÂç½Ó¿ÚÉ豸¡£
[root@salmon1]# hostname salmon1.dbsconsult.com [root@salmon1]# /sbin/ifconfig
1h.ʹÓà SSH ½¨Á¢Óû§µÈЧÐÔ¡£
ÔÚ¼¯Èº¾ÍÐ÷·þÎñ (CRS) ºÍ RAC °²×°¹ý³ÌÖУ¬Oracle Universal Installer (OUI) ±ØÐëÄܹ»ÒÔ oracle µÄÉí·Ý½«Èí¼þ¸´ÖƵ½ËùÓÐ RAC ½Úµã£¬¶ø²»ÌáʾÊäÈë¿ÚÁî¡£ÔÚ Oracle 10g ÖУ¬¿ÉÒÔʹÓà ssh ´úÌæ rsh Íê³É´Ë²Ù×÷¡£
Òª½¨Á¢Óû§µÈЧÐÔ£¬ÇëÔÚÁ½¸ö½ÚµãÉÏÒÔ oracle Óû§µÄÉí·ÝÉú³ÉÓû§µÄ¹«Ô¿ºÍ˽Կ¡£
[oracle@salmon1]$ ssh-keygen -t dsa Generating public/private dsa key pair. Enter file in which to save the key (/home/oracle/.ssh/id_dsa): Created directory '/home/oracle/.ssh'. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/oracle/.ssh/id_dsa. Your public key has been saved in /home/oracle/.ssh/id_dsa.pub. The key fingerprint is: 5d:8c:42:97:eb:42:ae:52:52:e9:59:20:2a:d3:6f:59 oracle@salmon1.dbsconsult.comÔÚÿ¸ö½ÚµãÉϲâÊÔÁ¬½Ó¡£ÑéÖ¤µ±ÄúÔÙ´ÎÔËÐÐÒÔÏÂÃüÁîʱ£¬ÏµÍ³ÊÇ·ñ²»ÌáʾÄúÊäÈë¿ÚÁî¡£
ssh salmon1 date ssh salmon2 date ssh sallocal1 date ssh sallocal2 date ssh salmon1.dbsconsult.com date ssh salmon2.dbsconsult.com date ssh sallocal1.dbsconsult.com date ssh sallocal2.dbsconsult.com date1i.ÅäÖà hangcheck timer ÄÚºËÄ£¿é¡£
hangcheck timer ÄÚºËÄ£¿é¼à¿ØÏµÍ³µÄÔËÐÐÇé¿ö£¬²¢ÖØÐÂÆô¶¯³öÏÖ¹ÊÕ쵀 RAC ½Úµã¡£ËüʹÓÃÁ½¸ö²ÎÊý£¬¼´ hangcheck_tick£¨¶¨Òåϵͳ¼ì²éƵÂÊ£©ºÍ hangcheck_margin£¨¶¨ÒåÔÚÖØÖà RAC ½ÚµãǰµÄ×î´ó¹ÒÆðÑÓʱ£©À´È·¶¨½ÚµãÊÇ·ñ³öÏÖ¹ÊÕÏ¡£
ÔÚ /etc/rc.d/rc.local ÖÐÌí¼ÓÒÔÏÂÐÐÒÔ×Ô¶¯¼ÓÔØ hangcheck Ä£¿é¡£
[root@salmon1]# grep insmod /etc/rc.d/rc.local insmod hangcheck-timer hangcheck_tick=30 hangcheck_margin=1801j.ÖØÐ´´½¨Êý¾Ý¿â¿ØÖÆÎļþ¡£
ÔÚת»»µ½ RAC ֮ǰ£¬È·±£ÔÚ¿ØÖÆÎļþÖÐÕýÈ·µ÷ÕûÒÔÏÂÏîµÄ´óС¡£Èç¹ûÐèÒª£¬ÇëʹÓÃÕýÈ·µÄÉèÖÃÖØÐ´´½¨Êý¾Ý¿â¿ØÖÆÎļþ¡£
MAXLOGFILES MAXLOGMEMBERS MAXDATAFILES MAXINSTANCES MAXLOGHISTORY1k.µ÷ÕûÊý¾Ý¿â»º³åÇø¸ßËÙ»º´æ¡£
´Óµ¥Ò»ÊµÀýÊý¾Ý¿âת»»µ½ RAC ʱ£¬Êý¾Ý¿â»º³åÇø¸ßËÙ»º´æÐèÒª¶îÍâµÄÄÚ´æ¡£ÔÚ RAC ÖУ¬ÎªÃ¿¸ö¿é»º³åÇø¸ßËÙ»º´æÖеÄÈ«¾Ö¸ßËÙ»º´æ·þÎñ (GCS) ·ÖÅä¿Õ¼ä¡£ËùÐèµÄ¶îÍâÄÚ´æÁ¿È¡¾öÓÚÓ¦ÓóÌÐò·ÃÎÊÊý¾ÝµÄ·½Ê½£¬¼´Í¬Ò»¸ö¿éÊÇ·ñ¸ßËÙ»º´æµ½¶à¸öʵÀýÖС£
ÔÚÑÝʾʵÑéÖУ¬Îҹ۲쵽»º³åÇø¸ßËÙ»º´æµÄʹÓÃÂÊÔö¼ÓÁË´óÔ¼ 8%¡£Ê¹Óûº³åÇø¸ßËÙ»º´æ¹ËÎÊÈ·¶¨×î¼ÑµÄ»º³åÇø¸ßËÙ»º´æ´óС£¬»òÇл»µ½ Oracle ×Ô¶¯¹²ÏíÄÚ´æ¹ÜÀí (ASMM) Èà Oracle ½øÐпØÖÆ¡£
µÚ 2 ²½£º½«Êý¾Ý¿âÒÆÖ²µ½ ASM
ASM ʵÀýÓëÊý¾Ý¿âʵÀýÖ®¼äµÄͬ²½ÐèÒª Oracle ¼¯ÈºÍ¬²½·þÎñ (CSS) ºǫ́³ÌÐò¡£ÒªÆô¶¯ ASM ʵÀý£¬±ØÐëÆô¶¯ CSS ºǫ́³ÌÐò¡£°²×°»òÉý¼¶µ½ Oracle Êý¾Ý¿â 10g ʱ£¬Ó¦¸ÃÒѾΪµ¥½Úµã°æ±¾ÅäÖÃÁË CSS£¬²¢ÇÒ CSS Ó¦ÔÚÏµÍ³ÖØÐÂÆô¶¯Ê±×Ô¶¯Æô¶¯¡£
[root@salmon1]# ps a€¡°ef | grep ocssd.bin | wc a€¡°l
17
2a.ÏÂÔØ ASM RPM. ´Ó OTN ÏÂÔØÒÔÏ ASM RPM£º
- oracleasm-support-2.0.0-1.i386.rpm
- oracleasm-2.4.21-27.EL-1.0.4-2.i686.rpm£¨UP Äں˵ÄÇý¶¯³ÌÐò£©»ò oracleasm-2.4.21-27.ELsmp-1.0.4-1.i686.rpm£¨SMP Äں˵ÄÇý¶¯³ÌÐò£©
- oracleasmlib-2.0.0-1.i386.rpm
2b.°²×° ASM RPM¡£
ÒÔ root Óû§µÄÉí·Ý°²×° ASM RPM¡£
[root@salmon1]# rpm -i oracleasm-support-2.0.0-1.i386.rpm [root@salmon1]# rpm -i oracleasm-2.4.21-27.EL-1.0.4-2.i686.rpm Linking module oracleasm.o into the module path [ OK ] [root@salmon1]# rpm -i oracleasmlib-2.0.0-1.i386.rpm [root@salmon1]# rpm -qa | grep oracleasm oracleasm-2.4.21-27.EL-1.0.4-2 oracleasm-support-2.0.0-1 oracleasmlib-2.0.0-12c.ÅäÖÃ ASM¡£
ÒÔ root Óû§µÄÉí·ÝÅäÖà ASMLib¡£
[root@salmon1]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver.The following questions will determine whether the driver is
loaded on boot and what permissions it will have.The current values
will be shown in brackets ('[]').Hitting without typing an
answer will keep that current value.Ctrl-C will abort.
Default user to own the driver interface []:oracle
Default group to own the driver interface []:dba
Start Oracle ASM library driver on boot (y/n) [n]:y
Fix permissions of Oracle ASM disks on boot (y/n) [y]:y
Writing Oracle ASM library driver configuration [ OK ]
Creating /dev/oracleasm mount point [ OK ]
Loading module "oracleasm" [ OK ]
Mounting ASMlib driver filesystem [ OK ]
Scanning system for ASM disks
2d.´´½¨ ASM ´ÅÅÌ¡£ ÒÔ root Óû§µÄÉí·ÝÔÚÈκÎÒ»¸ö½ÚµãÉÏ´´½¨ ASM ´ÅÅÌ¡£
[root@salmon1]# /etc/init.d/oracleasm createdisk VOL1 /dev/sdg5 Marking disk "/dev/sdg5" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL2 /dev/sdg6 Marking disk "/dev/sdg6" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL3 /dev/sdg7 Marking disk "/dev/sdg7" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL4 /dev/sdg8 Marking disk "/dev/sdg8" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL5/dev/sdg9 Marking disk "/dev/sdg9" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL6 /dev/sdg10 Marking disk "/dev/sdg10" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL7 /dev/sdg11 Marking disk "/dev/sdg11" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL8 /dev/sdg12 Marking disk "/dev/sdg12" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL9 /dev/sdg13 Marking disk "/dev/sdg13" as an ASM disk [ OK ] [root@salmon1]# /etc/init.d/oracleasm createdisk VOL10 /dev/sdg14 Marking disk "/dev/sdg14" as an ASM disk [ OK ]ÑéÖ¤ÄÜ·ñ´Óÿ¸ö½Úµã¿´µ½ ASM ´ÅÅÌ¡£
[root@salmon1]# /etc/init.d/oracleasm listdisks VOL1 VOL2 VOL3 VOL4 VOL5 VOL6 VOL7 VOL8 VOL9 VOL10 [root@salmon1]# /etc/init.d/oracleasm scandisks Scanning system for ASM disks [ OK ]2e.´´½¨ ASM init.ora¡£
ÔÚµÚÒ»¸ö½ÚµãÉÏ£¬Ê¹ÓÃÒÔϲÎÊýÔÚ $ORACLE_HOME/dbs Öд´½¨Ò»¸ö init+ASM1A.ora Îļþ£º
#asm_diskgroups='DG1', a€?DG2a€?, a€?RECOVERYDESTa€? asm_diskstring='ORCL:VOL*' background_dump_dest=/u01/app/oracle/admin/+ASM/bdump core_dump_dest=/u01/app/oracle/admin/+ASM/cdump user_dump_dest=/u01/app/oracle/admin/+ASM/udump instance_type=asm large_pool_size=16M remote_login_passwordfile=exclusive +ASM1A.instance_number=1 +ASM1B.instance_number=22f.´´½¨ ASM ¿ÚÁîÎļþ¡£
ʹÓà orapwd ʵÓóÌÐòÔÚµÚÒ»¸ö½ÚµãÉ쵀 $ORACLE_HOME/dbs Öд´½¨Ò»¸ö orapw+ASM1A Îļþ¡£
[oracle@salmon1]$ cd $ORACLE_HOME/dbs [oracle@salmon1]$ orapwd file=orapw+ASM1A password=sys entries=52g.´´½¨µÚÒ»¸ö ASM ʵÀý¡£
ÔÚµÚÒ»¸ö½ÚµãÉÏ´´½¨µÚÒ»¸ö ASM ʵÀý¡£½« CRS Èí¼þ°²×°µ½µÚ¶þ¸ö½Úµãºó£¬½«ÔÚ¡°ºóÐø°²×°¡±Öд´½¨µÚ¶þ¸ö ASM ʵÀý¡£
[oracle@salmon1]$ export ORACLE_SID=+ASM1A [oracle@salmon1]$ sqlplus / as sysdba SQL*Plus:Release 10.1.0.3.0 - Production on Thu May 26 05:51:07 2005 Copyright (c) 1982, 2004, Oracle.±£ÁôËùÓÐȨÀû¡£ Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 104857600 bytes Fixed Size 777616 bytes Variable Size 104079964 bytes Database Buffers 0 bytes Redo Buffers 0 bytes ORA-15110:no diskgroups mounted2h.´´½¨ ASM ʵÀý spfile¡£
ÔÚ ASM ʵÀýÆô¶¯ºóÁ¢¼´´´½¨Ò»¸ö spfile¡£Ê¹Óà spfile Îļþ£¬ÈκÎн¨µÄ´ÅÅÌ×é¶¼½«×Ô¶¯Ìí¼Óµ½ spfile Îļþ¡£
SQL> create spfile from pfile; File created.2i.´´½¨´ÅÅÌ×é¡£
´´½¨Èý¸ö´ÅÅÌ×飺DG1¡¢DG2 ºÍ RECOVERYDEST¡£DG1 ºÍ DG2 ½«ÓÃÓÚ´æ´¢ Oracle Êý¾ÝÎļþºÍÖØ×öÈÕÖ¾¡£RECOVERYDEST ½«ÓÃ×÷ÉÁ»Ø»Ö¸´Çø¡£
SQL> create diskgroup dg1 normal redundancy 2 failgroup fg1a disk 3 'ORCL:VOL1','ORCL:VOL2' 4 failgroup fg1b disk 5 'ORCL:VOL3','ORCL:VOL4'; Diskgroup created. SQL> create diskgroup dg2 normal redundancy 2 failgroup fg2a disk 3 'ORCL:VOL5','ORCL:VOL6' 4 failgroup fg2b disk 5 'ORCL:VOL7','ORCL:VOL8'; Diskgroup created. SQL> create diskgroup recoverydest normal redundancy 2 failgroup fgrd1 disk 3 'ORCL:VOL9' 4 failgroup fgrd2 disk 5 'ORCL:VOL10'; Diskgroup created. SQL> show parameter diskgroup NAME TYPE VALUE ------------------------------ ----------- ----------------------------- asm_diskgroups string DG1, DG2, RECOVERYDEST SQL> select name,total_mb from v$asm_diskgroup; NAME TOTAL_MB ------------------------- ------------------- DG1 36864 DG2 36864 RECOVERYDEST 73728 3 rows selected. SQL> select name,path,failgroup from v$asm_disk; NAME PATH FAILGROUP -------- --------------- ---------------- VOL1 ORCL:VOL1 FG1A VOL10 ORCL:VOL10 FGRD2 VOL2 ORCL:VOL2 FG1A VOL3 ORCL:VOL3 FG1B VOL4 ORCL:VOL4 FG1B VOL5 ORCL:VOL5 FG2A VOL6 ORCL:VOL6 FG2A VOL7 ORCL:VOL7 FG2B VOL8 ORCL:VOL8 FG2B VOL9 ORCL:VOL9 FGRD1 10 rows selected.2j.ÅäÖÃÉÁ»Ø»Ö¸´Çø¡£
SQL> connect sys/sys@prod1 as sysdba Connected. SQL> alter database disable block change tracking; Database altered. SQL> alter system set db_recovery_file_dest_size=72G; System altered. SQL> alter system set db_recovery_file_dest=a€?+RECOVERYDESTa€?; System altered.2k.½«Êý¾ÝÎļþÒÆÖ²µ½ ASM¡£
±ØÐëʹÓà RMAN ½«Êý¾ÝÎļþÒÆÖ²µ½ ASM ´ÅÅÌ×é¡£ËùÓÐÊý¾ÝÎļþ¶¼½«ÒÆÖ²µ½Ð´´½¨µÄ´ÅÅÌ×é DG1¡£ÔÚ DG1 ºÍ DG2 Öд´½¨ÖØ×öÈÕÖ¾ºÍ¿ØÖÆÎļþ¡£ÔÚÉú²ú»·¾³ÖУ¬Ó¦½«ÖØ×öÈÕÖ¾´æ´¢µ½ÓëÓàÏ嵀 Oracle Êý¾ÝÎļþ²»Í¬µÄ´ÅÅÌ×éºÍ´ÅÅÌ¿ØÖÆÆ÷ÉÏ¡£
SQL> connect sys/sys@prod1 as sysdba Connected. SQL> alter system set db_create_file_dest=a€?+DG1a€?; System altered. SQL> alter system set control_files='+DG1/cf1.dbf' scope=spfile; System altered. SQL> shutdown immediate; [oracle@salmon1]$ rman target / RMAN> startup nomount; Oracle instance started Total System Global Area 419430400 bytes Fixed Size 779416 bytes Variable Size 128981864 bytes Database Buffers 289406976 bytes Redo Buffers 262144 bytes RMAN> restore controlfile from '/u02/oradata/prod1/control01.ctl'; Starting restore at 26-MAY-05 using target database controlfile instead of recovery catalog allocated channel:ORA_DISK_1 channel ORA_DISK_1:sid=160 devtype=DISK channel ORA_DISK_1:copied controlfile copy output filename=+DG1/cf1.dbf Finished restore at 26-MAY-05 RMAN> alter database mount; database mounted released channel:ORA_DISK_1 RMAN> backup as copy database format '+DG1'; Starting backup at 26-MAY-05 allocated channel:ORA_DISK_1 channel ORA_DISK_1:sid=160 devtype=DISK channel ORA_DISK_1:starting datafile copy input datafile fno=00001 name=/u02/oradata/prod1/system01.dbf output filename=+DG1/prod1/datafile/system.257.1 tag=TAG20050526T073442 recid=1 stamp=559294642 channel ORA_DISK_1:datafile copy complete, elapsed time: 00:02:49 channel ORA_DISK_1:starting datafile copy input datafile fno=00003 name=/u02/oradata/prod1/sysaux01.dbf output filename=+DG1/prod1/datafile/sysaux.258.1 tag=TAG20050526T073442 recid=2 stamp=559294735 channel ORA_DISK_1:datafile copy complete, elapsed time: 00:01:26 channel ORA_DISK_1:starting datafile copy input datafile fno=00002 name=/u02/oradata/prod1/undotbs01.dbf output filename=+DG1/prod1/datafile/undotbs1.259.1 tag=TAG20050526T073442 recid=3 stamp=559294750 channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:15 channel ORA_DISK_1:starting datafile copy input datafile fno=00004 name=/u02/oradata/prod1/users01.dbf output filename=+DG1/prod1/datafile/users.260.1 tag=TAG20050526T073442 recid=4 stamp=559294758 channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1:starting datafile copy copying current controlfile output filename=+DG1/prod1/controlfile/backup.261.1 tag=TAG20050526T073442 recid=5 stamp=559294767 channel ORA_DISK_1:datafile copy complete, elapsed time: 00:00:08 Finished backup at 26-MAY-05 RMAN> switch database to copy; datafile 1 switched to datafile copy "+DG1/prod1/datafile/system.257.1" datafile 2 switched to datafile copy "+DG1/prod1/datafile/undotbs1.259.1" datafile 3 switched to datafile copy "+DG1/prod1/datafile/sysaux.258.1" datafile 4 switched to datafile copy "+DG1/prod1/datafile/users.260.1" RMAN> alter database open; database opened RMAN> exit SQL> connect sys/sys@prod1 as sysdba Connected. SQL> select tablespace_name, file_name from dba_data_files; TABLESPACE FILE_NAME --------------------- ----------------------------------------- USERS +DG1/prod1/datafile/users.260.1 SYSAUX +DG1/prod1/datafile/sysaux.258.1 UNDOTBS1 +DG1/prod1/datafile/undotbs1.259.1 SYSTEM +DG1/prod1/datafile/system.257.12l.½«ÁÙʱ±í¿Õ¼äÒÆÖ²µ½ ASM¡£
SQL> alter tablespace temp add tempfile size 100M; Tablespace altered. SQL> select file_name from dba_temp_files; FILE_NAME ------------------------------------- +DG1/prod1/tempfile/temp.264.32m.½«ÖØ×öÈÕÖ¾ÒÆÖ²µ½ ASM¡£
ɾ³ýÏÖÓеÄÖØ×öÈÕÖ¾£¬²¢ÔÚ ASM ´ÅÅÌ×é DG1 ºÍ DG2 ÖÐÖØÐ´´½¨ËüÃÇ¡£
SQL> alter system set db_create_online_log_dest_1='+DG1'; System altered. SQL> alter system set db_create_online_log_dest_2='+DG2'; System altered. SQL> select group#, member from v$logfile; GROUP# MEMBER --------------- ---------------------------------- 1 /u03/oradata/prod1/redo01.log 2 /u03/oradata/prod1/redo02.log SQL> alter database add logfile group 3 size 10M; Database altered. SQL> alter system switch logfile; System altered. SQL> alter database drop logfile group 1; Database altered. SQL> alter database add logfile group 1 size 100M; Database altered. SQL> alter database drop logfile group 2; Database altered. SQL> alter database add logfile group 2 size 100M; Database altered. SQL> alter system switch logfile; System altered. SQL> alter database drop logfile group 3; Database altered. SQL> select group#, member from v$logfile; GROUP# MEMBER --------------- ---------------------------------------- 1 +DG1/prod1/onlinelog/group_1.265.3 1 +DG2/prod1/onlinelog/group_1.257.1 2 +DG1/prod1/onlinelog/group_2.266.3 2 +DG2/prod1/onlinelog/group_2.258.12n.´Ó spfile Îļþ´´½¨ pfile Îļþ¡£
´´½¨²¢±£ÁôÊý¾Ý¿â pfile µÄ¸±±¾¡£Äú½«ÉÔºóÔÚ¡°ºóÐø°²×°¡±ÖÐÏò pfile ÖÐÌí¼Ó¸ü¶àµÄ RAC ÌØ¶¨²ÎÊý¡£
SQL> connect sys/sys@prod1 as sysdba Connected. SQL> create pfile='/tmp/tmppfile.ora' from spfile; File created.2o.Ìí¼ÓÆäËû¿ØÖÆÎļþ¡£
Èç¹ûÐèÒªÆäËû¿ØÖÆÎļþÒÔʵÏÖÈßÓ࣬Ôò¿ÉÒÔÔÚ ASM Öд´½¨Ëü,·½·¨ÓëÔÚÆäËûÈκÎÎļþϵͳÖд´½¨Ïàͬ¡£
SQL> connect sys/sys@prod1 as sysdba Connected to an idle instance. SQL> startup mount ORACLE instance started. Total System Global Area 419430400 bytes Fixed Size 779416 bytes Variable Size 128981864 bytes Database Buffers 289406976 bytes Redo Buffers 262144 bytes Database mounted. SQL> alter database backup controlfile to '+DG2/cf2.dbf'; Database altered. SQL> alter system set control_files='+DG1/cf1.dbf ','+DG2/cf2.dbf' scope=spfile; System altered. SQL> shutdown immediate; ORA-01109:database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 419430400 bytes Fixed Size 779416 bytes Variable Size 128981864 bytes Database Buffers 289406976 bytes Redo Buffers 262144 bytes Database mounted. Database opened. SQL> select name from v$controlfile; NAME --------------------------------------- +DG1/cf1.dbf +DG2/cf2.dbf½«ËùÓÐÊý¾ÝÎļþ³É¹¦ÒÆÖ²µ½ ASM ºó£¬½«²»ÔÙÐèÒª¾ÉµÄÊý¾ÝÎļþ²¢¿ÉÒÔ½«Æäɾ³ý¡£ÄúµÄµ¥Ò»ÊµÀýÊý¾Ý¿âÏÖÔÚÔÚ ASM ÉÏÔËÐУ¡
µ¼ÈëÂÛ̳ ÒýÓÃÁ´½Ó ÊÕ²Ø ·ÖÏí¸øºÃÓÑ ÍÆ¼öµ½È¦×Ó ¹ÜÀí ¾Ù±¨
TAG:
±êÌâËÑË÷
ÈÕÀú
|
|||||||||
| ÈÕ | Ò» | ¶þ | Èý | ËÄ | Îå | Áù | |||
| 1 | 2 | 3 | |||||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
| 11 | 12 | 13 | 14 | 15 | 16 | 17 | |||
| 18 | 19 | 20 | 21 | 22 | 23 | 24 | |||
| 25 | 26 | 27 | 28 | 29 | 30 | 31 | |||
Êý¾Ýͳ¼Æ
- ·ÃÎÊÁ¿: 12315
- ÈÕÖ¾Êý: 1129
- ͼƬÊý: 1
- ÊéÇ©Êý: 1
- ½¨Á¢Ê±¼ä: 2007-12-13
- ¸üÐÂʱ¼ä: 2008-06-02

