Light

tagar / rman Goto Github PK

View Code? Open in Web Editor NEW

23.0 6.0 17.0 47 KB

Shell script to run scheduled Oracle RMAN backup scripts for various usage scenarios

Shell 100.00%

rman's Introduction

Shell script to run scheduled Oracle RMAN backup scripts for various usage scenarios.

Using Data Guard and want backups to run normally only on Standby database? What if DG apply process is behind? Oh, now do you want to run backups from Primary database? Or maybe you're having a RAC database and want to easily schedule non-competing backups that would run even if you lose any number of cluster nodes? Maybe you're using some backup solutions like Commvault or Tivoli, or just dump backups to FRA?

This script will help to address above scenarios or combinations of those. It will notify you of daily backup results, or of any problems that may happen.

Setup is as easy as downloading files from this repository into your servers; adding a few entries to crontab (e.g.one to call rman_backup.sh for database backups, another for archived logs, plus crosscheck weekly or any other schedule that works for you better). Also, review rman_backup_vars.sh script if there are any changes are required for your environment.

I'd be happy to receive feedback. Found a bug? Please submit it here - https://github.com/Tagar/rman/issues Also, feel free to contribute your changes to this repository.

rman's People

Contributors

Stargazers

Watchers

Forkers

opdl poornimaa kranskydog cilesiz xiang-lawrence srjayep iniunet thisismython jampaniuday narendratreddi enrique2k global-localhost global19 global19-atlassian-net yuanduobao mgiay mkaladi

rman's Issues

Incorrect rman renicing output in Linux

INFO: Reniced Oracle processes participating in RMAN backup to lower priority.
List of RMAN related processes with PIDs 4793,4794\c,:
released channel: ch1

wouldn't renice rman processes

Log file:
INFO: Reniced Oracle processes participating in RMAN backup to lower priority.
List of RMAN related processes with PIDs 6010,6011:
PID NI USER TIME COMMAND COMMAND
6010 15 oracle 00:00:00 oracle oraclehpotst (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
6011 15 oracle 00:00:00 oracle oraclehpotst (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

Stderr has:
ddc-oraprd-db1b:oracle:hpotst> /home/oracle/rman/rman_backup.ksh ARCH hpotst
renice: 15: setpriority: Operation not permitted
renice: 6010: setpriority: Permission denied
renice: 6011: setpriority: Permission denied

Probably Linux porting related.

script connect and disconnects / as SYSDBA in the dosql routine, even when SYSDBA privilege is not required. Login is expensive and connecting as SYSDBA is audited

"The script connect and disconnects / as SYSDBA in the dosql routine, even when SYSDBA privilege is not required. Login is expensive and connecting as SYSDBA is audited" from https://community.oracle.com/message/12596701#12596701

make all global variables that are being reset after each database lower case

Make all global variables that are being reset after each database lower case.

So it'll be possible to clear them with a simpler version of reset_global_vars() rather than listing all those variables. It looks cleaner too.

Add support for RAC One Node

Like RAC, but should run only on one node where a RAC One Node instance is currently running

Backup into an FS

hi ,

my understanding is the script backups the database into FRA , what if i want to backup the database to a filesystem even if the FRA is enabled and configured ?

Regards,
Sam

Solaris fix

"The script doesn't even work on Solaris, as it hardcodes ORATAB to /etc/oratab. In Solaris, the location is not /etc/oratab"

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.