[52153] in SAPr3-news
Re: copy database from oracle 9 to 8.1.7
daemon@ATHENA.MIT.EDU (yls177)
Sun Nov 7 08:42:37 2004
To: sapr3-news@mit.edu
Date: 7 Nov 2004 05:42:32 -0800
From: hosea.basis@gmail.com (yls177)
Message-ID: <7aae98a9.0411070542.58eb6f4@posting.google.com>
yls177@hotmail.com (yls177) wrote in message news:<c06e4d68.0411040338.510213ba@posting.google.com>...
> yls177@hotmail.com (yls177) wrote in message news:<c06e4d68.0411012304.4b59bf3a@posting.google.com>...
> > I am going to restore my PRD (8.1.7) to DEV (9). In my PRD, I have a
> > full offline backup scheduled in db13 to a DDS-4 tape. With this tape,
> > I am going to restore PRD to my DEV.
> >
> > 1) Remove all the DEV filesystems
> > 2) Create the PRD filesystems
> > 3) the command used to restore is "brrestore -b
> > <coded_timestamp>.<fid> -m full". This file <coded_timestamp>.<fid> is
> > tied to the same one with what is shown in the DB13 log.
> > 4) This will restore the complete PRD system. Problem is that this
> > restored system is a 8.1.7. But the one in DEV is 9 therefore the
> > binary is different. Hence I need to upgrade this current copy to PRD
> > by
> > a. upgrade the cloned 8.1.7 database to 9.2.0 by running
> > @?/rdbms/admin/u0801070.sql
> > 5) In note 592393, it wrote
> > "Switch from 8.1.7 to 9.x
> > After the copy, you must execute all of the upgrade steps
> > described in the
> > guide for upgrading to Oracle 9.x. "
> >
> > Please advise.
>
>
>
> i thought of another solution and is as belows
>
>
> I am going to restore my PRD (oracle 9) to DEV (oracle 8) and vice
> versa. In my PRD, I have a full offline
> backup scheduled in db13 to a DDS-4 tape. With this tape, I am going
> to restore PRD to my DEV.
>
> I am going to do the below 2 tasks
>
> A) Restore my PRD_A (oracle 9) to DEv_B (oracle 8)
> B) Restore my PRD_B (oracle 8) to DEV_A (oracle 9)
>
> PRD_* and DEV_* are SAP servers.
>
> I have 2 solutions at the moment. And will greatly welcome for more
> advise...
>
> A.1) DEV (oracle 8) will be kept intact. There are enough space for
> PRD (oracle 9)
>
> Steps
> 1) Same procedure as installing a SAP with oracle 9
> 2) but stopped at loading the database
> 3) restore the backup copy from PRD (oracle 9). the command used to
> restore is "brrestore -b <coded_timestamp>.<fid> -m full". This file
> <coded_timestamp>.<fid> is tied to the same one with what is shown in
> the DB13 log.
>
>
> B) Restore my PRD_B (oracle 8) to DEV_A (oracle 9)
> B.1) Due to insufficient space, DEV_A has to be removed of oracle 9.
> then same steps as (A)
>
>
>
> Alternate solution
>
> 1) Remove all the DEV filesystems
> 2) Create the PRD filesystems
> 3) the command used to restore is "brrestore -b
> <coded_timestamp>.<fid> -m full". This file coded_timestamp>.<fid> is
> tied to the same one with what is shown in the DB13 log.
> 4) This will restore the complete PRD system. Problem is that this
> restored system is a 8.1.7. But the one in DEV is 9 therefore the
> binary is different. Hence I need to upgrade this current copy to PRD
> by
> a. upgrade the cloned 8.1.7 database to 9.2.0 by running
> @?/rdbms/admin/u0801070.sql
> 5) In note 592393, it wrote "Switch from 8.1.7 to 9.x After the copy,
> you must execute all of the upgrade steps
> described in the guide for upgrading to Oracle 9.x. "
>
> Please advise.
this is a more towards SAP standard way of doing
1) install sap instance
2) install db instance and oracle db software
3) dont load the database from the SAP CDs, therefore, from R3SETUP.
4) ensure that oracle is fine with svrmgrl.
5) brrestore the datafiles.
Advise?
