RE: Question for RMAN guru's

My first thought was "no way"...no *free* upgrade from 8i to 9i by simply 
restoring and recovery with 9i.

But thats not what they are saying...right;
" recovery "through" an Oracle 8.1.7.x --> 9.2.0.5 migration,..."

They say/imply;

archive log 1
8i RMAN Backup...
archive log 2
archive log 3
Upgrade/Migrate 8i to 9i...
archive log 4
archive log 5
Upgrade your app...
archive log 6
archive log 7
Database failure...

RMAN(9i)> restore 8i backup.
RMAN(9i)> roll/recover archive log 2 "through" archive log 7
Now 9i database again.

Yeah I believe it...just using the 9i RMAN engine to restore and recovery a 8i 
database files...not really running 8i database "OPEN" with 9i binaries.

Chris Marquez
Oracle DBA





-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Hollis, Les
Sent: Tue 10/4/2005 8:17 PM
To: Paul Drake
Cc: ORACLE-L
Subject: RE: Question for RMAN guru's
 
From the 3rd party documentation

 

 

 

1.       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@xxxxxxxxx] 
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@xxxxxx> 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@xxxxxxxxx] 
        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@xxxxxx> 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.

Other related posts: