Which controlfile to use during restore [message #178384] |
Tue, 20 June 2006 23:03 |
xadamz23
Messages: 7 Registered: June 2006
|
Junior Member |
|
|
Hello,
I am trying to figure out which controlfile to use during my restore. Here is my situation:
1. Did a full hot (online) backup on day X. Backup includes all datafiles and controlfile
2. Every 2 hours backup archived redo logs. Also backup controlfile with each of these backups
Lets say I had to rebuild my database from scratch.
I would:
1. restore all datafiles from hot backup that was performed on day X
2. Apply all redo from archived logs backed up.
My question is, which controlfile would I restore? The one taken during the hot backup, or the latest and most recent controlfile from my most recent archived redo backup?
|
|
|
Re: Which controlfile to use during restore [message #178407 is a reply to message #178384] |
Wed, 21 June 2006 01:37 |
aciolac
Messages: 242 Registered: February 2006
|
Senior Member |
|
|
You must to use the most recent controlfile, ideally the controlfile which was used by database during the last time of work. You will be able to restore your database only until the last change(last SCN), which are write in the controlfile. Also if your datafiles have the version(last SCN) upper than last SCN from controlfile, You will have difficulities by restoring database(I don't know precisely, but i think that you will not be able to restore your database). So, You must have the most posssible last version of controlfile and version of datafiles older or equal than controlfile.
|
|
|
|