Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cold Backup of Oracle database.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cold Backup of Oracle database.
# 1  
Old 04-22-2013
Oracle Cold Backup of Oracle database.
Hi i need a command to cut the last column from the location in a file and want write a
gzip command like

Code:
cat a.txt

/data01/oracle/oradata/vas/data/system01.dbf
/data01/oracle/oradata/vas/data/sysaux01.dbf
/data01/oracle/oradata/vas/data/undotbs01.dbf
/data01/oracle/oradata/vas/data/users01.dbf
/data01/oracle/oradata/vas/data/users02.dbf
/data01/oracle/oradata/vas/data/users03.dbf
/data01/oracle/oradata/vas/data/xdb01.dbf

need to print this command using a.txt.

Code:
gzip -c "/data01/oracle/oradata/vas/data/system01.dbf"     > "/backup/vas/system01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/sysaux01.dbf"     > "/backup/vas/sysaux01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/undotbs01.dbf" > "/backup/vas/undotbs01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users01.dbf"     > "/backup/vas/users01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users02.dbf"     > "/backup/vas/users02.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users03.dbf"     > "/backup/vas/users03.dbf.gz
gzip -c "/data01/oracle/oradata/vas/data/xdb01.dbf"     > "/backup/vas/xdb01.dbf.gz"

Regards
Kaleem.
# 2  
Old 04-22-2013
Code:
awk -F'/' '{ print "gzip -c \"" $0 "\" > \"/backup/" $(NF-2),$(NF-1),$NF ".gz\"" }' OFS='/' a.txt

# 3  
Old 04-22-2013
Hi Yoda

The code is not printing the data with spaces between.

Code:
[oracle]_vas> awk -F'/' '{ print "gzip -c \"" $0 "\" > \"/backup/" $(NF-2),$(NF-1),$NF ".gz\"" }' OFS='/' a.txt
gzip -c "/data01/oracle/oradata/vas/data/system01.dbf                                    " > "/backup/vas/data/system01.dbf                                    .gz"
gzip -c "/data01/oracle/oradata/vas/data/sysaux01.dbf                                    " > "/backup/vas/data/sysaux01.dbf                                    .gz"
gzip -c "/data01/oracle/oradata/vas/data/undotbs01.dbf                                   " > "/backup/vas/data/undotbs01.dbf                                   .gz"
gzip -c "/data01/oracle/oradata/vas/data/users01.dbf                                     " > "/backup/vas/data/users01.dbf                                     .gz"
gzip -c "/data01/oracle/oradata/vas/data/users02.dbf                                     " > "/backup/vas/data/users02.dbf                                     .gz"
gzip -c "/data01/oracle/oradata/vas/data/users03.dbf                                     " > "/backup/vas/data/users03.dbf                                     .gz"
gzip -c "/data01/oracle/oradata/vas/data/xdb01.dbf                                       " > "/backup/vas/data/xdb01.dbf                                       .gz"
gzip -c "/data01/oracle/oradata/vas/control/control01.ctl                                " > "/backup/vas/control/control01.ctl                                .gz"
gzip -c "/data01/oracle/oradata/vas/control/control02.ctl                                " > "/backup/vas/control/control02.ctl                                .gz"
gzip -c "/data01/oracle/oradata/vas/control/control03.ctl                                " > "/backup/vas/control/control03.ctl                                .gz"
gzip -c "/data01/oracle/oradata/vas/redo/redo01.log                                      " > "/backup/vas/redo/redo01.log                                      .gz"
gzip -c "/data01/oracle/oradata/vas/redo/redo02.log                                      " > "/backup/vas/redo/redo02.log                                      .gz"
gzip -c "/data01/oracle/oradata/vas/redo/redo03.log                                      " > "/backup/vas/redo/redo03.log                                      .gz"

This command is also doing same thing but printing spaces between.
Code:
cat a.txt |awk -F'/' '{ print "gzip -c " $0 " >  /backup/"$NF".gz" }'

Code:
[oracle]_vas> cat a.txt |awk -F'/' '{ print "gzip -c " $0 " >  /backup/"$NF".gz" }'
gzip -c /data01/oracle/oradata/vas/data/system01.dbf                                     >  /backup/system01.dbf                                    .gz
gzip -c /data01/oracle/oradata/vas/data/sysaux01.dbf                                     >  /backup/sysaux01.dbf                                    .gz
gzip -c /data01/oracle/oradata/vas/data/undotbs01.dbf                                    >  /backup/undotbs01.dbf                                   .gz
gzip -c /data01/oracle/oradata/vas/data/users01.dbf                                      >  /backup/users01.dbf                                     .gz
gzip -c /data01/oracle/oradata/vas/data/users02.dbf                                      >  /backup/users02.dbf                                     .gz
gzip -c /data01/oracle/oradata/vas/data/users03.dbf                                      >  /backup/users03.dbf                                     .gz
gzip -c /data01/oracle/oradata/vas/data/xdb01.dbf                                        >  /backup/xdb01.dbf                                       .gz
gzip -c /data01/oracle/oradata/vas/control/control01.ctl                                 >  /backup/control01.ctl                                .gz
gzip -c /data01/oracle/oradata/vas/control/control02.ctl                                 >  /backup/control02.ctl                                .gz
gzip -c /data01/oracle/oradata/vas/control/control03.ctl                                 >  /backup/control03.ctl                                .gz
gzip -c /data01/oracle/oradata/vas/redo/redo01.log                                       >  /backup/redo01.log                                      .gz
gzip -c /data01/oracle/oradata/vas/redo/redo02.log                                       >  /backup/redo02.log                                      .gz
gzip -c /data01/oracle/oradata/vas/redo/redo03.log                                       >  /backup/redo03.log                                      .gz

# 4  
Old 04-22-2013
Quote:
Originally Posted by javeedkaleem
...
This command is also doing same thing but printing spaces between.
...
If Perl is an option, then one way to fix this is -

Code:
$
$ # blank spaces exist between the characters "f" and "$"; the "$" represents the end of line
$ cat -vET a.txt
/data01/oracle/oradata/vas/data/system01.dbf                             $
/data01/oracle/oradata/vas/data/sysaux01.dbf                             $
/data01/oracle/oradata/vas/data/undotbs01.dbf                             $
/data01/oracle/oradata/vas/data/users01.dbf                             $
/data01/oracle/oradata/vas/data/users02.dbf                             $
/data01/oracle/oradata/vas/data/users03.dbf                             $
/data01/oracle/oradata/vas/data/xdb01.dbf                             $
$
$ perl -lne 's/\s*$//; ($x=$_)=~s|^.*/||; print "gzip -c \"$_\" > \"/backup/vas/$x.gz\""' a.txt
gzip -c "/data01/oracle/oradata/vas/data/system01.dbf" > "/backup/vas/system01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/sysaux01.dbf" > "/backup/vas/sysaux01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/undotbs01.dbf" > "/backup/vas/undotbs01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users01.dbf" > "/backup/vas/users01.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users02.dbf" > "/backup/vas/users02.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/users03.dbf" > "/backup/vas/users03.dbf.gz"
gzip -c "/data01/oracle/oradata/vas/data/xdb01.dbf" > "/backup/vas/xdb01.dbf.gz"
$
$

---------- Post updated at 11:11 AM ---------- Previous update was at 10:56 AM ----------

Alternatively, you could use the "tr" command to remove blank spaces and then pipe the output to an awk script.

Code:
$
$
$ tr -d " " < a.txt | awk -F'/' '{ print "gzip -c " $0 " >  /backup/"$NF".gz" }'
gzip -c /data01/oracle/oradata/vas/data/system01.dbf >  /backup/system01.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/sysaux01.dbf >  /backup/sysaux01.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/undotbs01.dbf >  /backup/undotbs01.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/users01.dbf >  /backup/users01.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/users02.dbf >  /backup/users02.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/users03.dbf >  /backup/users03.dbf.gz
gzip -c /data01/oracle/oradata/vas/data/xdb01.dbf >  /backup/xdb01.dbf.gz
$
$

However, this will remove all spaces from the file, and not just the trailing spaces. Hopefully that is not a problem in your case.
Login or Register to Ask a Question

Previous Thread | Next Thread

6 More Discussions You Might Find Interesting

1. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies

2. UNIX for Dummies Questions & Answers

I need perl script on cold backup in Oracle 10 g

Hi , I am new to Perl script.Can u please provide me perl scripts for the following: 1. Perl script on Cold backup in Oracle 10g 2.Perl script on Hot backup in Oracle 10g (0 Replies)
Discussion started by: Niharika Srivas
0 Replies

3. Shell Programming and Scripting

Cold backup oracle and Restore to new db

Hello All, I am very new to Linux i have assignment to take offline backup in linux and restore it to new database oracle 10g? Help me out any script of it and steps i will be very thankful Regards, Sameer (0 Replies)
Discussion started by: sameer_123
0 Replies

4. Shell Programming and Scripting

script for backup database

Hello sir, i have used this for taking the database backup 5 * * * * \usr\bin\sh\mysqldump -h localhost -u username-ppassword cms> /home/dbbackup.sql. but it creates a zero size database and in mail it gives error like command not found. Please Help me (3 Replies)
Discussion started by: niva
3 Replies

5. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

6. AIX

Cold backup

Hello, I am newbie IBM AIX.I am working on R12.1.1 O.S IBM AIX i want to take cold backup of 12.1.1 apps,db,inst folder with zip.Please tell me backup command with zip or any other utility.becauze i was using the tar -cvf command this command taking too much space for backup.please reply... (1 Reply)
Discussion started by: umair
1 Replies
Login or Register to Ask a Question