Shulou(Shulou.com)06/01 Report--

12C Oracle Data Guard repository exception today

2018-07-05T21:31:32.291970+08:00

GEN0 (ospid: 75371): terminating the instance due to error

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 but 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# 128 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...

Quickly go to the main database for backup, and then use the most primitive way to restore the database; RMAN backup direct restore, recover way, the main library to write scripts, backup control files, parameter files, full 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'

}

Back up the control files separately

Backup current controlfile for standby format'/ home/oracle/ctl.bak'

Scp all the backup sets to the standby library

Scp 0705amp * 18.10.11.12:/home/oracle/0705

Scp / home/oracle/ctl.bak 18.10.11.12:/home/oracle/0705

Start the standby library to the no mount phase and perform restore standby controlfile recovery control files.

RMAN > restore standby controlfile from'/ home/oracle/0705/ctl_DWJRDB_20180705_73_1'

Start the standby library to the mount phase

RMAN > catalog start with'/ home/oracle/0705'

Start restore database operation

RMAN > restore database

Start rocover database operation

RMAN > recover database

RMAN > alter database open

Prepare database application log

SQL > alter database recover managed standby database using current logfile disconnect from session

View standby database information

SQL > select process, status, thread#,sequence#, block#, blocks from v$managed_standby

PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS

RFS IDLE 0 0 0

RFS IDLE 0 0 0

ARCH CLOSING 1 158 1 7

DGRD ALLOCATED 0 0 0

DGRD ALLOCATED 0 0 0

ARCH CLOSING 1 164 1 5

ARCH CLOSING 1 157 1 8

ARCH CLOSING 1 165 16

RFS IDLE 1 166 3624 1

MRP0 APPLYING_LOG 1 166 3624 2097152

10 rows selected.

For the record, a good memory is not as good as a bad pen.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.