[52054] in SAPr3-news
copy database from oracle 9 to 8.1.7
daemon@ATHENA.MIT.EDU (yls177)
Tue Nov 2 02:05:01 2004
To: sapr3-news@mit.edu
Date: 1 Nov 2004 23:04:56 -0800
From: yls177@hotmail.com (yls177)
Message-ID: <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.
