| controlfiles versus recovery [message #61593] |
Fri, 07 May 2004 01:49  |
marinus
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
Hy List
I had an littel argue about Recovery
If i loos all Controlfiles and some database files am i able to recover to the last change inside the database ?
I said no of cause not where else should the scn be how should the database know how far to rolle forward
my coleg said it ist posible RMAN can do this ??
I am cofused
whats right or wrong
Regard Marinus
|
|
|
|
| Re: controlfiles versus recovery [message #61594 is a reply to message #61593] |
Fri, 07 May 2004 03:39  |
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
|
Senior Member |
|
|
Hi,
It totally depends upon the mode in which ur DB is running. If ur DB is running in archivelog mode than you can restore the latest backup which includes ur control files also and apply the archive logs to recover the DB upto the time of failure.
But in case of noarchivelog you have to restore the last consistent backup and all the data after that backup will be lost.
And if u dont have any backup than there is only option which is loss of database.
RMAN is an oracle supplied utility which is used for backup and recovery. If u have valid RMAN backups than u can easily restore ur DB depending on the mode of DB, but RMAN can't do any magic due to which ur DB will start working in any circumstances.
Daljit Singh.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
