| coldbackup then recovery? [message #128279] |
Sat, 16 July 2005 22:53  |
dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore
|
Member |
|
|
i took coldbackup of ts18.dbf datafile and started database in noarchivelog mode. One of my user done some modification in his tables and he loggedout from his session. Then i shutdown database and deleted ts18.dbf and restored the coldbackup file and try to open database, its asking for recovery, but my database is in noarchivelog mode. so i cant recover. now how do i open database ( i dont have anyproblem if my users modifications lost also) but i want to use that datafile ts18.dbf
What is the solution?
Praveen
|
|
|
|
| Re: coldbackup then recovery? [message #128392 is a reply to message #128279] |
Mon, 18 July 2005 06:02  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Hi
Since database is in noarchivelog mode, only way now to open it is restore last cold backup, that you might have taken. This cold backup has to be of complete database, & not of 1 or few datafiles only.
Also, as 1 shot in dark... do type recover database at sqlprompt after mounting it. If the logfiles had not been overwritten, since your last backup, it might work.
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
