Post

2 followers Follow
0
Avatar

v_datafile_header.error=CORRUPT HEADER

>>> Renaming standby redo logs and tempfiles on DB21... done
>>> Performing checkpoint and archiving logs... done
>>> Finishing standby database creation... done
Problem validating standby datafiles:
    file#=1
    v_datafile.name=Z:\ORACLE\ORADATA\DBAF\SYSTEM01.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=Z:\ORACLE\ORADATA\DBAF\SYSTEM01.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=2
    v_datafile.name=Z:\ORACLE\ORADATA\DBAF\SYSAUX01.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=Z:\ORACLE\ORADATA\DBAF\SYSAUX01.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=3
    v_datafile.name=Z:\ORACLE\ORADATA\DBAF\UNDOTBS01.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=Z:\ORACLE\ORADATA\DBAF\UNDOTBS01.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=4
    v_datafile.name=Z:\ORACLE\ORADATA\DBAF\USERS01.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=Z:\ORACLE\ORADATA\DBAF\USERS01.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=5
    v_datafile.name=Z:\ORACLE\ORADATA\DBAF\EXAMPLE01.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=Z:\ORACLE\ORADATA\DBAF\EXAMPLE01.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=6
    v_datafile.name=E:\TABLESPACES\DATA_APLIC.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=E:\TABLESPACES\DATA_APLIC.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=7
    v_datafile.name=E:\TABLESPACES\DATA_APLIC_2.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=E:\TABLESPACES\DATA_APLIC_2.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=8
    v_datafile.name=E:\TABLESPACES\INDEX_APLIC.DBF
    v_datafile.checkpoint_change=26078097757A
    v_datafile.bytes=0
    v_datafile_header.name=E:\TABLESPACES\INDEX_APLIC.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
    file#=9
    v_datafile.name=E:\TABLESPACES\INDEX_APLIC_2.DBF
    v_datafile.checkpoint_change=26078097757
    v_datafile.bytes=0
    v_datafile_header.name=E:\TABLESPACES\INDEX_APLIC_2.DBF
    v_datafile_header.checkpoint_change=0
    v_datafile_header.bytes=0
    v_datafile_header.error=CORRUPT HEADER
>>> Standby database created.
To complete creating standby database please run dbvctl on the primary server first,
then on the standby server, to ensure the standby database is in sync with the primary
database.
PID:2616
TRACE:2616_dbvctl_csd_DBAF_201708010932.trc
C:\Program Files\Dbvisit\Standby>
C:\Program Files\Dbvisit\Standby>
Ramon Estevez Answered

Please sign in to leave a comment.

1 comment

0
Avatar

We usually require a bit more information to properly analyse the problem you are experiencing.

Answers to the following questions will help.

1)What OS and OS version are you running on Primary and Standby.
2)What Dbvisit Standby version are you running on Primary and Standby.
3)What Oracle Database version and Edition are you running on Primary and Standby.
4)Are you using ASM / file system on Primary?
5)Are you using ASM / file system on Standby?
6)What types of filesystems are you using, ext3, ext4, NFS ...?
7)Would you be able to provide some file stats on the Standby system?
8)Provide the alert.log from the Primary and Standby database.
9)Provide the tracefile reported - 2616_dbvctl_csd_DBAF_201708010932.trc

As well as the output of the following queries executed against the Standby db.

set linesize 200 pagesize 20
col name for a50
col error for a20
col checkpoint_change# for 999999999999
col unrecoverable_change# for 999999999999
col first_nonlogged_scn for 999999999999
col current_scn for 999999999999
col resetlogs_change# for 999999999999
col controlfile_change# for 999999999999
spool dbv-primary-{{ticket.id}}.txt

alter session set nls_date_format='dd/mm/yyyy:hh24:mi:ss';

select file#, status, enabled, name, round(bytes/1024/1024,2) size_mb, checkpoint_change#, unrecoverable_change#, first_nonlogged_scn, checkpoint_change# from v$datafile df order by file#;
select file#, name, status, error, recover, fuzzy, creation_change#, checkpoint_change#, round(bytes/1024/1024,2) size_mb from v$datafile_header order by 1;
select dbid, name, resetlogs_change#, checkpoint_change#, controlfile_change#, controlfile_sequence#, controlfile_time, current_scn from v$database;
select * from v$database_incarnation;

spool off

We've seen this behaviour before and usually this happens when the storage/disks are slow and the system load runs high.
These are messages from Oracle.

We suggest you review your system load and retry the operation. 

 

 

 

 

Charmaigne Bezuidenhout 0 votes
Comment actions Permalink