使用RMAN 创建DATAGUARD ,在两台服务器上:
1) 主库初始化参数文件主要参数:
log_archive_dest_1='LOCATION=/u1/oracle/archive'
2) 备库初始化参数文件主要参数:
log_archive_dest_1='LOCATION=/u1/oracle/archive'
log_archive_dest_2='service=lmj'
fal_client=clon
fal_server=lmj
standby_archive_dest='/u1/oracle/archive'
standby_file_management='AUTO'
service_names='lmj'
local_listener='(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.244)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(KEY = lmj)))'
3) 备库的目录结构和主库要一致.
4) 备库创建参数文件和口令文件.
5) 主备库要添加主库的两个服务名.
6) 在主库系统上做主库RMAN 备份:
run {
allocate channel c1 device type disk;
backup as compressed backupset
format '/u1/backup/db_%T_%s_%p.dbf'
database tag='db_full';
backup format '/u1/backup/arc_%T_%s.%p.dbf'
archivelog all delete input
tag='arc_bak';
backup format '/u1/backup/stbcon.bak'
current controlfile for standby reuse
tag='db_stb';
}
7) 将主库的备份集 COPY 到备库的相同目录下.
8) 在备库上实现RMAN 创建备库的 DATAGUARD
$: rman catalog rman/rman@rman target sys/oracle@lmj
rman> connect auxiliary /;
rman> run {
allocate auxiliary channel c1 device type disk;
duplicate target database for standby nofilenamecheck;
}
1) 主库初始化参数文件主要参数:
log_archive_dest_1='LOCATION=/u1/oracle/archive'
2) 备库初始化参数文件主要参数:
log_archive_dest_1='LOCATION=/u1/oracle/archive'
log_archive_dest_2='service=lmj'
fal_client=clon
fal_server=lmj
standby_archive_dest='/u1/oracle/archive'
standby_file_management='AUTO'
service_names='lmj'
local_listener='(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.244)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(KEY = lmj)))'
3) 备库的目录结构和主库要一致.
4) 备库创建参数文件和口令文件.
5) 主备库要添加主库的两个服务名.
6) 在主库系统上做主库RMAN 备份:
run {
allocate channel c1 device type disk;
backup as compressed backupset
format '/u1/backup/db_%T_%s_%p.dbf'
database tag='db_full';
backup format '/u1/backup/arc_%T_%s.%p.dbf'
archivelog all delete input
tag='arc_bak';
backup format '/u1/backup/stbcon.bak'
current controlfile for standby reuse
tag='db_stb';
}
7) 将主库的备份集 COPY 到备库的相同目录下.
8) 在备库上实现RMAN 创建备库的 DATAGUARD
$: rman catalog rman/rman@rman target sys/oracle@lmj
rman> connect auxiliary /;
rman> run {
allocate auxiliary channel c1 device type disk;
duplicate target database for standby nofilenamecheck;
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14359194/viewspace-622504/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14359194/viewspace-622504/