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:-)

13 comments:

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

Unknown said...

Thanks for this information Data Backup Help

5689 said...

zzzzz2018.8.31
coach outlet
canada goose outlet
air max 90
nike factory outlet
nike huarache
christian louboutin sale
tods shoes
ugg boots on sale 70% off
tory burch handbags
adidas outlet online

Unknown said...

golden goose outlet
fila sneakers
adidas stan smith
golden goose sneakers
paul george shoes
yeezy boost 350
fila
yeezy boost 350
jordan sneakers
nike epic react

yanmaneee said...

nike sneakers
nike max
retro jordans
balenciaga shoes
kanye west yeezy
supreme new york
timberland boots
nike lebron 16
lebron 17 shoes
kd 11

Unknown said...

replica bags online shopping india replica bags us replica bags in dubai