RMAN还原数据库报错问题解决案例

186次阅读

没有评论

共计 7093 个字符，预计需要花费 18 分钟才能阅读完成。

报错 1、数据库开启 block change tracking , 恢复完成后打开因文件不存在报错。

RMAN> alter database open resetlogs;

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

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

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

RMAN-03002: failure of alter db command at 10/25/2016 15:02:16

ORA-19751: could not create the change tracking file

ORA-19750: change tracking file: ‘+DATA/cx/changetracking/ctf.348.875544631’

ORA-17502: ksfdcre:4 Failed to create file +DATA/cx/changetracking/ctf.348.875544631

ORA-15046: ASM file name ‘+DATA/cx/changetracking/ctf.348.875544631’ is not in single-file creation form

ORA-17503: ksfdopn:2 Failed to open file +DATA/cx/changetracking/ctf.348.875544631

ORA-15012: ASM file ‘+DATA/cx/changetracking/ctf.348.875544631’ does not exist

RMAN>

故障处理：

关闭 block-change-track 功能，只能在 open 或者 mount 状态修改。恢复时应该在还原结束后，打开数据库前关闭 block-change-track 功能。

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Oct 25 15:15:43 2016

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> select status,filename from v$block_change_tracking;

select status,filename from v$block_change_tracking

*

ERROR at line 1:

ORA-19755: could not open change tracking file

ORA-19750: change tracking file:

‘+DATA/cx/changetracking/ctf.348.875544631’

ORA-17503: ksfdopn:2 Failed to open file

+DATA/cx/changetracking/ctf.348.875544631

ORA-15012: ASM file ‘+DATA/cx/changetracking/ctf.348.875544631’ does not

exist

SQL> alter database disable block change tracking;

Database altered.

该命令执行后，在警告日志中可以发现删除 +DATA/cx/changetracking/ctf.348.875544631 文件的语句。

SQL> alter database open;

Database altered.

SQL>

报错 2

RMAN> restore database;

Starting restore at 2016-10-19 10:23:51

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=1933 instance=zx1 device type=DISK

allocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=2319 instance=zx1 device type=DISK

allocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=2705 instance=zx1 device type=DISK

allocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=3091 instance=zx1 device type=DISK

released channel: ORA_DISK_1

released channel: ORA_DISK_2

released channel: ORA_DISK_3

released channel: ORA_DISK_4

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

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

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

RMAN-03002: failure of restore command at 10/19/2016 10:23:52

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2

RMAN>

故障处理：

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ZX are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO ‘%F’; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default

CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+data/snapcf_zx.f’;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+DATA/snapcf_zx.f’;

RMAN> show default device type;

RMAN configuration parameters for database with db_unique_name ZX are:

CONFIGURE DEFAULT DEVICE TYPE TO ‘SBT_TAPE’;

RMAN>

RMAN> configure channel device type ‘SBT_TAPE’ CLEAR;

old RMAN configuration parameters are successfully deleted