backup Script

All posts relating to Oracle database administration.

Moderator: Tim...

backup Script

Postby adda.road@yahoo.com » 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.

Rampa
adda.road@yahoo.com
Senior Member
 
Posts: 143
Joined: Thu Dec 08, 2011 12:33 am

Re: backup Script

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

Hi.

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: http://www.oracle-base.com/articles/9i/ ... 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!

Cheers

Tim...
Tim...
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: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 7 guests