Re: Oracle XE backup and restore to transfer data to another server
From: joel garry <joel-garry_at_home.com>
Date: Fri, 4 Mar 2011 09:18:45 -0800 (PST)
Message-ID: <9348e6e9-9b7b-4105-8ed9-fd17d18f5a6a_at_s18g2000prg.googlegroups.com>
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
>
> .
Date: Fri, 4 Mar 2011 09:18:45 -0800 (PST)
Message-ID: <9348e6e9-9b7b-4105-8ed9-fd17d18f5a6a_at_s18g2000prg.googlegroups.com>
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/toc.htm#BABDFDAI
jg
-- _at_home.com is bogus. http://www.aolnews.com/2011/02/25/former-canadian-defense-official-blasts-us-on-ufo-cover-up/Received on Fri Mar 04 2011 - 11:18:45 CST