RMAN Restore Question

From: <amerar_at_iwc.net>
Date: 20 Apr 2005 06:26:09 -0700
Message-ID: <1114003569.257724.28800@z14g2000cwz.googlegroups.com>

Hi,

I'm not sure I understand this situation. We are testing with RMAN. So, I deleted all copies of the control file, and, the instance crashed as I expected it would.

Then, I used RMAN and restored the control file from a previous backup. At this point, The control file has an eariler SCN than the data file headers. So, I ussed a 'recover database' which I thought should, roll everything forward.

If this is true, why did I still need to open with resetlogs? I figured that the rolling forward brought the database back up to present.....

Here is a copy of the script I ran:

run {
allocate channel ch1 type disk;
restore controlfile to '/u02/oradata/mpctest/control01.ctl'; replicate controlfile from '/u02/oradata/mpctest/control01.ctl'; sql "alter database mount";
recover database;
release channel ch1;
}

Arthur Received on Wed Apr 20 2005 - 08:26:09 CDT