Re: ORA-01130
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- Date: Thu, 7 Dec 2006 10:05:54 +0100
Yes,
as soon as you raise the version in the compatible parameter, Oracle will
make changes to the datafile headers (among other things) - which makes it
impossible to read them with compatible set to a lower version. You also
can't reverse a compatible parameter change without doing a restore.
Stefan
On 12/7/06, genegurevich@xxxxxxxxxxxxxxxxxxxxx <
genegurevich@xxxxxxxxxxxxxxxxxxxxx> wrote:
Hi all:
Here is my situation. I have a 10.2.0.1 database (DB01) where compatible
parameter is set to 10.2.0. I have a cold
backup created last night and I would like to restore it on another server
where I have 10.2.0.1 database (DB02) ,
but with the compatible parameter set to 10.0.0. I am getting the error:
ORA-01130: database file version 10.2.0.0.0 incompatible with ORACLE
version
10.0.0.0.0
ORA-01110: data file 1: '/opt/oracle/data/pcfr01/data10/cfr_system01.dbf'
Does that mean that I have to change the compatible parameter on my DB02
database to match the one on
DB01 (e.g - 10.2.0) in order to do the restore or is there a way to
accomplish the restore the way I want?
thank you
Gene Gurevich
--
//www.freelists.org/webpage/oracle-l
Other related posts:
