Login  Register

database backup

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

database backup

Roshan
1294 posts
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
| More
Print post
Permalink

Re: database backup

ErmanArslansOracleBlog
Administrator
5727 posts
This post was updated on Feb 18, 2016; 7:08am.
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.