增量恢复DG备库（备库缺失归档且这些归档无备份）.txt

明靓

915

5页

14次

2020-05-19

10墨值下载

##主库查看 gap 归档信息

1* select

NAME,THREAD#,SEQUENCE#,FIRST_CHANGE#,FIRST_TIME,NEXT_CHANGE#,NEXT_TIME from

v$archived_log where SEQUENCE#='40152'

NAME THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME

NEXT_CHANGE# NEXT_TIME

-------------------- ---------- ---------- ------------- -----------------

------------ -----------------

2 40152 1.6703E+13 20200224 03:26:02 1.6703E+13

20200224 03:46:37

##确定备份 scn 点

16703034343270

##备库当前 scn 点

SQL> col CURRENT_SCN for 99999999999999999999999999

SQL> SELECT CURRENT_SCN FROM V$DATABASE;

CURRENT_SCN

---------------------------

16703039370345

#####主库 DEFER，enable

alter system set log_archive_dest_state_2='DEFER';

select dest_name,status,error from v$archive_dest;

###主库查看备份 scn 点是否有新的数据文件创建

SQL> SELECT FILE#, NAME FROM V$DATAFILE WHERE CREATION_CHANGE# > 16703034343270;

no rows selected

##备份脚本

vi /picclife/backup/rman_backup.sh

#!/bin/sh

. ~/.bash_profile

cd /picclife/backup

rman target / log=rman_backup.log < rman_backup.sql

vi /picclife/backup/rman_backup.sql

backup AS COMPRESSED BACKUPSET incremental from SCN 16703034343270 database

format '/picclife/backup/ForStandby_%U' tag 'FORSTANDBY';

backup current controlfile for standby format

'/picclife/backup/ForStandbyCTRL.bck';

##执行

nohup sh /picclife/backup/rman_backup.sh &

scp ./ForStandby* oracle@10.135.23.30:/picclife/backup/

##备份花费时间

piece handle=/picclife/backup/ForStandby_fuuscr6t_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_4: backup set complete, elapsed time: 00:00:03

channel ORA_DISK_2: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fruscmqs_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 01:19:36

channel ORA_DISK_3: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fsuscmqt_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 01:20:14

channel ORA_DISK_1: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fquscmqr_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 01:22:37

piece handle=/picclife/backup/ForStandbyCTRL.bck tag=TAG20200330T125731

comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

##restore 备份文件，利用备份的控制文件起库

RMAN> shutdown;

RMAN> startup nomount;

RMAN> restore standby controlfile from '/picclife/backup/ForStandbyCTRL.bck';

Starting restore at 08-JAN-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=5 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/picclife/app/oracle/oradata/dgzpdb/control01.ctl

output file name=/picclife/app/oracle/oradata/dgzpdb/control02.ctl

Finished restore at 08-JAN-20

RMAN> alter database mount;

RMAN> CATALOG START WITH '/picclife/backup';

##恢复

RMAN> RECOVER DATABASE NOREDO;

Starting recover at 30-MAR-20

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/30/2020 14:54:56

RMAN-06094: datafile 138 must be restored

这里的报错是因为恢复后的控制文件中记录的 138 号数据文件与真实位置不一致，从而导致报错

SQL> select FILE#,NAME from v$datafile where file#=138;

FILE# NAME

---------- --------------------------------------------

138 +DATA/newebus/datafilegroupec112.dbf

[oracle@fs-1z1-vm0515 /]$ ls -lrt +DATA/newebus/datafilegroupec112.dbf

ls: cannot access +DATA/newebus/datafilegroupec112.dbf: No such file or

channel ORA_DISK_2: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fruscmqs_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_2: backup set complete, elapsed time: 01:19:36

channel ORA_DISK_3: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fsuscmqt_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_3: backup set complete, elapsed time: 01:20:14

channel ORA_DISK_1: finished piece 1 at 30-MAR-20

piece handle=/picclife/backup/ForStandby_fquscmqr_1_1 tag=FORSTANDBY

comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 01:22:37

piece handle=/picclife/backup/ForStandbyCTRL.bck tag=TAG20200330T125731

comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

##restore 备份文件，利用备份的控制文件起库

RMAN> shutdown;

RMAN> startup nomount;

RMAN> restore standby controlfile from '/picclife/backup/ForStandbyCTRL.bck';

Starting restore at 08-JAN-20

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=5 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/picclife/app/oracle/oradata/dgzpdb/control01.ctl

output file name=/picclife/app/oracle/oradata/dgzpdb/control02.ctl

Finished restore at 08-JAN-20

RMAN> alter database mount;

RMAN> CATALOG START WITH '/picclife/backup';

##恢复

RMAN> RECOVER DATABASE NOREDO;

Starting recover at 30-MAR-20

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 03/30/2020 14:54:56

RMAN-06094: datafile 138 must be restored

这里的报错是因为恢复后的控制文件中记录的 138 号数据文件与真实位置不一致，从而导致报错

SQL> select FILE#,NAME from v$datafile where file#=138;

FILE# NAME

---------- --------------------------------------------

138 +DATA/newebus/datafilegroupec112.dbf

[oracle@fs-1z1-vm0515 /]$ ls -lrt +DATA/newebus/datafilegroupec112.dbf

ls: cannot access +DATA/newebus/datafilegroupec112.dbf: No such file or

of 5

10墨值下载

oracle 高可用

关注

评论