-
Automate shutdown of Oracle Concurrent Managers then DB for backup
Hi ,
**Oracle 11i Apps , 9i DB , RH Linux 3 AS**
Im looking at a script that will run using cron on a weekly basis at sometime during w/e after hours.
I need this to shutdown the concurrent mgrs ( using adstpall.sh) , wait until these are down ( ps-ef | grep FNDLIBR) and then shutdown the database using (firstly) a shutdown normal , and if after a period of time , a shutdown immediate.
After the db is backed up ( cold obviously ) I want to start the db up , then the conncurrent manages ( adstrtall.sh)
Im not asking for much , am I ?
Anyone else doing this?
Any ideas?
Cheers
Stephen
-
why not do a hot backup? - save all this hassle and not have the problems where it gets itself in a mess and doesnt go down / come up
-
We are doing cold backup for our dev and testing system.
The basic is like this:
on db-tier:( we have concurrent processing on this db-tier)
we schedule a corn job from root ( since we have two accounts;
oracle and applmgr)
1. use adstpall.sh to shutdown all the services as applmgr
2. use stopora.sh to shutdown all the db listener, db and web
from oracle
3.do the copying job
4. use startora.sh to start the database as oracle
5. use adstrtal.sh
on apps tier, this is simple. just stop and starat the sevices.
Lily
-
1.# create the backup script
$ cd /demo/oracle
$ vi backup.sh
#!/bin/bash
#
# this is a sample backup script
#
export ORACLE_SID=db01
export ORACLE_HOME=/demo/oracle/db/9.0.1
#
# stop the listener
#
$ORACLE_HOME/bin/lsnrctl stop
#
# shutdown the database
#
$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect / as sysdba
shutdown immediate
exit
EOF
#
# backup the datafiles and control files
# modify the following commands to fit your backup strategy
#
cd /demo/oracle/db/oradata
tar -czvf db01.tar.gz db01
#
# startup the database
#
$ORACLE_HOME/bin/sqlplus /nolog << EOF
connect / as sysdba
startup
exit
EOF
#
# start the listener
#
$ORACLE_HOME/bin/lsnrctl start
# end of script
2. Test the backup script
# set the script permissions
$ chmod 755 backup.sh
# backup the database
$ ./backup.sh
# make sure you can recover the database with the backup
3. Schedule to run the backup script everynight
# edit the crontab
$ crontab -e
# add the following line
00 01 * * * /demo/oracle/backup.sh
# it schedules to run the backup script evertnight at 1:00 am
# modify it to fit your backup strategy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|