[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.