Oracle 12c DG Standby alert error ORA-10877 full database recovery

12C Oracle Data Guard Repository Today exception

2018-07-05t21:31:32.291970+08:00
GEN0 (ospid:75371): Terminating the instance due to error 472
2018-07-05t21:31:32.293376+08:00
System State Dump requested by (Instance=1, osid=75371 (GEN0)), summary=[abnormal instance termination].
System state dumped to trace file/u01/app/oracle/diag/rdbms/dwjrstdydb/dwjrstdydb/trace/dwjrstdydb_diag_75381_ 20180705213132.trc
2018-07-05t21:31:32.872916+08:00
Dumping diagnostic data in directory=[cdmp_20180705213132], requested by (Instance=1, osid=75371 (GEN0)), summary=[ Abnormal instance termination].
2018-07-05t21:31:34.229888+08:00
Instance terminated by GEN0, PID = 75371

Standby Crash Recovery aborted due to error 10877.
2018-07-05t21:34:51.173635+08:00
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/DWJRSTDYDB/DWJRSTDYDB/TRACE/DWJRSTDYDB_ORA_94302.TRC:
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
2018-07-05t21:34:51.173984+08:00
Recovery interrupted!
Some recovered datafiles maybe left media fuzzy
Media recovery may continue and open resetlogs may fail
2018-07-05t21:34:51.175705+08:00
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/DWJRSTDYDB/DWJRSTDYDB/TRACE/DWJRSTDYDB_PR00_94311.TRC:
Ora-16043:redo apply has been canceled.
ora-16016:archived Log for thread 1 sequence# unavailable
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery slave
Ora-10877:error signaled in parallel recovery SLA
ORA-10877 signalled during:alter database open ...

Go to the main library to backup, and then use the most original way to recover the database; Rman backup direct restore, recover way, the main library script, backup control files, parameter files, the whole library backup;
Rman Target/

Run
{Allocate channel C1 type disk;
Allocate channel C2 type disk;
Allocate channel C3 type disk;
Backup Filesperset 3 as compressed backupset database format '/home/oracle/0705/fulldata%d%T%s%p ‘;
Backup Archivelog all format '/home/oracle/0705/arch%d%T%s%p ' delete input;
Backup current controlfile format '/home/oracle/0705/ctl%d%T%s_%p ';
}

Backup the control file separately
Backup current controlfile for standby format '/home/oracle/ctl.bak ';
Full SCP of the backup set to the standby repository
SCP 0705/* 18.10.11.12:/home/oracle/0705
Scp/home/oracle/ctl.bak 18.10.11.12:/home/oracle/0705

Standby to no mount stage for restore standby controlfile recovery control file

rman> restore standby controlfile from '/home/oracle/0705/ctl_dwjrdb_20180705_73_1 ';

Standby Library to Mount stage

rman> catalog start with '/home/oracle/0705 ';

Start the RESTORE database operation

rman> Restore Database;

Start Rocover database operation

rman> Recover database;

rman> ALTER DATABASE open;

Standby Library Application Log
Sql>alter database recover managed standby database using current logfile disconnect from session;

View repository information;
Sql> Select process, status, thread#,sequence#, block#, blocks from V$managed_standby;

PROCESS STATUS thread# sequence# block# BLOCKS

RFS IDLE 0 0 0 0
RFS IDLE 0 0 0 0
ARCH CLOSING 1 158 1 7
DGRD Allocated 0 0 0 0
DGRD Allocated 0 0 0 0
ARCH CLOSING 1 164 1 5
ARCH CLOSING 1 157 1 8
ARCH CLOSING 1 165 1 6
RFS IDLE 1 166 3624 1
MRP0 Applying_log 1 166 3624 2097152

Rows selected.

I would like to record that a good memory than a bad pen ~

Oracle 12c DG Standby alert error ORA-10877 full database recovery

Alibaba Cloud Hot Products
Elastic Compute Service (ECS)	Dedicated Host (DDH)	ApsaraDB RDS for MySQL (RDS)	ApsaraDB for PolarDB(PolarDB)	AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL)	Data Transmission Service (DTS)	Server Load Balancer (SLB)	Global Accelerator (GA)	Cloud Enterprise Network (CEN)
Object Storage Service (OSS)	Content Delivery Network (CDN)	Short Message Service (SMS)	Container Service for Kubernetes (ACK)	Data Lake Analytics (DLA)
ApsaraDB for Redis (Redis)	ApsaraDB for MongoDB (MongoDB)	NAT Gateway	VPN Gateway	Cloud Firewall
Anti-DDoS	Web Application Firewall (WAF)	Log Service	DataWorks	MaxCompute
Elastic MapReduce (EMR)	Elasticsearch