dataguard offline

alter database recover managed standby database cancel;

alter session set container=appdb;

alter database datafile 11 offline drop;

select status,FILE# from v$datafile where file#=11;

alter database recover managed standby database using current logfile disconnect;

#############

oneline 报错：

alter database recover managed standby database cancel;

alter session set container=appdb;

alter database datafile 11 online;

*

ERROR at line 1:

ORA-01113: file 11 needs media recovery

ORA-01110: data file 11:

'+ARCH/SPDB19C/ED068853EA9868D3E0530B39A8C0E59F/DATAFILE/undotbs1.623.1156154065

'

##############

shu immediate

startup mount

#如果归档丢失需要先对文件进行recover from service;

#recover datafile 11 from service xxxx;

alter session set container=appdb;

alter database datafile 11 online;

exit

sqlplus / as sysdba

alter database open;

<<<< 在启动过程对文件进行recover，本地没有归档，自动通过gap处理。

alter database open

PR00 (PID:110018): Media Recovery Waiting for T-1.S-91

PR00 (PID:110018): Fetching gap from T-1.S-91 to T-1.S-93

#########

模拟归档日志丢失：

delete force noprompt archivelog all;

SQL> alter database open

*

ERROR at line 1:

ORA-10458: standby database requires recovery

ORA-01152: file 11 was not restored from a sufficiently old backup

ORA-01110: data file 11:

'+ARCH/SPDB19C/ED068853EA9868D3E0530B39A8C0E59F/DATAFILE/undotbs1.623.1156154065

'

RMAN> recover database from service pdb19c;

SQL> alter database open;

Database altered.