10-16-2013
Having 3 archive directories on a single filesystem is a bad idea : if for any reason one of the archive directory fills the FS, it will also freeze the 2 other databases.
You'd better to separate 3 differents FS and mount each of them on their own directories so that if a problem occurs, the problem will not impact the 2 other database.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
2. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
3. Shell Programming and Scripting
Would appreciate if any one can paste a generic schell script to archive a file with date stamp by passing the file with fullpath as parameter
For Eg. /apps/scripts/Archive_File.sh /data_home/project_home/file.txt
this should place the file in the following directory
... (8 Replies)
Discussion started by: mak1600
8 Replies
4. Shell Programming and Scripting
Hi everyone!
I'm new with Shell Scripting, and I have to do a shell script to call a procedure, which have 2 input parameters, the directory(from server) and the txt file (which have informations to update/insert in DB).
I have to create a shell script to execute that procedure for each txt... (5 Replies)
Discussion started by: renatoal
5 Replies
5. Shell Programming and Scripting
Hello,
Recently, I've started with shell scripting, and decided to write a script for my system backup using tar. When I was dealing with tar execution inside shell script I found this, inside shell we have the following code:
tar $TAR_PARAMS $ARCHIVE_FILE $EXCLUDE $BACKUP_STARTwith... (6 Replies)
Discussion started by: ilnar
6 Replies
6. Shell Programming and Scripting
Hi
Can someone assist in writing a script.
I have a filesystem named /sybase in my aix lpar.
When this filesystem becomes 94% full all the files and directories under /sybase/logs should be deleted immediately. :confused: (7 Replies)
Discussion started by: newtoaixos
7 Replies
7. Shell Programming and Scripting
Hi Guys,
Need you help in one point!
I am working on one shell script which takes following steps :
1. Taking one query result from oracle database
2. Exporting that result to Xls file
3. Mailing that file to my own mail ID
Now, I want to give a threshold limit to one of the column... (0 Replies)
Discussion started by: Agupte
0 Replies
8. Red Hat
Hey i have a package in oracle to validate file mask. can i call it in through
shell script . if yes , how
Thanks (1 Reply)
Discussion started by: ramsavi
1 Replies
9. Shell Programming and Scripting
I am trying to accomplish following tasks in my KSH script:
Run a sql script on multiple $ORACLE_SID at once
Sends an alert only if the threshold > 2 for any of the $ORACLE_SID
Please advice as to how I can approach this!!
Thanks in advance! (1 Reply)
Discussion started by: jd_2000
1 Replies
10. Shell Programming and Scripting
Dear All,
I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value.
for name in *.csv;
do
echo "connecting to DB and start processing '$name' file at "
echo "csv file name=$x"
sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies
ha(1) HA archiver ha(1)
NAME
ha - a small file archiver utility
SYNOPSIS
ha <command>[<option><option>...] archive [ name ... ]
DESCRIPTION
After the program name comes a command name (single letter) and options (single letters, appended to the command name without a space).
COMMANDS
a[sdqemr012]
Add files matching search pattern to archive.
e[aqty]
Extract files matching search pattern from archive.
x[aqty]
Extract files matching search pattern from archive using path information stored in archive.
l[f] List files currently in archive.
d[q] Delete files matching search pattern from archive. If archive does not contain any files after deletion it is removed.
f[sdqemr012]
Freshen files in archive. All files matching search pattern and newer than version already in archive are updated to archive.
u[sdqemr012]
Update files to archive. All files matching search pattern that are newer than version already in archive or are not yet in archive
are updated to archive.
t[q] Test files in archive.
OPTIONS
0,1,2 Try compression method #. More than one can be specified.
Methods are:
0-CPY Simple copying of files.
1-ASC Default method using sliding window dictionary followed by arithmetic
coder. Offers quite good compression on wide variety of file types.
2-HSC Compression method based on finite context model and arithmetic
coder. Quite slow for binary data, but offers very good compression
especially for longer text files.
y Assume answer yes on all questions.
t Touch files when extracting. Sets file times to current machine time.
r Recurse through subdirectories while searching for files matching search pattern.
f Full listing of stored file information.
m Move files when archiving. Files are removed from disk after they are successfully written to archive.
a Set system specific file attributes when extracting files.
s Find special files when archiving.
e Do not store pathname information.
q Quiet operation.
d Make separate entries for directories. Saves information about empty directories, directory attributes etc. in archive.
AUTHOR
This manual page was written by Mikhail Gusarov <dottedmag@dottedmag.net> for Debian GNU/Linux system (but may be used by others).
ha 0.999p 3 Jul 2008 ha(1)