01-16-2012
Need help in backing up of databases.
Hi Everyone,
I am new to DBA stuff. I wonder if anyone can help me. Task is that, I have 10 databases and need to take backups of all the databases using data pump in Unix/Linux, compress them using gzip and use cron to schedule the job twice a day.
Appreciate if anyone can help me in this. I was trying this for a week but no luck.
Thanks,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Ok I'm trying to backup a HD using ufsdump but no matter what I do it rewinds the tape after the dump. Now the tape isn't full (only 285mb) and I still have 6 more partitions I want to put on this tape.
How can I stop the tape from rewinding because I can't think of anything.
Also is there any... (4 Replies)
Discussion started by: merlin
4 Replies
2. UNIX for Dummies Questions & Answers
Hi Guys,
I'm writing a shell script that presents the user with various options, they select one (numbered 1-9) and it then excecutes the correct code. No problem, but I'm having slight difficulty with one option.
The user can select to backup all the files in the current directory to another... (2 Replies)
Discussion started by: indigoecho
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I'm about to start a regular backup schedule for my Linux system.
I need some pointers if I may :)
The system is *mainly* used as a personal home computer (it's actually a laptop running SuSE 9.2) although I do host some client material from it being a PHP developer.
I know that in... (2 Replies)
Discussion started by: d11wtq
2 Replies
4. UNIX for Dummies Questions & Answers
Can you backup the vtoc, then restore it if you somehow mess it up?
This is solaris 9, x86. (1 Reply)
Discussion started by: BG_JrAdmin
1 Replies
5. Solaris
Hello Mentors,
Before anything else I would like to thanks to all expert here especially Pressy as he guided me to recover our server from disk failure. I posted a lot of question from these forum site concerning on how to recover our server and luckly you guys help me. Our server is now up and... (6 Replies)
Discussion started by: eykyn17
6 Replies
6. UNIX for Dummies Questions & Answers
Hello,
I run a web hosting company, and I'm wondering how I can use cPanel's Cron Jobs so that a copy of my entire home directory and a copy all of my MySQL databases can be compressed and emailed to me. I know nothing about Linux, Unix, or whatever that thing with the penguin is called. :)
... (7 Replies)
Discussion started by: millipedeman
7 Replies
7. AIX
we are running aix on are server. we would like to start doing online backups, but the software company that we use is not beeing much help on what files we are backing up. is there a command that will tell me what files that we are backing up. they offer a service that would back it up for use,... (3 Replies)
Discussion started by: shane.hankins
3 Replies
8. Shell Programming and Scripting
Hello,
I have two databases one is student_Name and another is student_Name1...Two tabled contain 200 records each..I found that near 30 names are entered in both databases..I would like to remove the duplicates..and i have to keep the name which is newly added..Please hepl how to remove... (7 Replies)
Discussion started by: Anjali_vee
7 Replies
9. Solaris
Got 5-6 Solaris 10 servers in remote location - power work being done.
At the moment, we just back up the application database that these servers run with the idea that if it all goes wrong we can rebuild and then restore the application.
However, requirement is to provide a complete backup... (3 Replies)
Discussion started by: paulfoel
3 Replies
10. UNIX for Advanced & Expert Users
Are there any recommended methods for Backing up an entire HD? I want to backup my data. I do not care about the OS file. I just want my work, movies, and music. I have about 600 GB of work, movies, and music so a bit worried about fragmentation if I just copy and paste. (1 Reply)
Discussion started by: cokedude
1 Replies
at(1) General Commands Manual at(1)
Name
at, batch - execute commands at a later time
Syntax
at time [day] [file]
at -r job...
at -l [job...]
batch [file]
Description
The and commands use a copy of the named file (standard input default) as input to or at a later time. A command to the current directory
is inserted at the beginning, followed by assignments to all environment variables. When the script is run, it uses the user and group ID
of the creator of the copy file.
The command allows the user to specify when the commands should be executed, while jobs queued with execute when the load level of the sys-
tem permits.
The environment variables, current directory, and are retained when the commands are executed. However, open files, traps, and priority
are lost.
Users are permitted to use the and commands if their name appears in the file If that file does not exist, the file is checked to determine
if the user should be denied access to and If neither file exists, only the superuser is allowed to submit a job. If only the file exists
and is empty, global usage is permitted. The files consist of one user name per line.
The time is 1 to 4 digits. It can, but does not have to be, followed by A, P, N or M which stand for AM, PM, noon or midnight, respec-
tively. The A, P, N, and M suffixes are case-insensitive. One and two digit numbers are interpreted as hours, three and four digits to be
hours and minutes. If three digits are specified, the first digit is interpreted to be an hour in the range 0-9, and the second and third
digits as minutes. If no letters follow the digits, a 24 hour clock time is presumed.
In addition to 1-4 digits, and suffixes A, P, M, N, you can also specify:
at hh:mm
at h:mm
at ham
at hpm
at noon
at midnight
The optional day is either a month name followed by a day number or by a day of the week. If the word week follows, the or command is
invoked in seven days. Both commands also recognize standard abbreviations for the days of the week and months of the year. The following
are examples of legitimate commands:
at 8am jan 24
at 1530 fr week
The programs are executed by periodic execution of the command from The granularity of depends upon how often atrun is executed. The com-
mand examines the file every minute. The file determines when is executed. The default is every 15 minutes on the 1/4 hour. Editing makes
run more or less frequently.
Standard output or error output is lost unless it is redirected.
The and commands write the job number to standard error.
Options
-r Removes jobs previously scheduled by or The number is the number reported at invocation by or Only the superuser is
allowed to remove another user's jobs.
-l Lists all job numbers for all jobs submitted by the user issuing the command. Even if the user is "root", only numbers
for jobs submitted by "root" are displayed. To see the numbers of all jobs submitted, enter the following command:
% ls -l /usr/spool/at
Restrictions
Due to the granularity of the execution of there may be bugs in scheduling jobs almost exactly 24 hours into the future.
Diagnostics
Complains about various syntax errors and times that are out of range.
Files
/usr/lib/atrun executor run by cron(8)
in /usr/spool/at:
yy.ddd.hhhh.* activity for year yy, day dd, hour hhhh.
lasttimedone last hhhh
past activities in progress
/usr/spool/at/at.allowlist of allowed users
/usr/spool/at/at.denylist of denied users
/usr/spool/at spool directory
/usr/lib/cron XOPEN compatibility
See Also
crontab(5), cron(8)
at(1)