On 10/4/05, Hollis, Les <Les.Hollis_at_ps.net> wrote:
>
> The backup is online………
>
> It hasn't happened yet, we are starting the upgrade in about 2 hours………
>
Les,
Can you take a subset of that backup set (e.g. system, rbs, one app schema
tablespace's datafiles) and restore/recover that using the newer version as
a test?
Sorry that I can't be of more help, as I didn't use rman until 9.2.
I don't even have any 8.1.7 databases around anymore - I was glad to get rid
of them.
Paul
>
> *From:* Paul Drake [mailto:bdbafh_at_gmail.com]
> *Sent:* Tuesday, October 04, 2005 5:59 PM
> *To:* Hollis, Les
> *Cc:* ORACLE-L
> *Subject:* Re: Question for RMAN guru's
>
> On 10/4/05, *Hollis, Les* <Les.Hollis_at_ps.net> wrote:
>
> I am being told that I could recover a database under 9i with backupsets
> that were backed up under 8i.
>
> Scenario:
>
> 8i database (8.1.7.4 <http://8.1.7.4>) on AIX
>
> Backup taken using RMAN
>
> Upgrade DB to 9.2.0.5 <http://9.2.0.5> (that level determined by 3 rdparty application only certified to .5)
>
> NO backup taken after upgrade due to time constraints and lack of disk
> space for backup
>
> Lose database and need to recover
>
> Restore 8i filesets and recover them under 9i
>
> Hasn't happened yet…..we are just projecting….
>
> Can this be done……
>
> According to 3rd party vendor yes with only 3 init.ora settings
>
>
> Was the rman backup set created online or offline (in other words, will it
> require recovery)?
> I can recall attempting to make consistent an 8.1.7 hot physical backup
> set with 9.2 binaries prior to an upgrade (cross-version cloning on test
> hardware).
>
> It wasn't pretty. It was tossed and a cold, consistent backup set was used
> for the test upgrade.
>
> Redo log formats have a habit of changing between major releases.
>
> In general, you will want to have a cold backup set (or offline rman
> backup set - mounted) for opening with the newer version.
>
> How did your tests turn out?
>
> Paul
>
> (that testing was on w2k3 32 bit, with 9.2.0.5.3)
>
>
--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 04 2005 - 18:16:16 CDT
