Utilize 7zip seriously in Cold backup

Q: I have insufficient space for cold backup (oracle or other stuff)
Q: I want to compress backups on windows box but won’t see any GUI window running, they shall run silently
A: free software 7zip provide high compression ratio and command line, treat it seriously and it would help.

Advantage
This Free software easily compress files to 10%-25% smaller size and available on Windows/Linux/Unix platform.

Install 7zip
Download and install , 5mins work.

Backup
7z a -tzip BACKUP_FILE SOURCE_FILES
C:7-Zip>7z a -tzip c:my_backuporacle_data_1.zip c:oracleoradatadb1 


7-Zip 4.57  Copyright (c) 1999-2007 Igor Pavlov  2007-12-06
Scanning

Creating archive c:my_backuporacle_data_1.zip

Compressing  db1TS1_01.DBF
Compressing  db1TS2_01.DBF

Everything is Ok


Restore
7z x BACKUP_FILE -oDESTINATION_DIRECTORY -y
C:7-Zip>
7z x c:my_backuporacle_data_1.zip -oc:oracleoradata -y
/* extract backup to destination directory forcedly */

7-Zip 4.57  Copyright (c) 1999-2007 Igor Pavlov  2007-12-06

Processing archive: c:my_backuporacle_data_1.zip

Extracting  db1
Extracting  db1TS1_01.DBF
Extracting  db1TS1_02.DBF


Everything is Ok

Folders: 1
Files: 2
Size:       447844352
Compressed: 138630376

More details in 7-zip online manual after installation.

Advertisements

About Pang

Oracle DBA working in database, fusion middleware and identity management and cloud.
This entry was posted in Backup. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s