Howto move datafiles to another partition and imaging
The thing I am trying to achieve is
1 to have Oracle (XE on Ubuntu) installed on a system partition and have all the datafiles on a RAID 1 partition.
2 then have the ability to create images and manage these two partitions independently
I generally followed this approach:
http://www.adp-gmbh.ch/ora/admin/move_datafiles.html
and it worked to meet the 1st step. I checked thoroughly and the instance is clearly working with the files on new partition
Having the *.ctl, *.log and *.dbf all on the same new partition I reasoned after shutdown they should all be in sync and stay that way on the image i created.
However when restoring these images and restoring image for the system partition I no longer have a database that opens.
I am only able to connect as sysdba and after bounce attempt I get this message:
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/media/OraData/dat/system.dbf'
ORA-01207: file is more recent than control file - old control file
What I understand from this message is that my ctl and dbf are out of sync
Two questions:
1. Is this the right approach for what I'm trying to do?
2. If so: what's missing?