1.修改主库属性

SQL>shutdown immediate;
SQL>startup mount
SQL>archive log list;
SQL>alter database force logging; --查看状态 select FORCE_LOGGING from v$database;
SQL>alter database open;

2.创建并编辑pfile

SQL>create pfile from spfile;
vi $ORACLE_HOME/dbs/

3.对主库进行全库备份

configure redundancy 1;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/u03/oldyang/backup/controlfile_autobackup_%F';
configure backup optimization on;

backup database format '/u03/oldyang/backup/datafiles_%U' include current controlfile plus archivelog format '/u03/oldyang/backup/archivelogs_%U' delete all input;

REPORT OBSOLETE;
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;

4.备份控制文件

SQL>alter database create standby controlfile as '/u03/oldyang/backup/control01.ctl';

5.使用SCP传输RMAN备份及控制文件到备机

scp /u03/oldyang/backup/* oracle@169.254.0.12:/u03/youngyang/backup

cp /u03/youngyang/backup/control01.ctl /u01/youngyang/controlfile01/control01.ctl
cp /u01/youngyang/controlfile01/control01.ctl /u02/youngyang/controlfile02/control02.ctl
cp /u01/youngyang/controlfile01/control01.ctl /u03/youngyang/controlfile03/control03.ctl

6. 启动备机实例并恢复数据文件

SQL>startup nomount pfile=?/dbs/initoldyang.ora
SQL>alter database mount

[oracle@oracle02 dbs]$ rman target /

RMAN>delete backup;
RMAN>catalog start with '/u03/youngyang/backup/';

run {
set newname for datafile 1 to '/u02/youngyang/oradata01/system01.dbf';
restore datafile 1;
set newname for datafile 2 to '/u02/youngyang/oradata02/undotbs01.dbf';
restore datafile 2;
set newname for datafile 3 to '/u02/youngyang/oradata01/sysaux01.dbf';
restore datafile 3;
set newname for datafile 4 to '/u02/youngyang/oradata01/users01.dbf';
restore datafile 4;
set newname for datafile 5 to '/u02/youngyang/oradata01/users02.dbf';
restore datafile 5;
set newname for datafile 6 to '/u02/youngyang/oradata02/convert_test01.dbf';
restore datafile 6;
switch datafile all;
}

RMAN>recover database;

SQL>create spfile from pfile;
SQL>shutdown immediate;
SQL>startup nomount;
SQL>alter database mount standby database;

7. 添加standby redo logfile

alter database add standby logfile group 7 ('/u02/youngyang/redo01/stdredo07a.LOG','/u02/youngyang/redo02/stdredo07b.LOG') size 10M;
alter database add standby logfile group 8 ('/u02/youngyang/redo01/stdredo08a.LOG','/u02/youngyang/redo02/stdredo08b.LOG') size 10M;
alter database add standby logfile group 9 ('/u02/youngyang/redo01/stdredo09a.LOG','/u02/youngyang/redo02/stdredo09b.LOG') size 10M;
alter database add standby logfile group 10 ('/u02/youngyang/redo01/stdredo10a.LOG','/u02/youngyang/redo02/stdredo10b.LOG') size 10M;
alter database add standby logfile group 11 ('/u02/youngyang/redo01/stdredo11a.LOG','/u02/youngyang/redo02/stdredo11b.LOG') size 10M;
alter database add standby logfile group 12 ('/u02/youngyang/redo01/stdredo12a.LOG','/u02/youngyang/redo02/stdredo12b.LOG') size 10M;
alter database add standby logfile group 13 ('/u02/youngyang/redo01/stdredo13a.LOG','/u02/youngyang/redo02/stdredo13b.LOG') size 10M;

8. 启动后台应用

SQL>alter database recover managed standby database disconnect from session;

9. 重启主库

SQL> startup nomount pfile=?/dbs/initoldyang.ora
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 2019320 bytes
Variable Size 79691784 bytes
Database Buffers 83886080 bytes
Redo Buffers 2174976 bytes
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL>startup nomount;
SQL>alter database mount;
SQL>alter database open;

10.核对信息

select message from v$dataguard_status; --查看相关错误信息
select switchover_status from v$database; --转换信息