Sponsored Content
Top Forums Shell Programming and Scripting Need help in backing up of databases. Post 302590524 by sreepriya0987 on Monday 16th of January 2012 02:41:58 PM
Old 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

backing up

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

Backing Up Directories

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

Best practises for backing up

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

backing up the vtoc

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

Backing up the system

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

Backing Up and Emailing Home Directory and SQL Databases

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

what am i backing up

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

Two databases

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

Backing up Solaris 10 servers

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

Backing up an entire HD

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)
All times are GMT -4. The time now is 01:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy