Visit Our UNIX and Linux User Community


Need help in backing up of databases.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need help in backing up of databases.
# 1  
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,
# 2  
Old 01-16-2012
Hi,

may you please show on the post what you were trying 'till now, so we can figure out where you got so far.

Further, you mentioned datapump, so I can assume you're talking about Oracle DB: in the future please detail the software you are referring to.
If you need help with Oracle datapump you may begin with having a look at:
http://www.oracle-base.com/articles/...ataPump10g.php
http://www.oracle-base.com/articles/...ents_11gR1.php

see ya
fra

Last edited by frappa; 01-16-2012 at 06:21 PM..

Previous Thread | Next Thread
Test Your Knowledge in Computers #945
Difficulty: Medium
A Fraggle attack is a variation of the Smurf attack where an attacker sends a large amount of UDP traffic to ports 7 (Echo) and 19 (CHARGEN) to an IP broadcast address with the intended victim's spoofed source IP address.
True or False?

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

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

Featured Tech Videos