Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> copy database from oracle 9 to 8.1.7

copy database from oracle 9 to 8.1.7

From: yls177 <yls177_at_hotmail.com>
Date: 2 Nov 2004 07:28:32 -0800
Message-ID: <c06e4d68.0411020728.1001cce@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. Received on Tue Nov 02 2004 - 09:28:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US