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
backup(1M) backup(1M)
NAME
backup - backup or archive file system
SYNOPSIS
[-archive]
DESCRIPTION
The command uses find(1) and cpio(1) to save a archive of all files that have been modified since the modification time of on the default
tape drive should be invoked periodically to ensure adequate file backup.
The option suppresses warning messages regarding optional access control list entries. backup(1M) does not backup optional access control
list entries in a file's access control list (see acl(5)). Normally, a warning message is printed for each file having optional access
control list entries.
The option causes backup to save all files, regardless of their modification date, and then update using touch(1).
prompts you to mount a new tape and continue if there is no more room on the current tape. Note that this prompting does not occur if you
are running from cron(1M).
The option causes to start a file system consistency check (without correction) after the backup is complete. For correct results, it is
important that the system be effectively single-user while is running, especially if is allowed to automatically fix whatever inconsisten-
cies it finds. does not ensure that the system is single-user.
You can edit to customize it for your system. Several local values are used that can be customized:
specifies which directories to back up recursively (usually
meaning all directories);
file name where start and finish times, block counts, and error messages
are logged;
file name whose date is the date of the last archive;
file name that is checked by
to remind the next person who logs in to change the backup tape;
file name where start and finish times and
output is logged.
You may want to make other changes, such as whether or not does automatic correction (according to its arguments), where output is
directed, other information logging, etc.
In all cases, the output from is a normal archive file (or volume) which can be read using with the option.
File Recovery
creates archive tapes with all files and directories specified relative to the root directory. When recovering files from an archive tape
created by you should be in the root directory and specify the directory path names for recovered files relative to the root directory When
specifying the directory path name for file recovery by do not precede the leading directory name with a slash. If you prefer, you can
also use with a option to determine how files and directories are named on the archive tape before attempting recovery.
WARNINGS
Refer to in cpio(1).
When runs out of tape, it sends an error to standard error and demands a new special file name from
To continue, rewind the tape, mount the new tape, type the name of the new special file at the system console, and press
If is being run unattended from cron(1M) and the tape runs out, terminates, leaving the process still waiting. Kill this process when you
return.
FILES
parameterized file names
SEE ALSO
cpio(1), find(1), touch(1), cron(1M), fbackup(1M), frecover(1M), fsck(1M), acl(5).
backup(1M)