-
How to recover the database? The server got crashed. But we are able to recover the data files, control files and the archive files. Now we have to recover the database with all the transactions happened till the time the server got crashed. Suggest please. It's urgent!!!
-
Is your database in archivelog mode. If yes, then apply these commands.
startup nomount
recover database database using backup controlfile until cancel
alter database open
Thanks
Kishore Kumar
-
Hi,
Thanks.
our database has crashed. We have the logical backup of our database as on yesterday. We don't have the back up of today's transactions. We have the Archive file. We want to retrive the today's transaction datas from the archive file.
How to retrive the data from archive file???
Arun
-
Hi Kishore,
Our server has got crashed. Now we have installed the NT server and all that. We have physical copy of the datafiles, control files and archive files. The database was in archive mode only. We have yesterday's logical backup. Withthat we have started recovering the database in another system. The process is going on. But this recovery won't give the transactions what ever we have entered today. Is it possible to recover it. Please explain in detail.
Thanks and regards,
Arun.
Originally posted by Kishore
Is your database in archivelog mode. If yes, then apply these commands.
startup nomount
recover database database using backup controlfile until cancel
alter database open
-
What was the crash error you see in the alert_SID.log? Do you have the physical backup of the datafiles and archive files?
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Originally posted by sambavan
What was the crash error you see in the alert_SID.log? Do you have the physical backup of the datafiles and archive files?
Sam
We don't have the physical backup of the datafiles and archive files. But we have the physical copy of those files which we have copied from the server now.
Arun.
-
When you say physical copy from the server, were they from the server that crashed? Before you proceed, what are the error messages on the alert.log
Sam
Thanx
Sam
Life is a journey, not a destination!
-
We are not checked that. But we have the physical copy of the data files, control files and archive files.
Now we want to move the database to new server.
we have created the database, user and tablespace.
How to recover the database from old datafile and control files????
Arun
Originally posted by sambavan
When you say physical copy from the server, were they from the server that crashed? Before you proceed, what are the error messages on the alert.log
Sam
-
When you said, physical files copy. Is it a OS copy ? that means, you took backup on OS level and now want to move to new place. In that case, you cannot rollforward to the position of crash. You may be able to recover till the backup position.
Please clarify on what you did.
Thanks
Kishore Kumar
-
We have the logical backup as on yesterday 22.00.
and we have all the physical (OS) data files, control files and archive files.
we imported the data from export backup. So as of now we have the data upto yesterday 22.00.
How to recover the data entered after yesterday 22.00 to today 16.00 (System Crash time).
We have the archive files from yesterday 18.30.
Arun.
Originally posted by Kishore
When you said, physical files copy. Is it a OS copy ? that means, you took backup on OS level and now want to move to new place. In that case, you cannot rollforward to the position of crash. You may be able to recover till the backup position.
Please clarify on what you did.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|