Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Script to do cold backup using rman

Posted on 2008-10-22
6
962 Views
Last Modified: 2013-12-26
Hi experts,

Can any one of you please share the shell script to do a cold backup using rman on 10G database.

The script need to check the SID
The script need to do the initial checks like...
status of the database -- open/close/mounted....
status of the backup / is it running or not... if it is running then the script should not kick off again.
Place the database in mount state , take the backup to disk and then open the database and report any errors if occured...

Thanks for your help.
0
Comment
Question by:blazin_sun
  • 3
6 Comments
 

Author Comment

by:blazin_sun
ID: 22787443
Any one can you  please provide me the script.
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 250 total points
ID: 22824305
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 22824318

PS: I'm sure you can figure out the rest.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 25187515
The correct answer was provided by the link to the solution, all the OP had to do is write his(her) custom script  "wrapper" based on the solution.
 
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over the years I've spent many an hour playing on hardened, DMZ'd servers, with only a sub-set of the usual GNU toy's to keep me company; frequently I've needed to save and send log or data extracts from these server back to my PC, or to others, and…
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question