[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-00571: ===========================================================
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
/bin/cp: overwrite `/u01/app/oracle11g/product/11.2.0/db_1/dbs/snapcf_test.f'? y
--第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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-732969/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-732969/