1. 首先把,主备库的参数文件修改好。
2. 主库使用rman做全备份, 创建对应的备份目录(主备目录一致)
a. rman target /
b. backup full database format='/data2/rmanbak/FOR_STANDBY_sid_%u' ;
3. 创建备库控制文件:
a. sqls
b. alter database create standby controlfile as '/rmanbackup/sid.ctl';
4. 将备份文件和控制文件 一起拷贝到目标主机对应的目录。
并把控制文件放到正确的 位置和命名
5.
a.startup nomount
b.alter database mount standby database;
6 rman(备库)
a. rman target /
b. restore database;
7. 备库启用恢复
alter database recover managed standby database disconnect from session;
8. 对比验证
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
select open_mode ,log_mode , switchover_status ,database_role from v$database ;
-----------------------
1. 主库
*.LOG_ARCHIVE_DEST_2='SERVICE=sid LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
2.
orapwd FILE=orapwsid PASSWORD=****** ENTRIES=30
2. 主库使用rman做全备份, 创建对应的备份目录(主备目录一致)
a. rman target /
b. backup full database format='/data2/rmanbak/FOR_STANDBY_sid_%u' ;
3. 创建备库控制文件:
a. sqls
b. alter database create standby controlfile as '/rmanbackup/sid.ctl';
4. 将备份文件和控制文件 一起拷贝到目标主机对应的目录。
并把控制文件放到正确的 位置和命名
5.
a.startup nomount
b.alter database mount standby database;
6 rman(备库)
a. rman target /
b. restore database;
7. 备库启用恢复
alter database recover managed standby database disconnect from session;
8. 对比验证
SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
select open_mode ,log_mode , switchover_status ,database_role from v$database ;
-----------------------
1. 主库
*.LOG_ARCHIVE_DEST_2='SERVICE=sid LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
2.
orapwd FILE=orapwsid PASSWORD=****** ENTRIES=30