[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2248
  • Last Modified:

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/****/controlfile/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.

0
sachin_dba
Asked:
sachin_dba
  • 10
  • 7
1 Solution
 
spyresponseCommented:
Don't restart the database with one one control file  try recover first than  down the database

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

0
 
tangchunfengCommented:
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:
 
0
 
tangchunfengCommented:


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_name>';
}

0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
tangchunfengCommented:
or in rman
> restore validate controlfile;
0
 
tangchunfengCommented:
dbverify
0
 
tangchunfengCommented:
dbverify CANNOT be used to verify redo log files or control files.
0
 
sachin_dbaAuthor Commented:
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_file_D00.ctl';
alter database backup controlfile to '/cs/oracle/tmp/control_file_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
0
 
tangchunfengCommented:
chech your alert log to find whether you have a good control file
0
 
sachin_dbaAuthor Commented:
Getting following errors:

Errors in file /cs/oracle/DHECR00/admin/diag/rdbms/dhecr00/DHECR00/trace/DHECR00_ora_2311.trc:
ORA-00202: control file: '/data/oracle/DHECR00/u01/DHECR00/controlfile/o1_mf_6sm641l8_.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/diag/rdbms/dhecr00/DHECR00/trace/DHECR00_ora_2616.trc:
ORA-00202: control file: '/data/oracle/DHECR00/u01/DHECR00/controlfile/o1_mf_6sm641l8_.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.
0
 
tangchunfengCommented:
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
0
 
tangchunfengCommented:
SQL> SELECT NAME FROM V$CONTROLFILE;
0
 
sachin_dbaAuthor Commented:
SQL> SELECT NAME FROM V$CONTROLFILE;

NAME
--------------------------------------------------------------------------------
/data/oracle/DHECR00/u01/DHECR00/controlfile/o1_mf_6sm641l8_.ctl
/data/oracle/DHECR00/f01/DHECR00/controlfile/o1_mf_6sm641o8_.ctl

0
 
sachin_dbaAuthor Commented:
SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /data/oracle/DHECR00/u01/DHECR
                                                 00/controlfile/o1_mf_6sm641l8_
                                                 .ctl, /data/oracle/DHECR00/f01
                                                 /DHECR00/controlfile/o1_mf_6sm
                                                 641o8_.ctl
control_management_pack_access       string      DIAGNOSTIC+TUNING
0
 
tangchunfengCommented:
if you have a backup of control file , restore it

or follow
Recovering From A Lost Control File [ID 1014504.6]
I. ONE OF THE MIRRORED COPIES OF THE CONTROL FILE IS LOST  
0
 
sachin_dbaAuthor Commented:

That worked for me, database started with mirrored control file.
0
 
sachin_dbaAuthor Commented:
Now taking full backup and then I will multiplex control file.
0
 
tangchunfengCommented:
good news
0
 
sachin_dbaAuthor Commented:
Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 10
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now