ϲ»¶¾ÍÀ´¶à¿´¿´

ÔÚ RHEL3 ÉϽ«µ¥Ò»ÊµÀýÊý¾Ý¿âת»»Îª RAC (002)

ÉÏһƪ / ÏÂһƪ  2007-02-06 00:00:00 / ¸öÈË·ÖÀࣺ11g&Grid

µÚ 1 ²½£º×¼±¸°²×°

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

1c.´´½¨ Oracle Base Ŀ¼¡¢oracle Óû§ºÍ×é¡£

ÔÚµÚÒ»¸ö½ÚµãÉÏʹÓÃÏÂÃæµÄÐÅÏ¢£¬ÔÚµÚ¶þ¸ö½ÚµãÉÏ´´½¨ 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/oracle
1d.±à¼­ 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 022
1e.ÅäÖà 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.so				 
1f.ÅäÖù«¹²ÍøÂçºÍרÓÃÍøÂç¡£

ʹÓÃÏÂÃæµÄÐÅÏ¢¶ÔÍøÂç½Ó¿ÚÉ豸 eth0£¨¹«¹²£©ºÍ eth1£¨×¨Ó㩽øÐбØÐèµÄ¸ü¸Ä¡£

[root@salmon1]# redhat-config-network
Ö÷»úÃû
IP µØÖ·
ÀàÐÍ
salmon1.dbsconsult.com192.168.0.184¹«¹² (eth0)
salmon2.dbsconsult.com192.168.0.185¹«¹² (eth0)
salmon1.dbsconsult.com10.10.10.84רÓà (eth1)
salmon2.dbsconsult.com10.10.10.85רÓà (eth1)
salmon1-vip.dbsconsult.com192.168.0.186ÐéÄâ
salmon2-vip.dbsconsult.com192.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 date
1i.ÅäÖà 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=180
1j.ÖØÐ´´½¨Êý¾Ý¿â¿ØÖÆÎļþ¡£

ÔÚת»»µ½ RAC ֮ǰ£¬È·±£ÔÚ¿ØÖÆÎļþÖÐÕýÈ·µ÷ÕûÒÔÏÂÏîµÄ´óС¡£Èç¹ûÐèÒª£¬ÇëʹÓÃÕýÈ·µÄÉèÖÃÖØÐ´´½¨Êý¾Ý¿â¿ØÖÆÎļþ¡£

MAXLOGFILES
MAXLOGMEMBERS
MAXDATAFILES
MAXINSTANCES
MAXLOGHISTORY
1k.µ÷ÕûÊý¾Ý¿â»º³åÇø¸ßËÙ»º´æ¡£

´Óµ¥Ò»ÊµÀýÊý¾Ý¿âת»»µ½ 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-1
2c.ÅäÖÃ 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=2
2f.´´½¨ ASM ¿ÚÁîÎļþ¡£

ʹÓà orapwd ʵÓóÌÐòÔÚµÚÒ»¸ö½ÚµãÉ쵀 $ORACLE_HOME/dbs Öд´½¨Ò»¸ö orapw+ASM1A Îļþ¡£

[oracle@salmon1]$ cd $ORACLE_HOME/dbs
[oracle@salmon1]$ orapwd file=orapw+ASM1A password=sys entries=5
2g.´´½¨µÚÒ»¸ö 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 mounted
2h.´´½¨ 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.1                          
2l.½«ÁÙʱ±í¿Õ¼äÒÆÖ²µ½ 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.3         
2m.½«ÖØ×öÈÕÖ¾ÒÆÖ²µ½ 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.1   
2n.´Ó 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:

 

ÆÀ·Ö£º0

ÎÒÀ´ËµÁ½¾ä

ÏÔʾȫ²¿

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

ÈÕÀú

« 2009-01-09  
ÈÕ Ò» ¶þ Èý ËÄ Îå Áù
    123
45678910
11121314151617
18192021222324
25262728293031

Êý¾Ýͳ¼Æ

  • ·ÃÎÊÁ¿: 12315
  • ÈÕÖ¾Êý: 1129
  • ͼƬÊý: 1
  • ÊéÇ©Êý: 1
  • ½¨Á¢Ê±¼ä: 2007-12-13
  • ¸üÐÂʱ¼ä: 2008-06-02

RSS¶©ÔÄ

Open Toolbar