| Oracle Recovery Problem [message #51801] |
Thu, 13 June 2002 18:32  |
Jason Currey
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
Hello all! I am having a problem trying to bring up a database that I have copied.
I made the copy by putting each tablespace into backup mode, and then copying the datafiles to the new host. (and then taking the tablespaces out of backup mode)
I generated a new controlfile for my new DB and have recovered the database until after the last datafile that I copied. Now, when I try to open the database with "alter database open resetlogs" (resetlogs is necessary as I am using a backup controlfile) I am getting a ORA 01194 (File needs more recovery to be consistant).
When I do a "select file#,status,checkpoint_change# from v$datafile;" I see that all datafiles have the same change number, but are all in recover state.
Can anybody help?
Thanks in advance,
Jason Currey
|
|
|
|
| Re: Oracle Recovery Problem [message #51807 is a reply to message #51801] |
Fri, 14 June 2002 06:21  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
|
what about your archive logs? did you move them across too and have them applied? you are in archive log mode in the source database, so it's looking to apply all your archives and current redo logs that were in the system up to the point you put the datafiles in backup mode.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
