天天看點

[20120615]rman備份問題.txt

[20120615]rman備份問題.txt

backup spfile;

Starting Control File and SPFILE Autobackup at 2012-06-15 09:37:09

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

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

RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 06/15/2012 09:37:24

ORA-01587: error during control file backup file copy

ORA-27072: File I/O error

Linux-x86_64 Error: 25: Inappropriate ioctl for device

Additional information: 4

Additional information: 259

Additional information: 720896

RMAN> show all ;

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

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

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

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

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK 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 '/u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f'; # default

根據提示,試着修改CONFIGURE CONTROLFILE AUTOBACKUP OFF;

問題依舊.看來與這個無關.

删除SNAPSHOT CONTROLFILE檔案/u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f.問題依舊.

檢查并沒有産生這個檔案.

估計控制檔案有問題.

檢查alert*.log,存在如下提示:

ORA-00210: cannot open the specified control file

ORA-00202: control file: '/u01/app/oracle11g/oradata/test/control01.ctl'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

--關閉資料庫.

$ cp /u01/app/oracle11g/oradata/test/control01.ctl /u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f

/bin/cp: overwrite `/u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f'? y

/bin/cp: reading `/u01/app/oracle11g/oradata/test/control01.ctl': Input/output error

--再次證明控制檔案有問題.存在邏輯損壞.

$ cp /u01/app/oracle11g/flash_recovery_area/test/control02.ctl /u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f

--第2個控制檔案是OK的.

--使用第2個控制檔案覆寫第1個.

$ cp /u01/app/oracle11g/flash_recovery_area/test/control02.ctl /u01/app/oracle11g/oradata/test/control01.ctl

/bin/cp: overwrite `/u01/app/oracle11g/oradata/test/control01.ctl'? y

啟動資料庫,在做備份一起OK.