Home » RDBMS Server » Backup & Recovery » OracleXE Backup & Recovery (Windows 2003, Oracle XE)
icon5.gif  OracleXE Backup & Recovery [message #493861] Thu, 10 February 2011 04:43 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have installed Oracle XE on my Windows 2003 Standard Edition OS. My USERS.DBF file is near 4GB, so I must delete a lot of unusable records to reduce users tablespace, and I would like to know, if I backup and recovery that Oracle XE database is it mean that files will be smaller and is there some backup and recovery method who will make an 'transportable' copy of whole database for a migrating to a new machine or easier archiving on another machine?

Thanks in advanced...
Re: OracleXE Backup & Recovery [message #493880 is a reply to message #493861] Thu, 10 February 2011 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 59088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) No, it will not be smaller
2) Any full backup allow you to restore/recover in another server.

Regards
Michel
Re: OracleXE Backup & Recovery [message #494007 is a reply to message #493880] Thu, 10 February 2011 17:06 Go to previous messageGo to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi Michael,

Thanks for help. I found that if I rewrite data from one to another Oracle XE database all works fine and datafiles are more compacted than old files without deleted records.

So if it is not to big request I need simplest or some another script which will backup oracle xe database from c:\oraclexe to d:\orabackup into files which is represent transportable backup?

Thanks in advanced for all...
Re: OracleXE Backup & Recovery [message #494024 is a reply to message #494007] Thu, 10 February 2011 23:31 Go to previous message
Michel Cadot
Messages: 59088
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
copy c:\oraclexe\* d:\orabackup

Regards
Michel

[Updated on: Thu, 10 February 2011 23:31]

Report message to a moderator

Previous Topic: RMAN Recovery failing with Incremental level 0 Backup
Next Topic: Database recovery with missing one of the archivelog
Goto Forum:
  


Current Time: Wed Sep 17 00:36:05 CDT 2014

Total time taken to generate the page: 0.23452 seconds