| Recovering a Database [message #56518] |
Sat, 05 April 2003 13:15  |
Nivas
Messages: 2
Registered: April 2003
|
Junior Member |
|
|
Hello all I have a problem..
My db is 8.1.7
My DB is running in Archive log mode.
I lost My tools.dbf file
I have a week back backup file of it..
and i have 4 days Archivelogs but rest of them are missing.
Please tell me the command / suggestion for recovering the database..
Please help me as soon as possible.
Nivas
|
|
|
|
|
|
| Re: Recovering a Database [message #56524 is a reply to message #56518] |
Sun, 06 April 2003 09:27  |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
1. connect to the database,
2. startup mount
3. Get the Path and Size of the missing datafile
( you can get infn from >> bdump[[SID]]ALRT.LOG )
4. Create the datafile - alter database create datafile 'pathtools.dbf' as 'pathtools.dbf' size xxx reuse
(Make sure that the path and size are the same as step 3)
5. If the file is offline, then bring in online - alter database datafile 'pathtools.dbf' online;
6. Recover the database - recover database
7. recover will prompt for log file as shown below,
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}----provide the appr. files,
8. open the database--alter database open
It will help you a lot........
|
|
|
|
| Re: Recovering a Database [message #56574 is a reply to message #56518] |
Wed, 09 April 2003 04:21 |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
|
Better to back existed database first before do any recovering. For your information, you are only able to recover before missing archive and you will lose some data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
