3:拷贝之前创建的备份集到Standby Database Server上,目标路径同Primary Database Server上备份集创建的文件路径,在这里为/data/backup/
ftp or nfs (省略)
4:将Standby Database置于Nomount状态
fb-dbbak$sqlplus "/ as sysdba"
SQL> create spfile from pfile;
SQL> startup force nomount
5:在PrimaryDatabase Server上使用RMAN连接target及auxiliary Database(輔助數據庫).,执行duplicate target database for standby nofilenamecheck dorecover命令创建Standby Database(DORECOVER),最后RMAN会将Standby Database置于Mount Standby Database状态 duplicate(復制)
首先修改Primary Database Server上TNSNAMES。ORA文件,使得在Primary Database Server上可以连接到Standby Database。
fb-db$cd /u01/product/oracle/network/admin
fb-db$vi tnsnames.ora
STANDBY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.216)(PORT = 1783))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = rma)
)
)
fb-db$tnsping STANDBY
fb-db$cd
fb-db$ rman target / auxiliary sys/sys@STANDBY(正向)
或fbrmadbbak rman target sys/oracle@wsjhrm auxiliary /(反向)
RMAN> duplicate target database for standby nofilenamecheck dorecover;
....................
Finished restore at 29-NOV-07
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12137615/viewspace-539834/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12137615/viewspace-539834/