Re: Oracle XE backup and restore to transfer data to another server

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 10 Mar 2011 10:41:55 -0800 (PST)
Message-ID: <d8520d45-f61e-49e8-ab96-e80a4668c98f_at_r19g2000prm.googlegroups.com>



On Mar 10, 11:59 am, joel garry <joel-ga..._at_home.com> wrote:
> > -Syd
>
> Yes, though I must caution you, while technically it is a logical
> backup, using export utilities and calling it a backup will get you
> flamed in some places.  Oracle DBA's usually call a transactional

I have heard the same thing, and to this day I don't understand this. If I change a script and before doing so make a simple copy, that is a backup. When I do that with a database, it isn't.

RMAN and archived redo logs is obviously the most robust since you can do point in time recovery with just internal database tools, but to say an export of a small schema that is never changed (or even infrequently and can be easily rebuilt from source data) is not a "backup" will draw more than a puzzled glance from a reasonable person. Call it a copy, a backup, whatever you want. Backup works for me. Received on Thu Mar 10 2011 - 12:41:55 CST

Original text of this message