Nov 2, 2008

A Case of ORA-01110 error

1.Copy from AA1 to AB1
cloned by copying a restore from AA1
2.Create controlfile

STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "AB1" RESETLOGS ARCHIVELOG
...
alter database open resetlogs;

Then got the following message after the db-copy!
ORA-01190: controlfile or data file 75 is from before the last RESETLOGS
ORA-01110: data file 75: '/oracle/AB1/data2/data15/data15'

i make now a restore from the file 75: '/oracle/AB1/data2/data15/data15'
--file 75 from the last cold backup from the AA1 database
then i wolud to create new controlfile
and got the following message
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name AA1 in file header does not match given name of AB1
ORA-01110: data file 75: '/oracle/AB1/data2/data15/data15'

Can anybody advise me how i can solve tis problem?

Marcio Paiva's advise on this issue:

Flow these steps:
1. Take a physicall backup of the ur primary database
2. take a backup controlfile trace file from primary
3. restore only the datafiles and plan backup controlfile to secondary
4. recreate controlfile changing ur database name and file locations
5. issue recover automatic database until cancel using backup controlfile
6. alter database open resetlogs
7. add tempfiles

No comments:

Post a Comment