RE: Question for RMAN guru's

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Tue, 4 Oct 2005 19:17:07 -0500
Message-ID: <683E0A1C82D75246BD9F4E01F77CBB0F019AC61E@pscdalpexch02.perotsystems.net>

>From the 3rd party documentation

To help minimize downtime, a complete hot backup can be completed after the end users are allowed onto the system. This is due to the fact that one is able to recovery "through" an Oracle 8.1.7.x --> 9.2.0.5 migration, unlike the circumstances with Oracle 7.3.3 --> 8.1.7.x migrations. If recovery is required from Oracle 8i backups, then all recovery steps must be done in the Oracle 9i environment.

From: Paul Drake [mailto:bdbafh_at_gmail.com] Sent: Tuesday, October 04, 2005 6:13 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:

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) on AIX

Backup taken using RMAN

Upgrade DB to 9.2.0.5 (that level determined by 3 rd party 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 - 19:20:03 CDT