Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "database ORA-01196 failure-example analysis of archived log loss recovery", the content is easy to understand, well-organized, hope to help you solve your doubts, the following let the editor lead you to study and learn "database ORA-01196 failure-example analysis of archived log loss recovery" this article.

Question:

Due to the power outage in the computer room, one of the DG repositories could not be open, and it was wrong to start the Times.

Start the error below the database times

SQL > alter database open;alter database open*

An error occurred on line 1:

ORA-10458: standby database requiresrecovery

ORA-01196: file 1 is inconsistent due to media recovery session failure

ORA-01110: the data file 1 is the data file 1, which is the data database. System. 313.884996245'

Check the application of archived logs and find that some logs are not applied.

SQL > Select Name,Sequence#,applied,completion_time From v$archived_log Order By Sequence# Desc Name Sequence# applied completion_time+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328776.705.939567729 328776 YES NO 2017/3/2515:02+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328775.713.939567727 328775 YES NO 2017ax 3x3x3xxxxxxxxxxxxxxxxxxxxxxx Seq_328774.777.939567727 328774 YES NO 2017/3/2515:02+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328773.771.939567725 328773 YES NO 2017/3/2515:02+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328772.422.939567721 328772 YES NO 2017/3/2515:02+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328771.482.939567721 328771 YES NO 2017/3/2515: 02+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328770.755.939567721 328770 YES NO 2017/3/2515:02+FRA/htdb7/archivelog/2017_03_24/thread_1_seq_328757.1255.939481573 328757 YES NO 2017/3/2415:06+FRA/htdb7/archivelog/2017_03_24/thread_1_seq_328756.795.939480431 328756 YES YES 2017/3/2414:47+FRA/htdb7/archivelog/2017_03_24/thread_1_seq_328755 . 543.939479395 328755 YES YES 2017/3/2414:29+FRA/htdb7/archivelog/2017_03_24/thread_1_seq_328754.390.939478683 328754 YES YES 2017/3/2414:18+FRA/htdb7/archivelog/2017_03_24/thread_1_seq_328753.1845.939477943 328753 YES YES 2017Accord 3Universe 2414purl 05-compare with archived logs from other backup or main libraries It is obvious that this standby library does not synchronize and apply the logs of the main library-- this standby library: [oracle@hotel07 ~] $asmcmd-pASMCMD [+ fra/htdb7/ARCHIVELOG] > cd 2017_03_24/ASMCMD [+ fra/htdb7/ARCHIVELOG/2017_03_24] > ls.thread_1_seq_328754.390.939478683thread_1_seq_328755.543.939479395thread_1_seq_328756.795.939480431thread_1_seq_328757.1255.939481573-- other positive The regular library [oracle@hotel05 ~] $asmcmd-pASMCMD [+ fra/htdb5/ARCHIVELOG/2017_03_24] > lsthread_1_seq_328754.4124.939478683thread_1_seq_328755.349.939479395thread_1_seq_328756.852.939480431thread_1_seq_328757.1420.939481575thread_1_seq_328758.3356.939510647thread_1_seq_328759.4592.939510649thread_1_seq_328760.3205.939510647thread_1_seq_328761.5308.939510649thread_1_seq_328762.5227.939510653.

Solution:

You need to manually transfer the missing archive logs from other standby or main libraries, and then perform open operation.

The steps are as follows:

1. Back up the missing archive logs with rman in another normal repository

[oracle@hotel05 ~] $rman target / RMAN > copy archivelog'+fra/htdb5/ARCHIVELOG/2017_03_24/thread_1_seq_328759.4592.939510649' to'/home/oracle/arcbak/thread_1_seq_328759.4592.939510649'

Launch backup from 25 to March to 17

Use channel ORA_DISK_1

Channel ORA_DISK_1: starting to copy archive logs

Enter archive log thread = 1 sequence = 328759 RECID=328754 STAMP=939510652

Output file name = / home/oracle/arcbak/thread_1_seq_328759.4592.939510649 RECID=328794STAMP=939571923

Channel ORA_DISK_1: replication of archive logs is complete. Time elapsed: 00:00:03

Completion of backup in 25-3-17

.

. After the backup is complete, transfer the archive to the repository where the archive is lost

[oracle@hotel05 arcbak] $scp * hotel07:/home/oracle/arcbak/

3. Then perform the restore operation on this repository

-- compiling a catalogue of archived documents

[oracle@hotel07 ~] $rman target /

Recovery Manager: Release 11.2.0.2.0-Production on Saturday March 25 15 purl 42purl 112017

Copyright (c) 1982, 2009, Oracle and/or itsaffiliates. All rights reserved.

Connected to the target database: HTDB4 (DBID=1083719948, not open)

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

Search all files that match the style / home/oracle/arcbak

List of unknown files in the database = = file name: / home/oracle/arcbak/thread_1_seq_328763.4773.939510653 file name: / home/oracle/arcbak/thread_1_seq_328767.2765.939511033 file name: / home/oracle/arcbak/thread_1_seq_328766.5854.939511023 file name: / home/oracle/arcbak/thread_1_seq_328759.4592.939510649 file name: / home/oracle/arcbak/thread_1_seq _ 328758.3356.939510647 file name: / home/oracle/arcbak/thread_1_seq_328760.3205.939510647 file name: / home/oracle/arcbak/thread_1_seq_328762.5227.939510653 file name: / home/oracle/arcbak/thread_1_seq_328761.5308.939510649 file name: / home/oracle/arcbak/thread_1_seq_328757.1420.939481575 file name: / home/oracle/arcbak/thread_1_seq_328764.5801. 939510653 File name: / home/oracle/arcbak/thread_1_seq_328765.3298.939510657

Are you sure you want to list the above files in the directory (enter YES or NO)? Y

A catalogue of documents is being compiled.

The catalogue has been compiled

List of files listed in the directory = = file name: / home/oracle/arcbak/thread_1_seq_328763.4773.939510653 file name: / home/oracle/arcbak/thread_1_seq_328767.2765.939511033 file name: / home/oracle/arcbak/thread_1_seq_328766.5854.939511023 file name: / home/oracle/arcbak/thread_1_seq_328759.4592.939510649 file name: / home/oracle/arcbak/thread_1_ Seq_328758.3356.939510647 file name: / home/oracle/arcbak/thread_1_seq_328760.3205.939510647 file name: / home/oracle/arcbak/thread_1_seq_328762.5227.939510653 file name: / home/oracle/arcbak/thread_1_seq_328761.5308.939510649 file name: / home/oracle/arcbak/thread_1_seq_328757.1420.939481575 file name: / home/oracle/arcbak/thread_1_seq_328764.5801 .939510653 filename: / home/oracle/arcbak/thread_1_seq_328765.3298.939510657-- recovery archive log RMAN > copy archivelog'/ home/oracle/arcbak/thread_1_seq_328757.1420.939481575' to'+ fra'

Launch backup from 25 to March to 17

Use channel ORA_DISK_1

Channel ORA_DISK_1: starting to copy archive logs

Enter archive log thread = 1 sequence = 328760 RECID=149368 STAMP=939573701

Output file name = + FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328760.474.939573739RECID=149375 STAMP=939573738

Channel ORA_DISK_1: replication of archive logs is complete. Time elapsed: 00:00:01

Completion of backup in 25-3-17

.

4. Finally, you can open the database.

SQL > alter database open;SQL > select open_mode from v$database OPEN_MODE-READ ONLY WITH APPLY-View logs Archived logs are applied normally alter database openData Guard Broker initializing...Data Guard Broker initialization completeBeginning standby crash recovery.Serial Media Recovery startedManaged Standby Recovery starting Real TimeApplyMedia Recovery Log+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328757.499.939573737Media Recovery Log/home/oracle/arcbak/thread_1_seq_328758.3356.939510647Sat Mar 25 16:43:57 2017Incomplete Recovery applied until change91347484119 time 03 Universe 24 15:06:26Completed standby crash recovery.Sat Mar 2017 15:06:26Completed standby crash recovery.Sat Mar 25 16:43:58 2017SMON: enabling cache RecoveryDictionary check beginningDictionary check completeDatabase Characterset is ZHS16GBKNo Resource Manager plan activereplication_dependency_tracking turned off (no async multimaster replication found) Physical standby database opened for readonly access.Completed: alter database openSat Mar 25 16:44:01 2017ALTER DATABASE RECOVER MANAGED STANDBYDATABASE THROUGH ALL SWITCHOVERDISCONNECT USING CURRENT LOGFILEAttempt to start background Managed StandbyRecovery process (htdb7) Sat Mar 25 16:44:01 2017MRP0 started with pid=47 OS id=9619MRP0: Background Managed Standby Recoveryprocess started (htdb7) started logmerger processSat Mar 25 16:44:06 2017Managed Standby Recovery starting Real TimeApplyParallel Media Recovery started with 16slavesWaiting for all non-current ORLs to bearchived...All non-current ORLs have been archived.Media Recovery Log / home/oracle/arcbak/thread_1_seq_328758.3356.939510647Media Recovery Log+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328759.1574.939573739Completed: ALTER DATABASE RECOVER MANAGEDSTANDBY DATABASE THROUGH ALL SWITCHOVERDISCONNECT USING CURRENT LOGFILEMedia Recovery Log+FRA/htdb7/archivelog/2017_03_ 25/thread_1_seq_328760.922.939573741Media Recovery Log+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328761.695.939573743Media Recovery Log+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328762.1769.939573745Media Recovery Log+FRA/htdb7/archivelog/2017_03_25/thread_1_seq_328763.1422.939573745 above is all the content of the article "Database ORA-01196 failure-example Analysis of Archive Log loss recovery" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.