current position:Home>Handling method of Oracle data file header SCN inconsistency

Handling method of Oracle data file header SCN inconsistency

2022-06-24 09:38:53Huizhou wuyanzu

Oracle DataGuard Environmental Science , Recovered DG The backup database needs to be archived long ago .
 Insert picture description here
The current archives are 4 The beginning.
 Insert picture description here
Check data file header SCN Information

select a.name,a.checkpoint_change# "start_SCN",
b.checkpoint_change# "last_SCN"
from v$datafile_header a, v$datafile b
where a.file#=b.file#;

NAME                                           start_SCN   last_SCN
--------------------------------------------- ---------- ----------
D:\CCDATA\NEWHIS\SYSTEM01.DBF                 3295957260 3311098792
D:\CCDATA\NEWHIS\SYSAUX01.DBF                 3295957262 3311098792
D:\CCDATA\NEWHIS\UNDOTBS01.DBF                3295957279 3311098792
D:\CCDATA\NEWHIS\USERS01.DBF                  3295957260 3311098792
D:\CCDATA\NEWHIS\aaa.ORA                    3295957262 3311098792
D:\CCDATA\NEWHIS\XX.ORA                       3295957261 3311098792
D:\CCDATA\NEWHIS\ffff.ORA                    3295957261 3311098792
D:\CCDATA\NEWHIS\dfg1.ORA                    654876736 3311098792
D:\CCDATA\NEWHIS\eqerg.ORA                   3295957261 3311098792
D:\CCDATA\NEWHIS\dfeg.ORA                   3295957261 3311098792
D:\CCDATA\NEWHIS\dfwt.ORA                   3295957279 3311098792

...

 Have chosen 20 That's ok .

The inspection found that D:\CCDATA\NEWHIS\dfg1.ORA Start of file data file header SCN atypism . The solution is that the master database backs up the data file separately , Then go to the standby database to recover .

Main database backup :

rman target /
backup datafile 8 format 'd:\8.bak';

Backup set copy :
Copy the backup set to the standby database

The standby database registers backup sets :

rman target /
catalog backuppiece 'd:\8.bak';

The backup database recovers data files :

rman target /
restore datafile 8;

The standby database views the data file header :

select a.name,a.checkpoint_change# "start_SCN",
b.checkpoint_change# "last_SCN"
from v$datafile_header a, v$datafile b
where a.file#=b.file#;

NAME                                           start_SCN   last_SCN
--------------------------------------------- ---------- ----------
D:\CCDATA\NEWHIS\SYSTEM01.DBF                 3295957260 3311098792
D:\CCDATA\NEWHIS\SYSAUX01.DBF                 3295957262 3311098792
D:\CCDATA\NEWHIS\UNDOTBS01.DBF                3295957279 3311098792
D:\CCDATA\NEWHIS\USERS01.DBF                  3295957260 3311098792
D:\CCDATA\NEWHIS\aaa.ORA                    3295957262 3311098792
D:\CCDATA\NEWHIS\XX.ORA                       3295957261 3311098792
D:\CCDATA\NEWHIS\ffff.ORA                    3295957261 3311098792
D:\CCDATA\NEWHIS\dfg1.ORA                    3295957261 3311098792
D:\CCDATA\NEWHIS\eqerg.ORA                   3295957261 3311098792
D:\CCDATA\NEWHIS\dfeg.ORA                   3295957261 3311098792
D:\CCDATA\NEWHIS\dfwt.ORA                   3295957279 3311098792

copyright notice
author[Huizhou wuyanzu],Please bring the original link to reprint, thank you.
https://en.cdmana.com/2022/175/202206240817364103.html

Random recommended