主机备份拷贝到备机上进行Rman 还原,完成后用standy controlfile替换。
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 11:06:00 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 5.3687E+10 bytes
Fixed Size 12174808 bytes
Variable Size 6710889000 bytes
Database Buffers 4.6842E+10 bytes
Redo Buffers 122040320 bytes
SQL> alter database mount standby database;
Database altered.
但是打开只读的时候出现错误:
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-10458: standby database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/ep/system01.dbf'
尝试修复失败
SQL> recover database;