sachin_dba
asked on
Control File error
We are getting following error while backup on RMAN.
RMAN> list backup summary;
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ========================== ========== ========== ========== ===
RMAN-03002: failure of list command at 09/29/2011 06:32:18
ORA-00204: error in reading (block 685, # blocks 1) of control fileORA-00202: control file: '/data/oracle/****/u01/*** */controlf ile/o1_mf_ 6sm641l8_. ctl'
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
Additional information: 4
Additional information: 685
We have cloned other database using this with "active database" option and after the backups are failing.
Database has multiplexed control files and at the moment DB is running fine. I am wondering if I restart the database with only one control file it may corrupt.
Please suggest, I have already taken backup of control file to trace.
RMAN> list backup summary;
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of list command at 09/29/2011 06:32:18
ORA-00204: error in reading (block 685, # blocks 1) of control fileORA-00202: control file: '/data/oracle/****/u01/***
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
Additional information: 4
Additional information: 685
We have cloned other database using this with "active database" option and after the backups are failing.
Database has multiplexed control files and at the moment DB is running fine. I am wondering if I restart the database with only one control file it may corrupt.
Please suggest, I have already taken backup of control file to trace.
Recovering From A Lost Control File [ID 1014504.6]
I. ONE OF THE MIRRORED COPIES OF THE CONTROL FILE IS LOST
-------------------------- ---------- ---------- ---------- -
In this case, one of the other copies of the control file should
be used to bring the database up.
1. If the instance is still up, do a shutdown abort.
2. Use a good copy of the control file to copy onto the location of the lost
one. If you are having hardware problems with the current location of the
lost control file, such as disk or controller failures, choose another
location for copying the file and then edit the "init.ora" file for this
instance (or "config.ora" file in an ifile configuration) accordingly. Edit
the CONTROL_FILES parameter to reflect the current location of the control
files after you have done the copy.
3. Start up the database.
II. ALL CURRENT COPIES OF THE CONTROL FILE ARE LOST
-------------------------- ---------- ---------- -----
An important factor in this scenario is the existence of a backup trace
of the control file generated with the ALTER DATABASE BACKUP CONTROLFILE
TO TRACE command:
I. ONE OF THE MIRRORED COPIES OF THE CONTROL FILE IS LOST
--------------------------
In this case, one of the other copies of the control file should
be used to bring the database up.
1. If the instance is still up, do a shutdown abort.
2. Use a good copy of the control file to copy onto the location of the lost
one. If you are having hardware problems with the current location of the
lost control file, such as disk or controller failures, choose another
location for copying the file and then edit the "init.ora" file for this
instance (or "config.ora" file in an ifile configuration) accordingly. Edit
the CONTROL_FILES parameter to reflect the current location of the control
files after you have done the copy.
3. Start up the database.
II. ALL CURRENT COPIES OF THE CONTROL FILE ARE LOST
--------------------------
An important factor in this scenario is the existence of a backup trace
of the control file generated with the ALTER DATABASE BACKUP CONTROLFILE
TO TRACE command:
You need Take a backup of current control file using RMAN
Connect to RMAN:
rman "target / nocatalog"
RUN
{
ALLOCATE CHANNEL chan_name TYPE DISK;
BACKUP DATABASE FORMAT '<db_backup_directory>%U' TAG before_upgrade;
BACKUP CURRENT CONTROLFILE FORMAT '<controlfile_location_and
}
or in rman
> restore validate controlfile;
> restore validate controlfile;
dbverify
dbverify CANNOT be used to verify redo log files or control files.
ASKER
I am able to create tablespace but copying binary failed:
SQL> create tablespace test;
Tablespace created.
SQL> drop tablespace test;
Tablespace dropped.
SQL> alter database backup controlfile to trace;
Database altered.
-------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
SQL> alter database backup controlfile to '/cs/oracle/tmp/control_fi le_D00.ctl ';
alter database backup controlfile to '/cs/oracle/tmp/control_fi le_D00.ctl '
*
ERROR at line 1:
ORA-01587: error during control file backup file copy
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
Additional information: 4
Additional information: 643
Additional information: 688128
SQL> create tablespace test;
Tablespace created.
SQL> drop tablespace test;
Tablespace dropped.
SQL> alter database backup controlfile to trace;
Database altered.
--------------------------
SQL> alter database backup controlfile to '/cs/oracle/tmp/control_fi
alter database backup controlfile to '/cs/oracle/tmp/control_fi
*
ERROR at line 1:
ORA-01587: error during control file backup file copy
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
Additional information: 4
Additional information: 643
Additional information: 688128
chech your alert log to find whether you have a good control file
ASKER
Getting following errors:
Errors in file /cs/oracle/DHECR00/admin/d iag/rdbms/ dhecr00/DH ECR00/trac e/DHECR00_ ora_2311.t rc:
ORA-00202: control file: '/data/oracle/DHECR00/u01/ DHECR00/co ntrolfile/ o1_mf_6sm6 41l8_.ctl'
ORA-27072: File I/O error
Additional information: 4
Additional information: 685
Wed Sep 28 11:41:32 2011
Errors in file /cs/oracle/DHECR00/admin/d iag/rdbms/ dhecr00/DH ECR00/trac e/DHECR00_ ora_2616.t rc:
ORA-00202: control file: '/data/oracle/DHECR00/u01/ DHECR00/co ntrolfile/ o1_mf_6sm6 41l8_.ctl'
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
But I have a multiplexed file on other location. DB is using OMF.
Errors in file /cs/oracle/DHECR00/admin/d
ORA-00202: control file: '/data/oracle/DHECR00/u01/
ORA-27072: File I/O error
Additional information: 4
Additional information: 685
Wed Sep 28 11:41:32 2011
Errors in file /cs/oracle/DHECR00/admin/d
ORA-00202: control file: '/data/oracle/DHECR00/u01/
ORA-27072: File I/O error
SVR4 Error: 81: File descriptor in bad state
But I have a multiplexed file on other location. DB is using OMF.
Recovering From A Lost Control File [ID 1014504.6]
I. ONE OF THE MIRRORED COPIES OF THE CONTROL FILE IS LOST will solve your problem
I. ONE OF THE MIRRORED COPIES OF THE CONTROL FILE IS LOST will solve your problem
SQL> SELECT NAME FROM V$CONTROLFILE;
ASKER
SQL> SELECT NAME FROM V$CONTROLFILE;
NAME
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
/data/oracle/DHECR00/u01/D HECR00/con trolfile/o 1_mf_6sm64 1l8_.ctl
/data/oracle/DHECR00/f01/D HECR00/con trolfile/o 1_mf_6sm64 1o8_.ctl
NAME
--------------------------
/data/oracle/DHECR00/u01/D
/data/oracle/DHECR00/f01/D
ASKER
SQL> show parameter control
NAME TYPE VALUE
-------------------------- ---------- ----------- -------------------------- ----
control_file_record_keep_t ime integer 7
control_files string /data/oracle/DHECR00/u01/D HECR
00/controlfile/o1_mf_6sm64 1l8_
.ctl, /data/oracle/DHECR00/f01
/DHECR00/controlfile/o1_mf _6sm
641o8_.ctl
control_management_pack_ac cess string DIAGNOSTIC+TUNING
NAME TYPE VALUE
--------------------------
control_file_record_keep_t
control_files string /data/oracle/DHECR00/u01/D
00/controlfile/o1_mf_6sm64
.ctl, /data/oracle/DHECR00/f01
/DHECR00/controlfile/o1_mf
641o8_.ctl
control_management_pack_ac
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked for me, database started with mirrored control file.
ASKER
Now taking full backup and then I will multiplex control file.
good news
ASKER
Thanks
alter database backup control file to trace and recreate them if you want
try time based recovery with note ur current SCN no or usibf block recover..