FW: Re[1]: ORA-01159 during controlfile recreate ?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Jul 2004 08:24:32 -0500
Prem
I don't see any ready answer from the information you have provided, so
the best I can do is a few observations:
- You say that you overwrite the existing files. Yet you are receiving an
error that may be caused by a file that was not overwritten. Consider
removing the existing files to ensure this isn't the cause of your problem.
- I notice that you are actually receiving two error messages. It is
possible these are related, possibly having the same cause. A wrong file
name might be the root of both errors, for example.
- Inconsistencies like this are caused by a difference between the CREATE
CONTROLFILE script and the data dictionary you are recovering. I have been
performing these recoveries for about 8 years now. In my experience, the key
is very carefully comparing the original dictionary to the recovered files
to the CREATE CONTROLFILE script. Very carefully, especially when recovering
over 400 files. It is better to practice with a smaller database to gain
confidence in the method. Essentially this is a test of your clerical
skills, like making lists of the files from each source, cross-comparing
them, making a check mark on each list.
- In your second message you mention the step following the CREATE
CONTROLFILE statement. Did you previously open this database? Once you open
the database, Oracle changes the SCNs of all the data files. If you missed a
file, you can't simply return to the CREATE CONTROLFILE statement. You must
pull all the files from the backup tape and begin again.
- I agree with your manager. The CREATE CONTROLFILE method is an important
tool for the DBA to master. I feel you are really close to resolving your
issues and once you've mastered this technique you will find it is very
valuable in the future.
Sorry I can't be more definite on the source of your problem. Hopefully
someone whose eyes are more open than mine this morning will spot the exact
problem.
Dennis Williams
DBA
Lifetouch, Inc.
"We all want progress, but if you're on the wrong road, progress means
doing an about-turn and walking back to the right road; in that case,
the man who turns back soonest is the most progressive."
-- C.S. Lewis
-----Original Message-----
From: Prem Khanna J [mailto:premj@xxxxxxxxxxxxxx]
Sent: Wednesday, July 21, 2004 8:17 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Cc: DENNIS WILLIAMS; Mark W.Farnham; Mercadante Thomas F
Subject: Re[1]: ORA-01159 during controlfile recreate ?
Hi Tom ,Dennis, Mark and all,
thanx for ur input.this is my "create controlfile" script.
i did a "alter database backup controlfile ..." on DEV01
instance,edited it to look like this.
--------------------------------------------------------------
CREATE CONTROLFILE SET DATABASE "DEV03" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 5
MAXDATAFILES 512
MAXINSTANCES 1
MAXLOGHISTORY 7260
LOGFILE
GROUP 1 (
'/home01/db03/dev03data/log01a.dbf',
'/home01/db03/dev03data/log01b.dbf'
) SIZE 10M,
GROUP 2 (
'/home01/db03/dev03data/log02a.dbf',
'/home01/db03/dev03data/log02b.dbf'
) SIZE 10M
DATAFILE
'/home01/db03/dev03data/system01.dbf' REUSE,
...........
'/home01/db03/dev03data/scs02d01.dbf' REUSE,
--'/home01/db03/dev03data/scs02x01.bdf' REUSE,
'/home01/db03/dev03data/distutor00d01.dbf' REUSE,
'/home01/db03/dev03data/distutor00x01.dbf' REUSE
CHARACTER SET JA16SJIS;
--------------------------------------------------------------
actually DEV03 already exits and is a test instance.
we overwrite the DBF files of DEV03 with DEV01 ->
change the DB name/file path in new "create controlfile" script
-> startup nomount & re-create control file .
we do all this only to copy the data from DEV01 to DEV03.
alter.log of DEV03 says that
----------------------------------------------------
Tablespace 'SCS02X' #392 found in data dictionary,
but not in the controlfile. Adding to controlfile.
File #400 found in data dictionary but not in controlfile.
Creating OFFLINE file 'MISSING00400' in the controlfile.
----------------------------------------------------
file# 400 is in all way similar with other 399 files.
WHEN IS SUCH A IN-CONSISTNENCY BETWEEN DATA DICT AND
CONTROL FILE LIKELY TO OCCUR ?
my manager feels EXP/IMP will be cumbersome ?
any other possible suggestions for this ?
this is oracle apps 11.5.9/oracle 9.2.0.4/AIX5.2 env.
Thanks and Regards,
Prem.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » FW: Re[1]: ORA-01159 during controlfile recreate ?
