Oracle 9i Missing Conrtol files

2013-07-15  Source: Original Site  Category:Oracle  Views:0 

Advertisement

Greetings,

The Oracle 9i Standby database could not be mounted.
Here is what I found in the alert_CEMSDB.log:

alter database mount standby database
Fri Jan 19 05:13:11 2007
ORA-00202: controlfile: '/opt/cems/db/oracle/u02/oradata/CEMSDB/control01.ctl'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Fri Jan 19 05:13:11 2007
ORA-205 signalled during: alter database mount standby database...
Fri Jan 19 05:13:11 2007
alter database recover managed standby database disconnect from session
ORA-1507 signalled during: alter database recover managed standby databas...
destination database instance is 'started' not 'mounted'
Fri Jan 19 05:13:12 2007
destination database instance is 'started' not 'mounted'
RFS: Possible network disconnect with primary database
Fri Jan 19 05:14:27 2007
I could not find any conrtol files nor redolog files on the standby database.
Is there any known case(s) where Oracle deletes those files (e.g. due to disk space
or losing connection with the Primary db).

Related articles
  • Oracle 9i Missing Conrtol files 2013-07-15

    Greetings, The Oracle 9i Standby database could not be mounted. Here is what I found in the alert_CEMSDB.log: alter database mount standby database Fri Jan 19 05:13:11 2007 ORA-00202: controlfile: '/opt/cems/db/oracle/u02/oradata/CEMSDB/control01.ctl

  • Oracle (Urgent) Missing Password File ! 2012-01-10

    My password file is lost and I have a offline backup of the database but not the password file. I have restored the database but when I start it up it says. ORA-01991: invalid password file 'D:\Oracle\Ora81 \DATABASE\PWDsid.ORA' if any body knows how

  • Oracle uncatalog missing archive files 2013-09-13

    to all of you. Backing up archive log will crash, because RMAN wants to write .../1_217.dbf from disk to tape, but this file isnĀ“t on disk. The number of the first archive on disk is .../1_218. I tried to uncatalog the missing archive logs by "change

  • Oracle Is missing oratab file causing this issue? 2014-03-03

    OS Version : AIX 5.3 DB Version : 10g Release 2 I've just finished installing Oracle 10g R2 software(without a starter database). I want to create a database using a CREATE DATABASE script.But when i tried to log in as SYS i got the following error S

  • Oracle Recovery missing control file 2012-10-29

    I have three month backup of control file.During three month ,I added data file in Tablespace.Suddenly my control has lost.My database in archive mode.Can I recover full data?How?. Please help me.

  • open oracle with missing .dbf file 2013-04-11

    I've searched and found a possible solution: mount database... alter database datafile 'route_to_dbf\file.DBF' offline drop; It informs 'Completed: alter database datafile' but when I open the database it still complains of the "lacking" file and ref

  • Oracle RMAN - Missing log files for which there is no copy available 2013-12-07

    Solution will be an incomplete recovery .Right? select first_change# from v$log where group#=3 Suppose 370255 is the SCN We can recover the database till SCN=370254...Right? i.e first we restore till 370254 SCN then recover till that 370254 SCN...rig

  • Oracle Database recovery,password file missing 2013-08-08

    Hi the operating system crashed .therefore i again installed oracle . i had cold backup of my database.but the but the pwd file was missing.please note that database was not in archived mode.and the dumps were too old. i tried to restored my database

  • Oracle Alert Entry for Missing Data File 2015-01-08

    I am trying a simple recovery scenario: deleting a data file of a normal tablespace when the database is running, and the data file has been backed up. Before shutdown, checkpoint completes normally (I guess Oracle still keeps the file inode handle).

  • Oracle DB missing file, help 2012-11-09

    It appears that our database is missing a file and are not sure how it happened as we cannot recall the events that took place prior to the error. The SEVERE log entries of the dbverify are pasted below. The database is fairly large (586GB on disk) a

  • Oracle false positive critical alert from OEM: number of missing media files is 7 2014-06-26

    We were a bit stunned here as we got a page from OEM that the number of missing media files is 7! We ran the query only to find that there are none missing. One of the SR. DBA's said he thought he remembered seeing this months ago and it cleared itse

  • How can i extract data from oracle table to flat file or excel spread shee 2012-01-10

    DB Version is 10.1.0.3.0 How can i extract data from oracle table to flat file or excel spread sheet by using sub programs?

  • missing .pch file 2012-01-12

    hello, I downloaded a file from codeguru website. I found that every file I am trying to compile complains about missing .pch file. I am using VC++ 6 now. what is the problem? did I miss any files? thankx. From Alan.

  • ORACLE data block corrupted (file # 34, block # 37594) 2012-01-22

    Guys, I am getting ORACLE data block corrupted (file # 34, block # 37594) in my DB,during insert operations.The segment belongs to this file and block is LOB segment and its size is ~74 GB.I am planning to move this segment to different tablespace. I

  • Ubuntu Missing header files 2012-02-27

    I'm very new to Ubuntu (using Edgy) and I'm having trouble figuring out, what I hope is a very basic problem. I'm trying to compile a program I wrote, and it appears I'm missing some header files I thought were fairly standard, like /usr/include/asm/

  • Ubuntu i8krellm missing proc file 2012-03-02

    I am trying to get fan control over my inspiron 9400 with ubuntu feisty. I have installed gkrellm and the dell i8k plugin. unfortunately I am getting this error saying i8krellm missing proc file. what does this mean? I have tried http://ubuntuforums.

  • ORA-01578: ORACLE data block corrupted (file # 9, block # 247998) 2012-03-05

    In my alert database i found the error bellow but it still continue working, this error was already coming from last year. Errors in file /home/oracle/admin/tchad/bdump/tchad_smon_5665.trc: ORA-01578: ORACLE data block corrupted (file # 9, block # 24

  • Ubuntu missing header files or problem in 'make' 2012-03-31

    I am trying to install a package called netmate-0.0.4 on ubuntu 8.10. While doing a 'make' it gave me these errors [I am doing installation using sudo -i] In file included from testexp.cc:31: ../../src/include/stdincpp.h:46:22: error: multimap.h: No

  • how to copy data from oracle table to .csv file 2012-04-03

    i m using oracle 10g r2 on windows. i want to import multiple records from oracle table to csv file. ie. suppose i have 500 records. when i will execute my query its shows me 70 records. i m able to import single row but now the mulfiple row. please

  • ORA-01578: ORACLE data block corrupted (file # 1, block # 1784) 2012-04-08

    I got the datablock error when connecting to my database, no it's not accessible even localy the error i got is: ERROR: ORA-01578: ORACLE data block corrupted (file # 1, block # 1784) ORA-01110: data file 1: '+DATA/cdrmg/datafile/system.256.692714105