Home » RDBMS Server » Backup & Recovery » OS Backup (Oracle 11g R2/ 10g R2 - Solaris 10)
OS Backup [message #576536] Wed, 06 February 2013 00:34 Go to next message
reym21
Messages: 178
Registered: February 2010
Location: Philippines
Senior Member

Gurus,

Good day again.

Just for your confirmation.

We perform an OS backup (datafiles, control files, redo log files)
yesterday while the database is online.
A contractor called us today that he did something wrong to the
database and wants to restore the database in yesterday's state.

Can we restore directly overwriting the current database files
(datafiles, control files, redo log files) with the said OS backup
we did yesterday without shutting down the database?

Would it still be consistent?

Thanks for the info.

Regards,

Re: OS Backup [message #576539 is a reply to message #576536] Wed, 06 February 2013 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58953
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you put the database in backup mode, yes.
If not, your backup may is most likely invalid unless you are lucky.

Edit: I assumed you were in ARCHIVELOG mode, if not the backup is anyway unusable.

Regards
Michel

[Updated on: Wed, 06 February 2013 01:00]

Report message to a moderator

Re: OS Backup [message #576542 is a reply to message #576536] Wed, 06 February 2013 01:40 Go to previous message
John Watson
Messages: 4518
Registered: January 2010
Location: Global Village
Senior Member
Quote:
Can we restore directly overwriting the current database files
(datafiles, control files, redo log files) with the said OS backup
we did yesterday without shutting down the database?
Furthermore, you cannot do this without shutting down the database.
Previous Topic: recover database until cancel
Next Topic: how to take backup and recover of oracle database
Goto Forum:
  


Current Time: Mon Sep 01 10:25:13 CDT 2014

Total time taken to generate the page: 0.09474 seconds