| Cannot import from full backup - 8i [message #174044] |
Thu, 25 May 2006 13:25  |
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
|
Junior Member |
|
|
We are attempting to migrate a fairly sizable (50GB) database from 8i to 9i. I have made a full dump using 'exp' and have attempted to import this dump into 9i, but received a huge list of errors. I have now tried to reopen the database in 8i to see if I can determine what's going wrong, and I get the following message when I issue the command "alter database open":
ERROR at line 1:
ORA-01113: file 10 needs media recovery
ORA-01110: data file 10: '/store2/u02/GENOMA_DATA001.dbf'
If I then enter "alter database recover datafile 10", I get:
ERROR at line 1:
ORA-00279: change 7270788263640 generated at 05/18/2006 01:38:25 needed for
thread 1
ORA-00289: suggestion :
/store2/u01/app/oracle/product/8.1.7/dbs/arch1_2503432.dbf
ORA-00280: change 7270788263640 for thread 1 is in sequence #2503432
OK, so then if I change gears and try to do an import from backup, I get the following:
IMP-00058: ORACLE error 1033 encountered
ORA-01033: ORACLE initialization or shutdown in progress
Any idea why I am blocked from importing the backup? Seems like kind of a catch-22 - I can't import the backup because the database isn't open, but I can't open the database until I've imported from the backup. 
Any thoughts?
Thanks,
Simeon
[Updated on: Thu, 25 May 2006 13:25] Report message to a moderator |
|
|
|
| Re: Cannot import from full backup - 8i [message #174069 is a reply to message #174044] |
Thu, 25 May 2006 15:01  |
SLKRR
Messages: 11
Registered: May 2006
Location: Recife, Brasil
|
Junior Member |
|
|
More info:
Ran "recover database" and get this error:
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01110: data file 14: '/store2/u02/GENOMA_INDEX001.dbf'
However, the file GENOMA_INDEX001.dbf is available at the path shown. After running the export, and before attempting the migration, I also saved off copies of all the datafiles in case there was some problem. Now I can't get the datafiles to re-open, and I can't restore from the backup. There must be something obvious that I am missing here...
|
|
|
|
| Re: Cannot import from full backup - 8i [message #174097 is a reply to message #174044] |
Thu, 25 May 2006 20:21 |
itman73
Messages: 6
Registered: May 2006
Location: Dallas, Texas, USA
|
Junior Member |
|
|
Two different issues.
First, you exported full=y an 8i database and attempted to import into an 9i database, correct?
1) Are both 8i and 9i databases on same server?
2) Did you create a new 9i database (new $ORACLE_SID) from scratch taking advantage of new features?
3) Did you pre-create the tablespaces using new mountpoints/directories also taking advantage of new features?
If your 9i database is on a different server and the mountpoints/directories are different than what's in the export file, you will get errors during the import when it tries to create the tablespaces and associated objects (tables/indexes). However if you pre-create the tablespaces in the new 9i database using the correct mounpoints/directories and use ignore=y on the imp command line, errors related to existing objects will be ignored, including tablespaces, and all the other objects will be created.
If your 9i database is on the same server, you still need to pre-create your tablespaces using the new 9i $ORACLE_SID as part of the OFA compliant file name, as in /u02/oradata/$ORACLE_SID/filename.dbf, or whatever is considered standard practice at your site.
Second, the recovery problem with the 8i database should be considered separate from the export; you need to get the 8i database recovered and then should not have the need to do the import into it. Imports are performed into open databases, not databases needing recovery.
ORA-00283: recovery session canceled due to errors
ORA-01157: cannot identify/lock data file 14 - see DBWR trace file
ORA-01110: data file 14: '/store2/u02/GENOMA_INDEX001.dbf'
If the file is really present, do an fuser filename to see the PIDs of processes using it. Then do a ps -ef | grep PID to see what the process is. This might give you a clue.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
