| Backup and recovery scenario [message #260498] |
Mon, 20 August 2007 02:57  |
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
|
Member |
|
|
Hi,
If one has a cold backup of the database(the whole oracle directory is backed up on the last day of the week(sunday)) and during the week(monday) a hot backup of the database is taken,backing up datafiles,control files,password file,archive logs and init file(we are not using rman,we just put the datafile in backup mode).
If the server crashes on tuesday and we restore the cold backup,
1. Does it mean the database will be in the state it was on sunday(correct me if i am wrong)
2.How do i recover the databse to the last available hot backup taken on monday.
Thank You
|
|
|
|
|
|
| Re: Backup and recovery scenario [message #260513 is a reply to message #260507] |
Mon, 20 August 2007 03:36  |
sellafrica
Messages: 68
Registered: July 2005
Location: Braynston
|
Member |
|
|
Thanks, assuming that i will be restoring from the cold backup,at that time the database will not know that there are archive logs to apply?
Thus if i apply the logs,how will i do this will the they bring the datase to the state it was on last hot backup?
|
|
|
|
| Re: Backup and recovery scenario [message #260573 is a reply to message #260513] |
Mon, 20 August 2007 06:06 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
| sellafrica wrote on Mon, 20 August 2007 03:57 |
If one has a cold backup of the database(the whole oracle directory is backed up on the last day of the week(sunday)) and during the week(monday) a hot backup of the database is taken,backing up datafiles,control files,password file,archive logs and init file(we are not using rman,we just put the datafile in backup mode).
If the server crashes on tuesday and we restore the cold backup,
|
Since you've taken a hot backup on Monday, then why restore the cold from a day earlier when you have the hot backup from a day later?
| sellafrica wrote on Mon, 20 August 2007 04:36 | assuming that i will be restoring from the cold backup,at that time the database will not know that there are archive logs to apply?
Thus if i apply the logs,how will i do this will the they bring the datase to the state it was on last hot backup?
|
Oracle will know and you can even specify the archive logs to apply.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
