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@xxxxxxx<mailto:srcdco@xxxxxxx> | 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.