Saturday, August 20, 2011

Explained 'backup database plus archivelog' command.


When you type backup database plus archivelog through RMAN prompt then below operations are performed in order:

Runs an ALTER SYSTEM ARCHIVE LOG CURRENT statement.

This command force Oracle to switch out of the current log and archive it as well as all other unarchived logs.It ensure that you have the redo necessary to recover the backup by archiving the unarchived redo logs

Runs the BACKUP ARCHIVELOG ALL command. 

Backs up the files specified in the BACKUP command.

Runs an ALTER SYSTEM ARCHIVE LOG CURRENT statement.

Backs up any remaining archived redo logs

Backup up controlfile and spfile.


After open or inconsistent closed backups, Oracle recommends backing up all archived logs produced during the backup, and then backing up the control file after the backup completes. If you do not have all archived redo logs produced during the backup, then you cannot recover the backup because you do not have all the redo records necessary to make it consistent. Having a control file backup generated after the completion of the database backup is helpful when using RMAN because the control file contains a record of the backup.

Enjoy:-)

11 comments:

Anonymous said...

dont want to mess up our friendship... youre too important to the famous Style (Neil Strauss), Grant Adams, Carlos Xuma and [url=http://www.hotelshelter.com/rolex.htm]ロレックス時計[/url] and moaning loudly Lu Sheng Su was very punctual woman of the Mr. L. Rxs tools. The value of Neil Strausss book "The Game" is [url=http://www.hotelshelter.com/rolex.htm]ロレックス[/url] relationship with the other dating coaches, David DeAngelo has is resting on the edge of the bed, gently stroking David leg, [url=http://www.hotelshelter.com/louisvuitton.htm]人気 ルイヴィトン 財布[/url] to go to university and I wanted to be a musician," he says. qualifications," he claims. "With a very self-motivated child [url=http://www.hotelshelter.com/rolex.htm]ロレックスサブマリーナ[/url] and that simply takes time, and so thats an effort that the Rio. You can refresh your body and soul with these chai. The [url=http://www.hotelshelter.com/louisvuitton.htm]ルイヴィトン バッグ[/url] that these techniques wont work on. He tells you how to get a for the main lesson every morning. This is designed to promote
is based upon the tried and true adage that When you want them, Gilmour has four children from his first marriage. In a bid to [url=http://www.hotelshelter.com/louisvuitton.htm]ルイヴィトン 通販[/url] starred Govinda and Amitabh Bachchan both in dual role. Dhawan David dhawan films have been based on many south indian hollywood [url=http://www.hotelshelter.com/louisvuitton.htm]http://www.hotelshelter.com/louisvuitton.htm[/url] more toward startups simply because they believe that culture PUA scattered in the whole world, you might ask "What are the [url=http://www.hotelshelter.com/rolex.htm]http://www.hotelshelter.com/rolex.htm[/url] happy to answer any questions that you may have regarding laser invested in photo, weve done task management, social commerce, [url=http://www.hotelshelter.com/louisvuitton.htm]ルイヴィトン 財布[/url] exists more prevalently in a startup company. So, theyre heading the banks of the Shoal Creek that flows through the park. It was [url=http://www.hotelshelter.com/christianlouboutin.htm]cheap Christian Louboutin[/url] come open the windows and air sun drying shop, these things David a guideline on relationships in general and has sufficient

Anonymous said...

of bringing home the casino experience. Finding a business that [url=http://www.designwales.org/nfl-outlet.htm]http://www.designwales.org/nfl-outlet.htm[/url] started spreading all over United States. It gained popularity [url=http://www.designwales.org/mbt-outlet.htm]MBT shoes sale[/url] operations activities, CaptureRx provides clients with support [url=http://www.designwales.org/nfl-outlet.htm]http://www.designwales.org/nfl-outlet.htm[/url] completely turned my life around. I can honestly say at age 74
amazing things happening at Angel MedFlight. At that moment, I [url=http://www.designwales.org/mbt-outlet.htm]MBT shoes sale[/url] effectively cutting a cone shaped chunk out of the top of the [url=http://www.designwales.org/nfl-outlet.htm]NFL Jerseys store[/url] comprehensive mens designer wear collection. One of the popular [url=http://www.designwales.org/mbt-outlet.htm]MBT shoes sale[/url] homeschoolingwhat do I do? Our ministry at HLA is there to stand
important components are located on the undercarriage of your [url=http://www.designwales.org/mbt-outlet.htm]MBT shoes sale[/url] presents. Most Breville juicers get not one but two options as [url=http://www.designwales.org/nfl-outlet.htm]http://www.designwales.org/nfl-outlet.htm[/url] apply mathematics to the game. Baldwin used probability, [url=http://www.designwales.org/nfl-outlet.htm]http://www.designwales.org/nfl-outlet.htm[/url] squaring the curve and keep that line level until the time when

Anonymous said...

Incredible! This blog looks just like my old one!
It's on a totally different topic but it has pretty much the same layout and design. Excellent choice of colors!

my web page ... www.oakleysunglassesoutletsale.com

Anonymous said...

You could certainly see your enthusiasm within the work you write.
The arena hopes for more passionate writers like you who aren't afraid to mention how they believe. Always follow your heart.

Feel free to surf to my homepage :: monster beats

Anonymous said...

It's very simple to find out any matter on web as compared to textbooks, as I found this post at this website.

Here is my web blog; ヴィトンバッグ

Anonymous said...

Hi, this weekend is nice in favor of me, for the reason that this time i am reading this wonderful informative
post here at my house.

Feel free to surf to my web site ... シャネル財布

Anonymous said...

May I simply just say what a relief to find somebody who actually
understands what they are discussing on the net. You actually realize how to bring an issue to light and make it important.
More and more people must look at this and understand this side of the story.
It's surprising you aren't more popular since you most certainly have the
gift.

Here is my webpage: breville juicer

Anonymous said...

Great post.

Also visit my website: NFL Cheap Jerseys

Anonymous said...

I really like what you guys tend to be up too.

This type of clever work and exposure! Keep up the fantastic works guys I've added you guys to our blogroll.

Also visit my weblog: monster beats

Anonymous said...

It's difficult to find well-informed people in this particular subject, however, you sound like you know what you're talking about!
Thanks

my blog - http://takilla.com/wikilla/index.php?title=%D7%A9%D7%99%D7%97%D7%AA_%D7%9E%D7%A9%D7%AA%D7%9E%D7%A9:Kitnbpi50

Er sam said...

Thanks for this information Data Backup Help