Hi,
Does any1 have a script for a db on sun machine that takes backup by shutting down the db,if its mounted..and take the backup and after the backup has been taken strats the db again?
version:8.1.7
thanx
Printable View
Hi,
Does any1 have a script for a db on sun machine that takes backup by shutting down the db,if its mounted..and take the backup and after the backup has been taken strats the db again?
version:8.1.7
thanx
Hi
write a cron job to execite dbshut and the write your databse to tape or wherever and then execute dbstart
su - oracle -c dbshut
{perform backup}
su - oracle -c dbstart
"make sure you have set your database to shutdown abd startup automaticaly in the /etc/oratab file.
ie {SID}:{ORACLE_HOME}:Y
There are a ton of great backup scripts at http://dbasupport.com/oracle/scripts...y/Cold_Backup/