link:
1.主节点备份并生成备用数据库控制文件
设置主节点为force logging模式(为了双向切换,建议备用节点也设置为force logging模式)
alter database force logging;
设置主节点为归档模式
登陆主节点,进行数据库备份，并生成备用数据库控制文件
last login: mon aug 9 16:46:47 2004 from 172.16.32.65
[root@standby root]# su - oracle
[oracle@standby oracle]$ sqlplus "/ as sysdba"
sql*plus: release 9.2.0.4.0 - production on mon aug 16 10:16:18 2004
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
connected to an idle instance.
sql> startup
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
database opened.
sql> select name from v$datafile;
name
------------------------------------------------------------
/opt/oracle/oradata/primary/system01.dbf
/opt/oracle/oradata/primary/undotbs01.dbf
/opt/oracle/oradata/primary/users01.dbf
sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql> exit
disconnected from oracle9i enterprise edition release 9.2.0.4.0 - production
with the partitioning option
jserver release 9.2.0.4.0 - production
[oracle@standby oracle]$ ls
admin dictionary.ora jre oradata orainventory oui product soft
[oracle@standby oracle]$ tar -cvf oradata.tar oradata
oradata/
oradata/primary/
oradata/primary/archive/
oradata/primary/control01.ctl
oradata/primary/control02.ctl
oradata/primary/control03.ctl
oradata/primary/redo01.log
oradata/primary/redo02.log
oradata/primary/redo03.log
oradata/primary/system01.dbf
oradata/primary/undotbs01.dbf
oradata/primary/temp01.dbf
oradata/primary/users01.dbf
[oracle@standby oracle]$ ls -l *.tar
-rw-r--r-- 1 oracle dba 576512000 aug 16 10:22 oradata.tar
[oracle@standby oracle]$ id
uid=800(oracle) gid=800(dba) groups=800(dba)
[oracle@standby oracle]$ hostname
standby
[oracle@standby oracle]$ sqlplus "/ as sysdba"
sql*plus: release 9.2.0.4.0 - production on mon aug 16 10:27:54 2004
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
connected to an idle instance.
sql> startup
oracle instance started.
total system global area 135337420 bytes
fixed size 452044 bytes
variable size 109051904 bytes
database buffers 25165824 bytes
redo buffers 667648 bytes
database mounted.
database opened.
sql> archive log list;
database log mode archive mode
automatic archival enabled
archive destination /opt/oracle/oradata/primary/archive
oldest online log sequence 88
next log sequence to archive 90
current log sequence 90
sql> alter database create standby controlfile as '/opt/oracle/stdcotrl.ctl';
database altered.
sql> !
ls[oracle@standby oracle]$ ls
admin dictionary.ora jre oradata oradata.tar orainventory oui product soft stdcotrl.ctl
|
2.从主节点创建pfile文件
sql> create pfile from spfile;
file created.
sql> !
[oracle@standby oracle]$ cd $oracle_home/dbs
[oracle@standby dbs]$ ls
initdw.ora init.ora initprimary.ora lkprimary orapwprimary spfileprimary.ora sqlnet.log
|
3.登陆备用节点,ftp获得数据库文件、备用控制文件及参数文件
last login: mon aug 16 08:47:58 2004 from 172.16.32.65
[root@eygle root]# su - oracle
[oracle@eygle oracle]$ ls
admin doc jre oradata orainventory oui product
[oracle@eygle oracle]$ df -k
filesystem 1k-blocks used available use% mounted on
/dev/sda1 5154852 3360600 1532396 69% /
/dev/sda7 101089 25744 70126 27% /home
/dev/sda5 4127076 2686152 1231280 69% /opt
none 515296 0 515296 0% /dev/shm
/dev/sda2 4127108 2218172 1699288 57% /usr
/dev/sda6 2063504 107744 1850940 6% /var
[oracle@eygle oracle]$ ftp 172.16.33.58
connected to 172.16.33.58 (172.16.33.58).
220 (vsftpd 1.2.0)
name (172.16.33.58:root): oracle
331 please specify the password.
password:
230 login successful.
ftp> ls
227 entering passive mode (172,16,33,58,222,252)
150 here comes the directory listing.
drwxr-xr-x 3 800 800 4096 jun 30 07:02 admin
-rw-r--r-- 1 800 800 5422222 jul 13 11:58 dictionary.ora
-rw-r--r-- 1 800 800 1165 aug 16 02:51 initprimary.ora
drwxrwxr-x 4 800 800 4096 jun 30 06:29 jre
drwxrwxr-x 12 800 800 4096 jun 30 06:44 orainventory
drwxr-xr-x 3 800 800 4096 jul 01 06:15 oradata
-rw-r--r-- 1 800 800 576512000 aug 16 02:22 oradata.tar
drwxrwxr-x 6 800 800 4096 jun 30 06:29 oui
drwxr-xr-x 3 800 800 4096 jun 30 05:18 product
drwxr-xr-x 6 800 800 4096 jun 30 04:24 soft
-rw-r----- 1 800 800 1662976 aug 16 02:37 stdcotrl.ctl
226 directory send ok.
ftp> bin
200 switching to binary mode.
ftp> mget oradata.tar
mget oradata.tar? y
227 entering passive mode (172,16,33,58,238,132)
150 opening binary mode data connection for oradata.tar (576512000 bytes).
226 file send ok.
576512000 bytes received in 49.2 secs (1.1e+04 kbytes/sec)
ftp> mget *.ctl
mget stdcotrl.ctl? y
227 entering passive mode (172,16,33,58,73,35)
150 opening binary mode data connection for stdcotrl.ctl (1662976 bytes).
226 file send ok.
1662976 bytes received in 0.14 secs (1.2e+04 kbytes/sec)
ftp> mget initprimary.ora
mget initprimary.ora? y
227 entering passive mode (172,16,33,58,194,239)
150 opening binary mode data connection for initprimary.ora (1165 bytes).
226 file send ok.
1165 bytes received in 0.000325 secs (3.5e+03 kbytes/sec)
ftp> bye
221 goodbye.
[oracle@eygle oracle]$ ls
admin doc initprimary.ora jre oradata oradata.tar orainventory oui product stdcotrl.ctl
[oracle@eygle oracle]$ mv initprimary.ora $oracle_home/dbs
[oracle@eygle oracle]$ cd $oracle_home/dbs
[oracle@eygle dbs]$ ls
a.sql initdw.ora init.ora initprimary.ora initrac1.ora initrac2.ora initrac.ora orapw
orapwrac1 orapwrac2 spfilerac.ora
解包数据文件
[oracle@eygle oracle]$ ls
admin doc jre oradata oradata.tar orainventory oui product stdcotrl.ctl
[oracle@eygle oracle]$ tar -xvf oradata.tar
oradata/
oradata/primary/
oradata/primary/archive/
oradata/primary/control01.ctl
oradata/primary/control02.ctl
oradata/primary/control03.ctl
oradata/primary/redo01.log
oradata/primary/redo02.log
oradata/primary/redo03.log
oradata/primary/system01.dbf
oradata/primary/undotbs01.dbf
oradata/primary/temp01.dbf
oradata/primary/users01.dbf
修改initprimary.ora文件
修改控制文件名称及路径(如果和原配置不同)，增加几个参数,修改后如下:
[oracle@eygle dbs]$ cat initprimary.ora
*.aq_tm_processes=1
*.background_dump_dest='/opt/oracle/admin/primary/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/primary/stdcotrl.ctl'
*.core_dump_dest='/opt/oracle/admin/primary/cdump'
...
*.log_archive_dest_1='location=/opt/oracle/oradata/primary/archive'
*.log_archive_dest_2=''
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
...
*.user_dump_dest='/opt/oracle/admin/primary/udump'
*.utl_file_dir='/opt/oracle'
*.standby_archive_dest='/opt/oracle/oradata/primary/stdarch'
*.fal_server='primary'
*.fal_client='standby'
*.standby_file_management='auto'
创建必要的目录
[oracle@eygle oracle]$ cd $oracle_base/admin
[oracle@eygle admin]$ mkdir primary
[oracle@eygle admin]$ ls
primary rac
[oracle@eygle admin]$ cd primary/
[oracle@eygle primary]$ ls
[oracle@eygle primary]$ mkdir bdump cdump udump
|
4.配置主节点监听器及tnsnames.ora文件
配置后如下:
本文关键：Dataguard配置Step by Step
本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器） 
|