| OS Backup [message #576536] |
Wed, 06 February 2013 00:34  |
reym21
Messages: 241
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  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
John Watson
Messages: 8964
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
