backup Script

All posts relating to Oracle database administration.

Moderator: Tim...
Senior Member
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

backup Script

Postby » Fri Sep 21, 2012 5:35 pm

Hi Tim,

Please provide me the rman backup script.

Please suggest me if the following is correct or not.

Is the following one hot backup?

My doubt is can we put database in mount mode for hot backups ,when the database is up and running ?

startup mount;
Backup Database Plus archivelog;
sql ' Alter database open';
sql ' Alter database backup controlfile to trace';

Thanks in advance.


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: backup Script

Postby Tim... » Fri Sep 21, 2012 6:28 pm


The whole point of a hot backup is the database is running at all time, so as soon as you see anything with "startup" in it, or "alter database open", you know you are not dealing with a hot backup.

Backup and recovery is to important an area to try and skim through. You have to hit the books and understand it. One failed backup and you've potentially lost your job!

Start here: ... ger-9i.php

Read all the enhancements articles it lists for newer DB versions. When you understand the points in these articles, you will be ready to consider going near a backup. You will still not be an expert and you will still have a long way to go, but you will be at the start of beginner level. Before then, you are dangerous and shouldn't attempt to do anything with backups!


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests