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 ?
Backup Database Plus archivelog;
sql ' Alter database open';
sql ' Alter database backup controlfile to trace';
Thanks in advance.
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: https://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!
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 2 guests