Oracle XE backup and restore to transfer data to another server

From: syd_p <sydneypuente_at_yahoo.com>
Date: Fri, 4 Mar 2011 04:42:37 -0800 (PST)
Message-ID: <103aa165-eb5d-415a-90b4-38d2cc5cb81b_at_q40g2000prh.googlegroups.com>



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

 . Received on Fri Mar 04 2011 - 06:42:37 CST

Original text of this message