Re: Restore, a theoretical question

how was the first archive log created under 8i if you performed a cold backup before upgrading? perhaps you should rethink your approach. you most likely will corrupt the 8.0 dictionary if you do what you are suggesting. you should either use the 8.0 files with the 8.0 binaries or fix your 8.1 upgrade problem. attempting to mix the two is VERY RISKY.

steve long
"The world's best technology strategist." (TM)

"Kirt Thomas" <kremovethisspamthingthomas_at_gfsiinc.com> wrote in message news:e2tjdt8p120kb2ktlbjln4mdd94h0sfnc1_at_4ax.com...
> First some background; I upgraded my 300gb production database from
> 8.0.5.1 to 8.1.6.3 this weekend (AIX 4.3.3). Everything went
> smooothly until we started using the new rman repository (the old
> repository was an 8.0.5 version and so not able to backup the newly
> updated database). RMAN zips along backing things up into the new
> repository, until it hits the first control file, it then gives a
> corrupt controlfile message and stops. Needless to say, the control
> files are fine, the database is up and running jobs etc etc, and the
> alert log shows no issues. I can shutdown and restart the db and am
> 99.9999 percent convinced that the controlfiles are fine.
>
> Right now we're working a TAR with Oracle on this. But in the interim
> we feel somewhat exposed. I took a cold filesystem backup before the
> upgrade (db down). Now my question is - if the worst happens, and I
> have to recover the database from some catastrophic failure - can I...
>
> First restore from the cold backup - this would give me a closed
> database that was last opened with the 8.0.5.1 svrmgrl. Then using
> the 8.1.6.3 env and svrmgrl, apply the archive logs. My thinking is,
> the upgrade essentially ran catalog and catproc, and this would be in
> my first archivelog - and that because all the logs were created under
> the 8i environmennt, this is the only way to recover. In the end,
> after the archive logs had been applied, I'd have the 8i database
> etc, etc. Does this make sense. Thanks.
Received on Sun Apr 15 2001 - 15:00:11 CDT