Re: Oracle Backups using ADSM
2015-10-04 17:46:04
Hi Amy from Texaco, this is Stephen from PGS in Australia.
Have you tried IBM ADSM Support (hehhehehe ..... Notice I laugh!)
Like you we are pretty new to this.
Perhaps if I let you know what we do here, that may give you some help if
you haven't already recieved truckloads already. They basically do exactly
what you are doing now. I can't think of any reason why the ADSM server
should have control over the ORACLE server ?? Can anyone else?
Basically we have 2 backup routines running which is pretty much stock
standard in an ADSM & ORACLE enviroment as far as I am aware.
We are neither ADSM gurus or ORACLE DBA's but from what I can tell how we
are setup.
They are started from cron on the client
In our case ...
1) HALF HOURLY Oracle on-liine backup
Backup type: ADSM Archive
Frequency: every 30 minutes
Host : Oracle Server
Backup Domain : All oracle database files and control files in /u0
Backup Media 3590
Backup Destination: 3494 ATL
Backup Retention : 30 days
The oracle online backup uses a Backup log file that is place in a directory
the date/time as an extension. These logs are kept for a month.
These are scripted to do the following
Online backup of ORACLE tablespaces and control files.
1. Loop through all databases in /etc/oratab
2. Check if ARCHIVELOG is enabled in database
3. Run sql script to find the names of the tablespaces
and dynamicaly create the "begin backup" and
"end backup" sql scripts and create a backup copy of
the ORACLE database controlfile.
4. Run sql script to find the names of all datafiles
and controlfiles and build list of files for ADSM
5. Run the sql script "begin backup" created in step 1
to mark tablespaces with the "begin backup" flag.
6. Archive all the control files and the data files.
7. Run the sql script created in step 1 to mark tablespaces
with the "end backup flag.
8. Update the /usr/local/bin/oracle.backup.history file
with the result of the backup job.
2) WEEKLY OFF-LINE BACKUP
Backup type: ADSM Selective
Frequency : every Sunday
Host Oracle Server
Backup domain: /u0 and ORACLE files in /etc and /usr/local/bin
Backup Media: 3590
Backup Destination: 3494 ATL
Rentention: NO LIMIT
Active Versions : 5
Now, the ORACLE database is stopped during this backup. All files that are
part of the ORACLE implentation are backup up regardless of whether they
have changed or not.
In our case the ORACLE backups are scheduled by the ADSM Scheduler on the
ORACLE data base server
A similar log to the off-line backups log file is also produced.
The ORACLE filesystems to be backed up are hard-coded into our scripts and
the must be updated everytime we make a change to ORACLE database
filesystem.
They do the following
Offline backup of ORACLE databases.
1. (Send a message to all connected local users and wait
some minutes. ?)
2. Stop SQL*Net to prevent access to the database during
backup
3. Shut down the database
4. Use ADSM to backup all the ORACLE filesystem and
oracle configuration files in /etc and /usr/local/bin
5. Start up the database
6. Start up SQL*Net
7. (Send a message to the users that where using the
database at the time of shutdown and tell them that
Anyway I am sure someone will come up with an answer and we'd be interested
as well
Regards
Stephen
Stephen R Pole
Operations Manager
Petroleum Geo-Services Data Management Australia
Level 4, IBM Centre
1060 Hay Street
West Perth WA 6005
Australia
Phone +61 8 9320 9080
Direct +61 8 9320 9081
Fax +61 8 9320 9090
Mobile +61 41 239 4435 (041 239 4435)
e-mail stephenp AT prth.geobank.pgs DOT com
*******************Internet Email Confidentiality Footer*******************
Privileged/Confidential Information may be contained in this message. If
you are not the addressee indicated in this message (or responsible for
delivery of the message to such person), you may not copy or deliver this
message to anyone. In such case, you should destroy this message, and
notify us immediately. If you or your employer does not consent to Internet
email messages of this kind, please advise us immediately. Opinions,
conclusions and other information expressed in this message are not given
or endorsed by my firm or employer unless otherwise indicated by an
authorized representative independent of this message.
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Oracle Backups using ADSM, Kuan, Amy M
- Re: Oracle Backups using ADSM, Kelly J. Lipp
- Re: Oracle Backups using ADSM, Herve Chibois
- Re: Oracle Backups using ADSM, Stephen R. Pole
- Re: Oracle Backups using ADSM, Kuan, Amy M
- Re: Oracle Backups using ADSM, Shirley Chirico
- Oracle Backups using ADSM, Kuan , Amy M
- Oracle Backups using ADSM, Kuan , Amy M [SMTP:kuanam
- Re: Oracle Backups using ADSM,
Stephen R . Pole [mailto:stephenp <=
|
|
|