| Compressed Cold Backup for Oracle on windows [message #233469] |
Thu, 26 April 2007 04:26  |
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 #233898 is a reply to message #233469] |
Sat, 28 April 2007 00:35  |
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...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
