Physical Standby ---- Datafile Creation Issue (Redo corruption)


REDO LOG CORRUPTION AFTER ADDING DATAFILE IN DATAGUARD

I created datafile on  Primary database and  i got  error on standby database as explained below.

On Primary :-



CREATE TABLESPACE DEPTSTTAB01 DATAFILE
  '/u04/deporadata/deptst/detstdata01.pdbf' SIZE 1034M AUTOEXTEND ON NEXT 1024M MAXSIZE UNLIMITED

drop tablespace DEPUATTAB01

ALTER TABLESPACE DEPTSTTAB01 ADD DATAFILE '/u04/deporadata/deptst/deptstdata02.dbf' SIZE 1034M AUTOEXTEND ON  NEXT 1M MAXSIZE UNLIMITED


alter tablespace SLESTSTTAB01 drop datafile '/u04/slesoradata/slestst/sleststdata02.dbf'


On Standby:-  Below error on standby 
WARNING: File being created with same name as in Primary
Existing file may be overwritten
Tue Jan 31 21:04:42 2012
Recovery created file /u04/deporadata/deptst/deptstdata01.dbf
Successfully added datafile 30 to media recovery
Datafile #30: '/u04/deporadata/deptst/deptstdata01.dbf'
Recovery deleting file #28:'/u04/oradata/devstand/depuatdata01.dbf' from controlfile.
Recovery dropped tablespace 'DEPUATTAB01'
WARNING: File being created with same name as in Primary
Existing file may be overwritten
Tue Jan 31 21:05:09 2012
Recovery created file /u04/deporadata/deptst/deptstdata02.dbf
Successfully added datafile 28 to media recovery
Datafile #28: '/u04/deporadata/deptst/deptstdata02.dbf'
Tue Jan 31 21:05:10 2012
Errors in file /u02/db/oracle/admin/devstand/bdump/devstand_mrp0_17195.trc:
ORA-00600: internal error code, arguments: [3689], [28], [], [], [], [], [], []
Errors with log /u05/flash_recovery_area/DEVSTAND/DEVSTAND/archivelog/1_1505_755641595.dbf
MRP0: Background Media Recovery terminated with error 600
Tue Jan 31 21:05:13 2012
Errors in file /u02/db/oracle/admin/devstand/bdump/devstand_mrp0_17195.trc:
ORA-00600: internal error code, arguments: [3689], [28], [], [], [], [], [], []
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Tue Jan 31 21:05:14 2012
Errors in file /u02/db/oracle/admin/devstand/bdump/devstand_mrp0_17195.trc:
ORA-00600: internal error code, arguments: [3689], [28], [], [], [], [], [], []
Tue Jan 31 21:05:14 2012
Errors in file /u02/db/oracle/admin/devstand/bdump/devstand_mrp0_17195.trc:
ORA-00600: internal error code, arguments: [3689], [28], [], [], [], [], [], []
Tue Jan 31 21:18:09 2012


After above Error MRP0  process stopped working and  Physical Standby Database was out of sync.
The redo log 1505  was corrupted and reason is as below.

1)  Bug in oracle for 



         Bug                  Fixed                                          Description
  5623467 10.2.0.4.1, 10.2.0.5, 11.1.0.6, 10.2.0.4.P01 Corrupt redo from ALTER TABLESPACE DROP DATAFILE 


       See  Metalink NOTE:554094.1


2)  I have not added  the /u04/.......   file system path in  parameter DB_FILE_NAME_CONVERT on standby database.




Precautions to Avoid this error:-


  1. Before adding datafiles on primary check the corresponding mount point exists on the standby.
  2. db_file_name_convert  on both sides should be updated with new mounts.
  3. Avoid using Alter Tablesspace  command.


Physical Standby Recovery:-

In above case the physical standby database was out on sync and recovery was not possible due to corrupt redo log so i preferred  to use RMAN duplicate to restore the Physical Standby database.



Also Refer Below :-




 








No comments:

Post a Comment

Subscribe to: Posts (Atom)