DG错误处理 ORA 10458 standby database requires recovery
dg同步后，打开备库失败
[oracle@oracle19ca dg]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 5 17:07:36 2024
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open;
alter database open
*
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/ORCL/datafile/o1_mf_system_mflx3jpt_.dbf'
将最近的归档日志拷贝到standby机器上
[oracle@oracle19cb db_1]$ cd /u01/app/oracle/product/19.0.0/db_1/dbs/arch/
/u01/app/oracle/oradata/ncc/arch
[oracle@oracle19cb arch]$ ll
总用量 237072
-rw-r----- 1 oracle oinstall 35909120 9月 5 11:22 0001_298_1106315410.arc
-rw-r----- 1 oracle oinstall 135896576 9月 5 11:22 0001_299_1106315410.arc
-rw-r----- 1 oracle oinstall 225792 9月 5 11:23 0001_300_1106315410.arc
-rw-r----- 1 oracle oinstall 22093312 9月 5 13:13 0001_301_1106315410.arc
-rw-r----- 1 oracle oinstall 32244224 9月 5 15:00 0001_302_1106315410.arc
-rw-r----- 1 oracle oinstall 9253376 9月 5 16:01 0001_303_1106315410.arc
-rw-r----- 1 oracle oinstall 1024 9月 5 16:03 0001_304_1106315410.arc
-rw-r----- 1 oracle oinstall 730112 9月 5 16:12 0001_305_1106315410.arc
-rw-r----- 1 oracle oinstall 4608 9月 5 16:12 0001_306_1106315410.arc
-rw-r----- 1 oracle oinstall 3072 9月 5 16:12 0001_307_1106315410.arc
-rw-r----- 1 oracle oinstall 3584 9月 5 16:12 0001_308_1106315410.arc
-rw-r----- 1 oracle oinstall 4096 9月 5 16:12 0001_309_1106315410.arc
-rw-r----- 1 oracle oinstall 591360 9月 5 16:22 0001_310_1106315410.arc
-rw-r----- 1 oracle oinstall 3072 9月 5 16:22 0001_311_1106315410.arc
-rw-r----- 1 oracle oinstall 7168 9月 5 16:22 0001_312_1106315410.arc
-rw-r----- 1 oracle oinstall 4096 9月 5 16:22 0001_313_1106315410.arc
-rw-r----- 1 oracle oinstall 5758464 9月 5 17:07 0001_314_1106315410.arc
[oracle@oracle19cb arch]$ scp * oracle@172.16.150.129://home/oracle/logfile/
scp * oracle@172.16.150.130://home/oracle/logfile/
以下在dg从库上操作：
[root@oracle19ca ~]# chown -R oracle:oinstall /home/oracle/logfile/
[oracle@oracle19ca dg]$ rman target /
RMAN> catalog start with '/home/oracle/logfile';
catalog start with '/home/oracle/89156arch';
using target database control file instead of recovery catalog
searching for all files that match the pattern /home/oracle/logfile
List of Files Unknown to the Database
=====================================
File Name: /home/oracle/logfile/0001_298_1106315410.arc
File Name: /home/oracle/logfile/0001_299_1106315410.arc
。。。
Do you really want to catalog the above files (enter YES or NO)? y
cataloging files...
cataloging done
RMAN> recover database;
Starting recover at 05-SEP-24
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=745 device type=DISK
starting media recovery
archived log for thread 1 with sequence 314 is already on disk as file /home/oracle/logfile/0001_314_1106315410.arc
archived log file name=/home/oracle/logfile/0001_314_1106315410.arc thread=1 sequence=314
media recovery complete, elapsed time: 00:00:00
Finished recover at 05-SEP-24
RMAN> quit
Recovery Manager complete.
[oracle@oracle19ca dg]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Sep 5 17:25:46 2024
Version 19.13.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.13.0.0.0
SQL> alter database open;
Database altered.
