HeathRamos
IS-IT--Management
I am having trouble restoring data from a production database to a test database.
I restored thr datafiles from a cold backup, created the control files and tried to do the alter database resetlogs command but got an error (ora-0600). Oracle instructed me to change the init.ora file to allow resetlog corruption in order to get the database up. After doing this, they said I need to do a full database export, delete the database, created it and do a full database import.
Well...
While doing the full database export, I got an error:
. about to export SPACEMGR's tables via Conventional Path ...
. . exporting table QUEST_COM_PRODUCTS
EXP-00056: ORACLE error 376 encountered
ORA-00376: file 49 cannot be read at this time
ORA-01111: name for data file 49 is unknown - rename to correct file
ORA-01110: data file 49: '/usr/oracle/product/8.1.7/dbs/MISSING00049'
Looks like there is an error for every table in that schema (as well as one other schema).
Also...when I do a select name from v$datafile, I get:
/usr/oracle/product/8.1.7/dbs/MISSING00048
/usr/oracle/product/8.1.7/dbs/MISSING00049
Seems to be a problem with one particular tablespace and a couple of schemas.
Any idea what could cause this and how to fix it?
One thing that is different is that our production server had an application installed on it that the test server does not (Spotlight on Oracle as well as Spacemanager). I created the tablespace in question and installed the server side objects into it on the production server.
I restored thr datafiles from a cold backup, created the control files and tried to do the alter database resetlogs command but got an error (ora-0600). Oracle instructed me to change the init.ora file to allow resetlog corruption in order to get the database up. After doing this, they said I need to do a full database export, delete the database, created it and do a full database import.
Well...
While doing the full database export, I got an error:
. about to export SPACEMGR's tables via Conventional Path ...
. . exporting table QUEST_COM_PRODUCTS
EXP-00056: ORACLE error 376 encountered
ORA-00376: file 49 cannot be read at this time
ORA-01111: name for data file 49 is unknown - rename to correct file
ORA-01110: data file 49: '/usr/oracle/product/8.1.7/dbs/MISSING00049'
Looks like there is an error for every table in that schema (as well as one other schema).
Also...when I do a select name from v$datafile, I get:
/usr/oracle/product/8.1.7/dbs/MISSING00048
/usr/oracle/product/8.1.7/dbs/MISSING00049
Seems to be a problem with one particular tablespace and a couple of schemas.
Any idea what could cause this and how to fix it?
One thing that is different is that our production server had an application installed on it that the test server does not (Spotlight on Oracle as well as Spacemanager). I created the tablespace in question and installed the server side objects into it on the production server.