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