database backup

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

database backup

Roshan
EBSR12.1.3
Oracle Database 11gR2
Oracle Linux 6.4
 
Hello,
 
everyday I have to do a cold backup of my database(shutdown all services). I wanted to delete a file in same directory as data folder(contains control and dbf files) but unfortunately I deleted part of the data folder: Some files in it were deleted(some a_txn files, some system files, 1 data file). Luckily I had a backup I took 2 days ago and managed to restore.
 
is it possible for me to retrieve all the data the day data folder I deleted? If I copy the datafiles in the deleted data folder and replace them in the restored data folder will it work?
Reply | Threaded
Open this post in threaded view
|

Re: database backup

ErmanArslansOracleBlog
Administrator
This post was updated on .
Hi Roshan,

you need to recover them.
When you replace the deleted datafiles with the backup files taken 2 days ago, you need to do a recovery.