oracle 19c 搭建dataguard 简要命令

恢复控制文件

restore standby controlfile from service cdb;

恢复数据文件

alter database mount;
CONFIGURE DEVICE TYPE DISK PARALLELISM 8;
restore database from service cdb section size 2G;

gap 处理

RECOVER STANDBY DATABASE FROM SERVICE cdb;

ALLOCATE CHANNEL t1 DEVICE TYPE DISKCONNECT 'sys/oracle@cdb’;

ALLOCATE CHANNEL t1 DEVICE TYPE DISK
CONNECT 'sys/pwd@bkp1’

SET ECHO ON
RUN
{
ALLOCATE CHANNEL t1 DEVICE TYPE DISK CONNECT 'sys/oracle@cdb';
restore standby controlfile;
}

RUN
{
allocate channel c1 type disk connect 'sys/oracle@cdb';
restore standby controlfile from service cdb;
}