-
Hi
I am getting these error when i apply
alter database convert;
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: 'DISK$DISK3:[ORA.LIVEFR]LIVEFR_DATAIMS1.DBF'
ORA-01200: actual file size of 231424 is smaller than correct size of 1280000 blocks
I don't know what has happened to the file and why its size is not same.
help me out as i am in the middle of migration and things are not working.
Cheers
UKDBA
-
Note from Metalink...
Doc ID: Note:107454.1
Subject: ORA-01200 on Alter Database Convert during Migration
Type: PROBLEM
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 03-MAY-2000
Last Revision Date: 10-NOV-2000
Problem Description
-------------------
During a migration from 7.3.4.x to 8.1.x you receive the following errors when
issuing 'alter database convert':
ORA-01122 "database file 1 failed verification check"
ORA-01110 data file 1: '/'
ORA-01200: actual file size of 6399 is smaller than correct size of 6400
blocks
Note that the datafile number may be different and that block sizes will vary
based on your datafiles.
You have confirmed all the steps in your 8i Migration manual and have confirmed
that the mig utility ran without errors (check the mig.log). The database may
come up successfully under 7.3.4 again once you restore the controlfiles and
the environment for 7.3.4, but it will not convert to Oracle 8i.
Solution Description
--------------------
[BUG:1290322] gives a detailed problem description.
Resize the problem datafile under Oracle7.
SQL> alter DATABASE
datafile '/u02/usupport/data/system01.dbf' RESIZE 200M;
Notes:
Only K and M are acceptable sizes under Oracle7, you cannot use G until
Oracle8.
During a migration from 7 to 8 it is a good idea to increase the size of your
system datafile to at least 200MB, depending on your database. The migration
will generally need at least twice the space of your Oracle7 system filesize.
Explanation
-----------
File checking and verification is stricter in Oracle8 than in Oracle7 and the
database may come up under 7 with a problem which will not allow it to open
under Oracle8. In this case, the system datafile had 'lost' one block.
To confirm that you are running into this problem, compare the following:
o/s file size:
ls -l|grep -i system
-rw-r----- 1 osupport osupport 419438592 Nov 3 11:25 system01.dbf
Oracle datafile size:
SVRMGR> select name, bytes from v$datafile where name like '%system%';
NAME BYTES
------------------------------------------- ----------
/var/opt/oracle/data/db2/V816/system01.dbf BYTES 419430400
DB_BLOCK_SIZE:
SVRMGR> show parameter db_block_size
NAME TYPE VALUE
----------------------------------- ------- -------
db_block_size integer 8192
When you create an Oracle Datafile, i.e. 400 MB = 419430400 bytes, Oracle
creates a o/s file of the size 400 MB + 1 db_block = 419438592 bytes.
The extra block is used for the osd header, o/s management and o/s header
file. This is true both for 7.3.x as well as 8.x.
So the Oracle database reports the datafile to be one Oracle block size
smaller for the size than the o/s long listing does. This is the CORRECT
sizing of a datafile (in both 7 and 8). If these sizes match, then you
have a problem.
Resizing the datafile will allow Oracle to recheck the datafile and
after the resize you should have the extra block needed.
Please confirm this.
Doug
-
Here is an excerpt from Oracle documentation:
ORA-01122 database file string failed verification check
Cause: The information in this file is inconsistent with information from the control file. See accompanying message for reason.
Action: Make certain that the database files and control files are the correct files for this database.
-
I was doing the migration and now the database is down . is it possible that i can use the old control file and start the database again.
UKDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|