PRIMARY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.144)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = primary)
)
)
STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.60.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = standby)
)
)
7.使用rman备份主库
c:/>rman target /
Recovery Manager: Release 9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: NING (DBID=1192138470)
RMAN> backup database
2> format '/free/oracle/full_%d_%T_%s'；
Starting backup at 06-DEC-06
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/free/oracle/oradata/orcl/system01.dbf
input datafile fno=00003 name=/free/oracle/oradata/orcl/sysaux01.dbf
input datafile fno=00006 name=/free/oracle/oradata/orcl/gaojf1db.dbf
input datafile fno=00007 name=/free/oracle/oradata/orcl/gaojf2db.dbf
input datafile fno=00008 name=/free/oracle/oradata/orcl/gaojf3db.dbf
input datafile fno=00010 name=/free/oracle/oradata/orcl/cicrodb1.dbf
input datafile fno=00011 name=/free/oracle/oradata/orcl/cicrodb11.dbf
input datafile fno=00009 name=/free/oracle/oradata/orcl/gaojf4db.dbf
input datafile fno=00002 name=/free/oracle/oradata/orcl/undotbs01.dbf
input datafile fno=00005 name=/free/oracle/oradata/orcl/gaojfdb.dbf
input datafile fno=00004 name=/free/oracle/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 06-DEC-06
channel ORA_DISK_1: finished piece 1 at 06-DEC-06
channel ORA_DISK_1: backup set complete, elapsed time: 00:03:15
Finished backup at 06-DEC-06
8.生成备库控制文件
SQL>
alter database create standby controlfile as '/free/oracle/oradata/orcl/standby.ctl';
9：复制 rman全备份到备库
利用操作系统命令scp，或者ftp bin方式复制rman全备份到备库。
由于我rman主库备份时设置备份文件位置为/free/oracle，因此必须把此备份文件也放到备库同样的位置。
同时scp 控制文件standby.ctl到备库相应的位置。
10.启动备库到nomount状态
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
11.将备库至于mount状态
SQL> alter database mount standby database;
Database altered.
如果没有password file，则报错：
ORA-01990: error opening password file '/free/oracle/product/10.2.0/db_1/orapworcl.ora '
12.利用rman恢复出备库
oracle@linux:~> rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on 星期四 12月 7 06:39:56 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1132959697, not open)
RMAN>
RMAN> restore database;
Starting backup at 06-DEC-06
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoringdatafile fno=00001 name=/free/oracle/oradata/orcl/system01.dbf
restoringdatafile fno=00003 name=/free/oracle/oradata/orcl/sysaux01.dbf
restoring datafile fno=00006 name=/free/oracle/oradata/orcl/gaojf1db.dbf
restoring datafile fno=00007 name=/free/oracle/oradata/orcl/gaojf2db.dbf
restoring datafile fno=00008 name=/free/