Re: Oracle XE backup and restore to transfer data to another server
From: joel garry <joel-garry_at_home.com>
Date: Thu, 10 Mar 2011 08:59:50 -0800 (PST)
Message-ID: <ab58d28a-291e-4d5e-bb5c-1817c8fedfee_at_k10g2000prh.googlegroups.com>
On Mar 9, 5:34 am, syd_p <sydneypue..._at_yahoo.com> wrote:
> On 4 Mar, 18:18, joel garry <joel-ga..._at_home.com> wrote:
>
> > On Mar 4, 4:42 am, syd_p <sydneypue..._at_yahoo.com> wrote:
>
> > > Hello,
> > > I have XE 10.
> > > 2 on linux, 3-4 times a day data gets written into this database,
> > > which actually overwrites what was there before..
> > > What I want to do is to backup this data, transfer the backup to
> > > another server which I have not yet installed, and restore it so I can
> > > run some applications against the data and test that it all works OK.
> > > Or if it does not fix it.
>
> > > Right now the database is not running in archivelog mode, cos it does
> > > not need to be cos the data is transient. So probably I cannot use the
> > > $ORACLE_HOME/config/scripts/backup.sh, cos that uses RMAN.
>
> > > Any suggestions?
>
> > > -Syd
>
> > > .
>
> > Yosarian is correct about the cold backup, it explicitly (and kind of
> > scarily, which is a good thing for production uses) tells you it will
> > shut down the db for the backup (at least on winblows, you can look at
> > the script on linux and see). Note that there are also other options
> > for transferring data. You can use the regular export/import
> > utilities, which is very handy if you aren't using an identical XE
> > elsewhere. XE also has unload to text and unload to XML under the
> > utilities menu. Unfortunately you can't use the handy transportable
> > tablespaces option. http://download.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/t...
>
> > jg
> > --
> > _at_home.com is bogus.http://www.aolnews.com/2011/02/25/former-canadian-defense-official-bl...
>
> Hmm Thanks. Had a look thro the URLhttp://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/imp...
> I realise now what I really want to do is to back up a schema on one
> box and then restore on another box which has a out of the box
> install of XE.
> Seems like Data Pump Export and Data Pump Import is the way to go.
> Am I right?
>
> -Syd
Date: Thu, 10 Mar 2011 08:59:50 -0800 (PST)
Message-ID: <ab58d28a-291e-4d5e-bb5c-1817c8fedfee_at_k10g2000prh.googlegroups.com>
On Mar 9, 5:34 am, syd_p <sydneypue..._at_yahoo.com> wrote:
> On 4 Mar, 18:18, joel garry <joel-ga..._at_home.com> wrote:
>
> > On Mar 4, 4:42 am, syd_p <sydneypue..._at_yahoo.com> wrote:
>
> > > Hello,
> > > I have XE 10.
> > > 2 on linux, 3-4 times a day data gets written into this database,
> > > which actually overwrites what was there before..
> > > What I want to do is to backup this data, transfer the backup to
> > > another server which I have not yet installed, and restore it so I can
> > > run some applications against the data and test that it all works OK.
> > > Or if it does not fix it.
>
> > > Right now the database is not running in archivelog mode, cos it does
> > > not need to be cos the data is transient. So probably I cannot use the
> > > $ORACLE_HOME/config/scripts/backup.sh, cos that uses RMAN.
>
> > > Any suggestions?
>
> > > -Syd
>
> > > .
>
> > Yosarian is correct about the cold backup, it explicitly (and kind of
> > scarily, which is a good thing for production uses) tells you it will
> > shut down the db for the backup (at least on winblows, you can look at
> > the script on linux and see). Note that there are also other options
> > for transferring data. You can use the regular export/import
> > utilities, which is very handy if you aren't using an identical XE
> > elsewhere. XE also has unload to text and unload to XML under the
> > utilities menu. Unfortunately you can't use the handy transportable
> > tablespaces option. http://download.oracle.com/docs/cd/B25329_01/doc/license.102/b25456/t...
>
> > jg
> > --
> > _at_home.com is bogus.http://www.aolnews.com/2011/02/25/former-canadian-defense-official-bl...
>
> Hmm Thanks. Had a look thro the URLhttp://download.oracle.com/docs/cd/B25329_01/doc/admin.102/b25107/imp...
> I realise now what I really want to do is to back up a schema on one
> box and then restore on another box which has a out of the box
> install of XE.
> Seems like Data Pump Export and Data Pump Import is the way to go.
> Am I right?
>
> -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 backup a backup, and everything else not a backup, which in a practical sense these days means archivelog mode and RMAN hot backups. One big exception is if you are recreating the data every time from somewhere else that is backed up. Since that sounds like your situation, maybe you can clone that process? Just another thought.
Data Pump does have a network option, if you have proper connectivity.
jg
-- _at_home.com is bogus. http://www.bloomberg.com/news/2011-03-08/hacking-of-dupont-j-j-ge-were-google-type-attacks-that-weren-t-disclosed.htmlReceived on Thu Mar 10 2011 - 10:59:50 CST