- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: oracle backup
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-25-2008 11:56 PM
тАО03-25-2008 11:56 PM
oracle backup
thanks all
we are running the rman script for backup
for full and incremental backup.
every time we have to run manually the script
like run {execute script full_backup:}
how we can automate this on OS level
or there is any other script available which will help
thanks
shabir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2008 01:16 AM
тАО03-26-2008 01:16 AM
Re: oracle backup
You can automate this in two ways.
1. Using the OEM database control
2. Using the cron
For 1. goto http://
then to the "Maintenance" tab, configure the RMAN settings in the "Backup/Recovery" and "Backup/Recovery Settings" sections.
(if you need any further assitance, please let us know)
For 2. create a crontab entry as follows:
#*******************************************************************************
# min|hour |day |month|day | |script
# | |of mo| |of wk| |
#----|-----|-----|-----|-----|-------|-----------------------------------
#*******************************************************************************
59 23 * * * echo "/home/yogeeraj/admin/scripts/oracle/rman/rman_full.sh;exit"|su - oracle 1>/home/yogeeraj/admin/logfiles/oracle/output-rman_full.crn 2>/home/yogeeraj/admin/logfiles/oracle/error-rman_full.crn
#
#*******************************************************************************
# END OF TABLE day0->Sunday day6->Saturday
#*******************************************************************************
The above example is for the crontab of the superuser (root) and assuming that your rman script works correctly when run under the Oracle user.
Hope this helps!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2008 03:23 AM
тАО03-26-2008 03:23 AM
Re: oracle backup
thanks lot
we are using folowing rman script
12] % rman catalog=rman/rman target=sys/redhat
Recovery Manager: Release 10.2.0.3.0 - Production on Wed Mar 26 16:50:16 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: CIEHO (DBID=103616347)
connected to recovery catalog database
RMAN> print script full_backup
2> ;
printing stored script: full_backup
{configure channel device type 'sbt_tape' clear;
configure controlfile autobackup on;
configure backup optimization on;
configure retention policy to recovery window of 7 days;
backup
format 'bk_%d_%u_%s_%p'
incremental level 0 tag ='FULL_BACKUP' database filesperset 2;
sql 'alter system switch logfile';
sql 'alter system archive log current';
backup
format 'arc_%d_%u_%s_%p'
archivelog all;
DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-7';
}
How this script BE scheduled throgh cron tab
thanks
shabir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2008 08:05 PM
тАО03-26-2008 08:05 PM
Re: oracle backup
First of all you will need to create a shell script that you can later schedule using the CRON.
e.g. rman_full.sh
#!/bin/sh
#Script Name: rman_full.sh
#Description: Incremental backup of database and archived redolog files
messagelog="/home/yogeeraj/scripts/oracle/rman/logfiles/rman_full-$(date +%d%m%y-%H%M).log"
export NLS_DATE_FORMAT='dd-Mon-yyyy HH24:mi:ss'
rman target target sys/redhat rcvcat rman/rman@catdb.mydb.mu msglog $messagelog <
run {
full_backup;
}
exit;
EOF
Question: What is the size of your database?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-26-2008 08:08 PM
тАО03-26-2008 08:08 PM
Re: oracle backup
First of all you will need to create a shell script that you can later schedule using the CRON.
e.g. rman_full.sh
#!/bin/sh
#Script Name: rman_full.sh
#Description: Incremental backup of database and archived redolog files
messagelog="/home/yogeeraj/scripts/oracle/rman/logfiles/rman_full-$(date +%d%m%y-%H%M).log"
export NLS_DATE_FORMAT='dd-Mon-yyyy HH24:mi:ss'
rman target target sys/redhat rcvcat rman/rman@catdb.mydb.mu msglog $messagelog <
run {
full_backup;
}
exit;
EOF
Question: What is the size of your database?
revert
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2008 03:46 AM
тАО03-27-2008 03:46 AM
Re: oracle backup
thanks lot
We copy u script and created .sh file like
/script/rman_full.sh
#!/bin/sh
#Script Name: rman_full.sh
#Description: Incremental backup of database and archived redolog files
messagelog="/home/shabir/scripts/oracle/rman/logfiles/rman_full-$(date +%d%m%y-%H%M).log"
setenv NLS_DATE_FORMAT='dd-Mon-yyyy HH24:mi:ss'
rman catalog=rman/rman target sys/redhat msglog $messagelog
<
run {
execute script full_backup;
}
exit;
EOF
* kindly see if there is any changes required
pls confirm we have to run this script under oracle user
and what should be the ownership and permission to script file.
* total size of database is 300gb
thanks
shabir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2008 09:24 PM
тАО03-27-2008 09:24 PM
Re: oracle backup
pls waiting u update
thanks
shabir
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2008 09:37 PM
тАО03-27-2008 09:37 PM
Re: oracle backup
>Your script
Looks ok. You can as well try to run it manually (using the oracle user) before scheduling it.
> pls confirm we have to run this script under oracle user and what should be the ownership and permission to script file.
The Oracle user should have execute permissions. You may as well change the file ownership to oracle:dba
e.g. (chown oracle:dba /script/rman_full.sh)
# ll /script/rman_full.sh
-rwxr-xr-x 1 oracle dba 1383 Mar 6 14:24 /script/rman_full.sh
#
>total size of database is 300gb
have you considered doing an increamental merge backup? I think it would be more efficient for you.
What about the nice RMAN compression features?
revert.
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-27-2008 09:53 PM
тАО03-27-2008 09:53 PM
Re: oracle backup
Note that RMAN (10G) now allows Fast Incremental Backups.
It backups up only those blocks that have changed since a previous backup.
Obviously, this brings along the following benefits:
i. Reduced disk space usage (since smaller backup-pieces generated)
ii. Faster backup
Also, note that Oracle 10g offers a new feature, called block "Change Tracking".
This feature allows for faster incremental backups.
With the help of a "tracking file", the database level block changes are tracked and Oracle logs changes to the blocks in this tracking file. And then during the incremental backup, RMAN reads the tracking
file to determine changed blocks. This obviates the need to read each and every block in a datafile and thus results in faster incremental backups.
hope this helps too!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-28-2008 09:34 PM
тАО03-28-2008 09:34 PM
Re: oracle backup
thanks for u valuable inputs
pls find below the script
#!/bin/sh
#Script Name: rman_full.sh
#Description: Incremental backup of database and archived redolog files
messagelog=" +%d%m%y-%
H%M).log"
setenv NLS_DATE_FORMAT 'dd-Mon-yyyy HH24:mi:ss'
rman catalog=rman/rman target sys/redhat msglog $messagelog
<
run {
execute script full_backup;
}
exit;
EOF
out put executing under oracle user
#!/bin/sh
#Script Name: rman_full.sh
#Description: Incremental backup of database and archived redolog files
messagelog="/home/shabir/scripts/oracle/rman/logfiles/rman_full-$(date +%d%m%y-%
H%M).log"
setenv NLS_DATE_FORMAT 'dd-Mon-yyyy HH24:mi:ss'
rman catalog=rman/rman target sys/redhat msglog $messagelog
<
run {
execute script full_backup;
}
exit;
EOF
which steps fails this script
what should be permission of
/home/shabir/scripts/oracle/rman/logfiles/rman_full-$(date
thanks
shabir