If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Monitoring multiple oracle exports

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-17-11, 10:08
markel12 markel12 is offline
Registered User
 
Join Date: Dec 2011
Posts: 3
Question Monitoring multiple oracle exports

Does anyone know a tool / script to provide GUI / report to centralize the status of multiple oracle database exports that were run on several servers where oracle is installed ? The idea is to save time & effort to manually monitor each database export separately. thanks.
Reply With Quote
  #2 (permalink)  
Old 12-17-11, 10:25
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,416
extra cost license for Oracle Grid
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #3 (permalink)  
Old 12-17-11, 12:07
markel12 markel12 is offline
Registered User
 
Join Date: Dec 2011
Posts: 3
clarification question

Assuming we have oracle 10g, if this is what u meant, please elaborate what and how can be done to monitor exports on multiple oracle databases, some of which on same machine and some of which on different machines. Thx
Reply With Quote
  #4 (permalink)  
Old 12-17-11, 12:14
anacedent anacedent is offline
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 6,416
Oracle Enterprise Manager Grid Control 11g downloads

extra cost license required for Grid Control
__________________
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Reply With Quote
  #5 (permalink)  
Old 12-17-11, 12:27
markel12 markel12 is offline
Registered User
 
Join Date: Dec 2011
Posts: 3
Question Question

Would u please provide link to actual example / speicifcs how to utilize oracle grid control 11g to monitor exports on various oracle machines ? Also whether it's required to use data pump export for this purpose or regular export is sufficient. Thank u.
Reply With Quote
  #6 (permalink)  
Old 12-20-11, 09:07
beilstwh beilstwh is offline
Lead Application Develope
 
Join Date: Jun 2004
Location: Liverpool, NY USA
Posts: 2,222
What hasn't been mentioned is that if you are using exports for backup, then they are useless. Look up RMAN.
__________________
Bill
You do not need a parachute to skydive. You only need a parachute to skydive twice.
Reply With Quote
  #7 (permalink)  
Old 12-20-11, 10:38
LKBrwn_DBA LKBrwn_DBA is offline
Registered User
 
Join Date: Jun 2003
Location: West Palm Beach, FL
Posts: 2,456
Quote:
Originally Posted by markel12 View Post
Would u please provide link to actual example / speicifcs how to utilize oracle grid control 11g to monitor exports on various oracle machines ? Also whether it's required to use data pump export for this purpose or regular export is sufficient. Thank u.
1) As beilstwh points out, using exports for backup are useless. Look up RMAN.

2) With Grid control, you can schedule the backups and other process' in a central location, and receive e-mail alerts if the jobs fail (or succeed).

3) If you do not want to purchase Grid Control, you can use the Enterprise Manager DB Console (free with rdbms software) on each server to schedule and monitor the backup and other jobs.

__________________
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
Reply With Quote
Reply

Tags
export, monitor, oracle

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On