Sponsored Content
Top Forums Shell Programming and Scripting Oracle hot backup script issue Post 302213915 by jim mcnamara on Friday 11th of July 2008 10:33:53 AM
Old 07-11-2008
Code:
alter tablespace SYSTEM begin backup; 
host cp /fcdata1/fl03r/data/system01.dbf /fcdata1/hotbkp_script/20080711/system01.dbf 
host gzip /fcdata1/hotbkp_script/20080711/system01.dbf 

host cp /fcdata1/fl03r/data/system02.dbf /fcdata1/hotbkp_script/20080711/system02.dbf 
host gzip /fcdata1/hotbkp_script/20080711/system02.dbf 

alter tablespace SYSTEM end backup;

try this.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help with oracle backup script

I have written a script to perfrom a cold backup on an oracle database. The script is failing everytime. Can anyone tell me what (stupid) error I am making. The output from the uname command follows Linux rayora 2.2.14-6.1.1smp #1 SMP Thu Apr 13 19:55:55 EDT 2000 i686 unknown The error... (8 Replies)
Discussion started by: beilstwh
8 Replies

2. UNIX for Advanced & Expert Users

Shell script on Oracle hot backup got an error

Hi Unix Shell Script Expert, We have a robust shell script (from old time) for our 9i database hot backup but generated error: Shell Script Content: #check for auto log mode and redirect as early as possible # autolog_enable $AUTOLOG_MODE $ORACLE_BASE/${ORASID_LOW}log/cron_hotbackup.log... (1 Reply)
Discussion started by: oradbus
1 Replies

3. Programming

Host command NOT getting executed in Hot backup script.

Hi All, i have problem in the following Sql Script. problem is : HOST (!) command is not getting executed.pls de-bugg this HoTBackup Script...... Most urgent...! Thank You very Much !! SQL> set serveroutput on SQL> set trimspool on SQL> set line 500 SQL> set head off SQL> set feed off... (4 Replies)
Discussion started by: user__user3110
4 Replies

4. Shell Programming and Scripting

Help with sed in Oracle DB backup script.

I have a script like this .. #!/bin/ksh database=$(echo $@ | sed 's/.*-S \(*\).*/\1/') instance=$(grep "$database" /var/opt/oracle/oratab | awk -F : '{print $1}') command=$(echo $@ | sed 's/"$database"/"$instance"/') echo $command when I tried to execute the script like this ... ksh... (5 Replies)
Discussion started by: talashil
5 Replies

5. Red Hat

hot-add disk in oracle enterprise linux 5.5

Hi all, I have an Oracle Enterprise Linux 5.5 server which is a virtual guest on a vSphere host. I have provisioned 500GB disk space from SAN. I then migrated the VM from a 200GB disk onto the new 500GB disk. I then increased the disk space allocated to the VMware to the maximum size of... (7 Replies)
Discussion started by: Tommyk
7 Replies

6. HP-UX

Can we restore omni oracle db backup

We have omni backup of oracle database about 40Gb, tablespaces are distributed over 2 partitions . But because of some reason both partition are not available more . Now we are in need to restore the entire data on new partitions .Can any guru's confirm if tried so earlier will this going to... (1 Reply)
Discussion started by: Shirishlnx
1 Replies

7. 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

8. 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

9. Shell Programming and Scripting

Shell script to call Oracle archive backup script when file system reaches threshold value

Hello All, I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60% Need to identify the unique file system that reaches threshold value. ex: capacity ... (4 Replies)
Discussion started by: sasikanthdba
4 Replies

10. Shell Programming and Scripting

parameter issue in oracle shell script

Hi All, I am new to this code and shell scripting. I have code like below CREQID=`echo $* | awk '{gsub(/"/, ""); print$9}'` REQID=$3 echo CREQID=$CREQID I have another parameter added to the report/program(interchanged) 1st one is now, order_no, 2nd one is CREQID. Now if... (2 Replies)
Discussion started by: Mist123
2 Replies
mddiff(1)						 Sync Mail Dir (smd) documentation						 mddiff(1)

NAME
mddiff - computes diff for maildirs SYNOPSIS
mddiff [--max-mailno mno] [--db-file dbf] [-l|--list] [-s|--symlink] [--exclude globexpr] [-v|--verbose] [-d|--dry-run] [-n|--no-delete] [--help] [--sha1sum] paths DESCRIPTION
mddiff computes the delta from an old status of a maildir (previously recorded in a support file, called db file) and the current status, generating a set of commands (a diff) that a third party software can apply to synchronize a (eventually remote) copy of the maildir. If paths is a single file name, and that file is a fifo, mddiff reads from it file names separated by new line and outputs the sha1 of its header and body separated by space. $ mddiff /tmp/fifo_for_mddiff 806a0ffe4f29766effd764... 463e543da9dac8e298... 582cbb6a5cd3ce13965c8c... 8fa60a7458b1157193... ... If paths is a single file name, and that file is a fifo, and the -s option is passed, mddiff reads from that fifo two lines at a time, respectively a source name and a target name. It then creates a symlink named as as the target name pointing to the source name. If some dictories need to be created in order to create the symlink, this is also done. mddiff will print 'OK' on stdout to signal a success, 'ERROR' to signal an error. If paths is a list of directories, mddiff outputs a list of actions a client has to perform to synchronize a copy of the same maildirs. This set of actions is relative to a previous status of the maildir stored in the db file. The input directories are traversed recur- sively, and every file encountered inside directories named cur/ and new/ is a potential mail message (if it contains no it is skipped). $ mddiff ~/Mail/ ADD ~/Mail/cur/1239038050.14937_1.garfield:2,S 66532ebb05b252e... ... Every client (endpoint using mddiff for synchronization) must use a different db-file, and the db-file is strictly related with the set of directories given as arguments, and should not be used with a different directory set. Adding items to the directory set is safe, while removing them may not do what you want (delete actions are generated). mddiff does not alter the dbf file, it generates a new one called dbf.new. It is up to the higher level tool smd-server(1) to rename dbf.new to dbf in case the other endpoint successfully applied the diff. The --exclude option tells mddiff to ignore all paths matching the given glob(7) expression. This option can be passed multiple times. Matching is performed using fnmatch(3) with no special flags, thus '*' and '?' match any character including '/'. Matching is performed when a directory is entered. If the match is successful, the directory and all its subedirectories are skipped. The --no-delete option tells mddiff to not output a DELETE action for files that disappear. Note that a DELETE action is anyway generated for files that are moved (i.e. move is COPY plus DELETE). The result is that deletions are not propagated to the other endpoint. OPTIONS
--max-mailno mno Estimation of max mail message number (defaults to the number of messages in the db-file + 1000 or 500000 if there is no db-file). You may want to decrease it for the first run on small systems. It is anyway increased automatically when needed --db-file dbf Name of the cache for the endpoint (default db.txt) --exclude globexpr Exclude paths maching the given expression --sha1sum Behaves like the sha1sum utility --mkdir-p Behaves like mkdir -p --mkfifo Behaves like mkfifo -l --list Only list the mailboxes recursively contained in paths -s --symlink Create symlinks for paths read on the input fifo -v --verbose Increase program verbosity (printed on stderr) -d --dry-run Do not generate a new db-file -n --no-delete Do not track deleted files --help This help screen NOTES
mddiff is a low level utility, used by smd-server and smd-client. You should use higher level tools like smd-pull(1), smd-push(1) and smd- loop(1) SEE ALSO
smd-client(1), smd-server(1), smd-pull(1), smd-push(1), smd-loop(1) AUTHOR
Enrico Tassi <gares@fettunta.org> 11 June 2012 mddiff(1)
All times are GMT -4. The time now is 05:45 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy