-
Oracle full backup and restore
In SQL server if I do a full backup it will back up all the database, including the data files and some of the transaction logs into the backup file, and I can use it to restore the database to the time point that I did the backup.
I read oracle full backup only includes data files and control files/spfile, but not any transaction log in this case online redo log information into the backup. So can I use full backup of data file to restore a database to the point when I did the full backup, I guess it is also called last good backup?
Or maybe ask another way when oracle doing a full backup, does it do checkpoint and DBWR writes all the changes include those recorded in online redo logs to the data file? if so then backup file should be complete to restore to the point that i did the backup.
Thanks,
Tags for this Thread
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
|