Possible Data Guard Issue
Date: Mon, 20 Jun 2022 17:05:02 +0000
Message-ID: <MWHPR16MB15506F07FE9EC6625A04A192C5B09_at_MWHPR16MB1550.namprd16.prod.outlook.com>
We are running Oracle 19.15 on Red Hat 7.
On Friday, one of my co-workers tried to convert the physical standby to a snapshot standby to use it to refresh another database. He got an error saying more standby was needed in order to convert. Looking into the alert log, there are messages saying that several files are "fuzzy". He re-established the data guard, but now the standby database says that all of the files are "fuzzy".
DGMGRL> show configuration
Configuration - CLAWPRDA
Protection Mode: MaxPerformance
Members:
CLAWPRDB - Primary database
CLAWPRDA - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 8 seconds ago)
DGMGRL> convert database 'CLAWPRDA' to snapshot standby; Converting database "CLAWPRDA" to a Snapshot Standby database, please wait... Error: ORA-38788: More standby database recovery is needed
Failed.
Failed to convert database "CLAWPRDA"
DGMGRL>
SQL> select fuzzy, status, error, recover, checkpoint_change#, checkpoint_time, count(*) from v$datafile_header group by fuzzy, status, error, recover, checkpoint_change#, checkpoint_time ;
FUZ STATUS ERROR REC CHECKPOINT_CHANGE# CHECKPOIN COUNT(*)
--- ------- ----------------------------------------------------------------- --- ------------------ --------- ----------------
YES ONLINE 16551458200934 20-JUN-22 16
1 row selected.
SQL> select file#, substr(name, 1, 50), substr(tablespace_name, 1, 15), undo_opt_current_change# from v$datafile_header where fuzzy='YES' ;
FILE# SUBSTR(NAME,1,50) SUBSTR(TABLESPA UNDO_OPT_CURRENT_CHANGE#
---------------- -------------------------------------------------- --------------- ----------------------------------------
1 /oracle/data/CLAWPRDA/sys01.dbf SYSTEM
2 /oracle/data/CLAWPRDA/sysaux01.dbf SYSAUX
3 /oracle/data/CLAWPRDA/undotbs01.dbf UNDOTBS
4 /oracle/data/CLAWPRDA/users01.dbf USERS
5 /oracle/data/CLAWPRDA/claws_data_enc01.dbf CLAWS_DATA_ENC
6 /oracle/data/CLAWPRDA/claws_data_enc02.dbf CLAWS_DATA_ENC
7 /oracle/data/CLAWPRDA/claws_data_enc03.dbf CLAWS_DATA_ENC
8 /oracle/data/CLAWPRDA/claws_data_enc04.dbf CLAWS_DATA_ENC
9 /oracle/data/CLAWPRDA/claws_idx_enc01.dbf CLAWS_IDX_ENC
10 /oracle/data/CLAWPRDA/claws_idx_enc02.dbf CLAWS_IDX_ENC
11 /oracle/data/CLAWPRDA/quest01.dbf QUEST
12 /oracle/data/CLAWPRDA/claws_data_enc05.dbf CLAWS_DATA_ENC
13 /oracle/data/CLAWPRDA/claws_data_enc06.dbf CLAWS_DATA_ENC
14 /oracle/data/CLAWPRDA/claws_data_enc07.dbf CLAWS_DATA_ENC
15 /oracle/data/CLAWPRDA/claws_data_enc08.dbf CLAWS_DATA_ENC
16 /oracle/data/CLAWPRDA/claws_data_enc09.dbf CLAWS_DATA_ENC
16 rows selected.
SQL> select status, enabled, count(*) from v$datafile group by status, enabled ;
STATUS ENABLED COUNT(*)
------- ---------- ----------------
ONLINE READ WRITE 15 SYSTEM READ WRITE 1
2 rows selected.
SQL> However, Cloud Control says all is well. Logs are being shipped and applied.
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 20 2022 - 19:05:02 CEST