backup 
Author Message
 backup

hi

i just have taken over the dba role and have to
migrate a 7.3.2 dbs to oracle 8. its running
on digital unix and contains quite a lot of
schemas with complex interactions, so i have to
migrate it "as a whole" to the new system.

how can i create an empty o8 database (currently
i just have installed the software) and then
put the contents of the old one (i have a
export all file) properly into this system?

which scripts/programs are used for this task?
i just found vague information in the docs,
maybe i'm searching on the wrong place

thanks in advance!

  <ad>



Tue, 05 Jun 2001 03:00:00 GMT
 backup

Well, the migration utility or a full import/export are the routes to
go. Choose one of. Read up in the docs.

But first: get some training. These are very basic questions to be
asking for someone who has to migrate, build and maintain a production
system. It's very easy to make one mistake and{*filter*}things up
completely.

Just my take.

MotoX.



Quote:
>hi

>i just have taken over the dba role and have to
>migrate a 7.3.2 dbs to oracle 8. its running
>on digital unix and contains quite a lot of
>schemas with complex interactions, so i have to
>migrate it "as a whole" to the new system.

>how can i create an empty o8 database (currently
>i just have installed the software) and then
>put the contents of the old one (i have a
>export all file) properly into this system?

>which scripts/programs are used for this task?
>i just found vague information in the docs,
>maybe i'm searching on the wrong place

>thanks in advance!

>  <ad>



Wed, 06 Jun 2001 03:00:00 GMT
 backup
Andreas-

Migration to O8 is actually pretty straightforward. Basically, you
import the thing as-is and bring up the instance. But... bear in mind
that going back to O7 is a hassle. You can export the O8 db in O7 form,
but that requires the O7 export binaries and the associated message file
and you have to run a script on the O8 server to make the export work.
Plus, any new O8-specific stuff like CLOBs cannot be exported back.

So, you might get ready for a one-way trip. You also need to test the
software pretty carefully before you go live, especially if you are
using stored procedures and triggers.

Roger

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation

Quote:

> hi

> i just have taken over the dba role and have to
> migrate a 7.3.2 dbs to oracle 8. its running
> on digital unix and contains quite a lot of
> schemas with complex interactions, so i have to
> migrate it "as a whole" to the new system.

> how can i create an empty o8 database (currently
> i just have installed the software) and then
> put the contents of the old one (i have a
> export all file) properly into this system?

> which scripts/programs are used for this task?
> i just found vague information in the docs,
> maybe i'm searching on the wrong place

> thanks in advance!

>   <ad>



Wed, 06 Jun 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Backup from filegroup without transaction log backups

2. Backup Exec Full DB Backup

3. Can't backup database to remote backup device

4. Sql Backup using TZ-88 Tape backup

5. Backup Command - expiry of backups

6. Problem with Full backup and Differential backup reference

7. Differential backups larger than full backups?

8. Database backup / database File Backup

9. Backups: Large full backups fail

10. backup script for deleting backups older than 1 day

11. Question about Transaction log backup with Backup Exec

12. SQL DB Backup - transaction log backup?


 
Powered by phpBB® Forum Software