| Database not startup [message #52481] |
Thu, 25 July 2002 04:26  |
msh
Messages: 11
Registered: July 2002
|
Junior Member |
|
|
Hello all,
My db is running in archivelog mode. I am trying to recover from user error. i did following steps:-
1>shutdown DB
2.>copy from old offline datafiles to the current loc.
3>mount DB
4>recover database until time '...'
But here its giving error saying that the control file or the system fiel is from the old backup.
Please suggest if i can start my database.
Rgds,
./mk
|
|
|
|
| Re: Database not startup [message #52486 is a reply to message #52481] |
Thu, 25 July 2002 07:41  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Here is what needs to be done. (At least worked for me).
1. Shutdown DB. Take cold backup (optional).
2. Copy old offline data files in current location, archive files in the archive folder. DO NOT COPY THE CONTROL FILES AND THE REDO LOG FILES.
3. Startup mount
4. recover database until time '2002-07-25:10:08:00' (Note time stamp needs to be exactly as shown to desired point-in-time).
5. Follow the prompts. You can say auto find or manual entry of the archive files.
Good luck.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
