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

Ogg extraction process abend, check and find that the log of the slave database has been deleted:

2018-10-11 11:14:52 ERROR OGG-00446 Could not find archived log for sequence 20064 thread 2 under default destinations SQL, error retrieving redo file name for sequence 20064, archived = 1, use_alternate = 0Not able to establish initia

L position for sequence 20064, rba 235066896.

2018-10-11 11:14:52 ERROR OGG-01668 PROCESS ABENDING.

Copy the log to the master library:

ASMCMD > cp thread_2_seq_20064.489.989227143 / home/grid/thread_2_seq_20064.489.989227143

Copying + arch/chunqiu/ARCHIVELOG/2018_10_11/thread_2_seq_20064.489.989227143-> / home/grid/thread_2_seq_20064.489.989227143

Copy the scp to a remote repository and register for archiving:

Alter database register logfile'/ home/oracle/thread_2_seq_20064.489.989227143'

Restart the extraction process, normal.

Test log reference:

1. Register a small number of logs:

SQL > alter database register logfile'/ home/oracle/thread_2_seq_20064.489.989227143'

two。 Register a large number of logs

Rman > catalog start with'/ home/oracle/archlog'

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.