Home » RDBMS Server » Backup & Recovery » Compressed Cold Backup for Oracle on windows
Compressed Cold Backup for Oracle on windows [message #233469] Thu, 26 April 2007 04:26 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,
I had 3 scripts to schedule cold backup

1-shutdown.sql containing
shutdown immediate;
exit;

2-copy.sql containing

host copy C:\ORACLE\ORADATA\TESTNCL\SYSTEM01.DBF e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\EXAMPLE01.DBF e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\INDX01.DBF e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\USERS01.DBF e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\XDB01.DBF e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\NCTEXMIS01.ORA e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\WIZDATA01.ORA e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\CONTROL01.CTL e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\CONTROL02.CTL e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\REDO02.LOG e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\REDO01.LOG e:\backup\
host copy C:\ORACLE\ORADATA\TESTNCL\TEMP_WIZERP01.ORA e:\backup\
exit

3-startup.sql containing
startup;
exit;

All are working fine but the problem is size of all datafiles is 50 GB and now i want to also compress these files during backup
Is it possible ?
if it is then anybody can help me in this regard?

Thanx in advance
Re: Compressed Cold Backup for Oracle on windows [message #233473 is a reply to message #233469] Thu, 26 April 2007 04:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The easiest way is to use a compressed drive on E:

Regards
Michel
Re: Compressed Cold Backup for Oracle on windows [message #233898 is a reply to message #233469] Sat, 28 April 2007 00:35 Go to previous message
javen
Messages: 1
Registered: April 2007
Junior Member
Hi,

You can accomplish this by using HyperBac for Oracle (www.hyperbac.com), let them know you wanted to perform cold backups with compression as opposed to hot backups, they will make sure you get the appropriate edition to do this. You should find that your backup sizes should be reduced by 75-80% and the elapsed time will be 1/2 of what it would take to do the copy uncompressed. Can be done with integrated AES encryption as well. Try it, you will be impressed...
Previous Topic: Backups are failing with status codes 25,41,54,58,202 and 205
Next Topic: import from oracle-EnterprisesEdition(windown-2003) into oracle-xe(suse Linux)
Goto Forum:
  


Current Time: Sat Dec 10 22:43:06 CST 2016

Total time taken to generate the page: 0.07121 seconds