Monday, May 7, 2012

Procedure to apply the PROD incremental backup based on the SCN of the DR


Procedure to apply the PROD incremental backup based on the SCN of the DR

Note: Change the contents as per your Database requirement

1. Take the current SCN of the standby database-------------------------------STANDBY DATABASE

SQL>select to_char(current_scn) scn from v$database;
384749165

2. Stop the redo apply on the standby database------------------------------STANDBY DATABASE

SQL> alter database recover managed standby database cancel;

3. Take the incremental backup of the production database from the current SCN of the standby database(Value from sep1)---PRIMARY


run {
allocate channel c1 type disk format '/u02/Temp/AYYUDB_incr_%T_%U' maxpiecesize 500m;
allocate channel c2 type disk format '/u02/Temp/AYYUDB_incr_%T_%U' maxpiecesize 500m;
backup as compressed backupset incremental from scn 384749165 database;
}


4. Transfer the incremental backup to the standby system

 $ scp /u02/Temp /*.* usename@standbyhost:/u02/Temp/

5. Create new standby controlfile at the production database, copy this to standby system and replace current standby controlfile with this new one.---PRIMARY DATABASE

SQL> alter database create standby controlfile as '/u02/Temp/AYYUDB_standby_incr.ctl';
 
6.scp the standby control file

7.scp the password file from primary to standby Database in default location(overwrite on DR)

8. startup nomount using new standby control file--------------------------------STANDBY DATABASE

9.Mount the standby database--------------------------------STANDBY DATABASE

10. Catalog all the incremental backup pieces to the standby database--------------------------------STANDBY DATABASE
RMAN> catalog start with '/u02/Temp';

11. Apply incremental backup to the standby database--------------------------------STANDBY DATABASE

RMAN> recover database noredo;

12 Start redo apply on the physical standby database--------------------------------STANDBY DATABASE

 SQL> alter database recover managed standby database disconnect from session;

13.Compare Log Sync from Primary & Standby Datababse

290 comments:

«Oldest   ‹Older   201 – 290 of 290
Anonymous said...

I got this site from my buddy who shared with me on
the topic of this site and now this time I am browsing this
website and reading very informative articles or reviews here.



Also visit my website Saphire Electronic Cigarette

Anonymous said...

It's awesome in favor of me to have a site, which is valuable in favor of my experience. thanks admin
sites to get free twitter followers

Anonymous said...

I'm extremely impressed with your writing abilities as well as with the structure on your blog. Is this a paid subject matter or did you customize it your self? Either way stay up the nice quality writing, it is rare to look a nice weblog like this one these days..

Feel free to visit my site slendertone evolution

Anonymous said...

My sis informed me about your website and how great it is. She’s proper,
I am really impressed with the writing and slick design.
It seems to me you’re simply scratching the floor in
terms of what you possibly can accomplish, however you’re off to an excellent begin!


Also visit my webpage trying to conceive tips

Anonymous said...

I'm not sure exactly why but this site is loading extremely slow for me. Is anyone else having this issue or is it a issue on my end? I'll check back later and see
if the problem still exists.

Here is my web blog; Buy Raspberry Ketone

Anonymous said...

You have made some good points there. I looked on the net for more info about the
issue and found most people will go along with your views on this web site.


Feel free to surf to my web blog; http://raspberryketonepurenow.com

Anonymous said...

We are a bunch of volunteers and starting a brand
new scheme in our community. Your website offered us
with valuable information to work on. You have done a formidable activity and our entire
community will be thankful to you.

Feel free to visit my website Buy Grow XL

Anonymous said...

You actually make it appear so easy along with your presentation however I find this matter to be actually something that I believe I might by no means understand.
It sort of feels too complex and extremely large for me. I am looking forward
for your next submit, I will try to get the hold of it!


Also visit my web-site LeParfait

Anonymous said...

I'm gone to inform my little brother, that he should also visit this website on regular basis to get updated from hottest news update.

My weblog http://testforcextremereview.net

Anonymous said...

I would like to thank you for the efforts you have put in writing this blog.
I am hoping to see the same high-grade blog posts
from you later on as well. In truth, your creative writing abilities has encouraged me to get my own, personal
blog now ;)

Also visit my weblog ... Building Muscle

Anonymous said...

Great post however , I was wondering if you could write
a litte more on this topic? I'd be very thankful if you could elaborate a little bit further. Appreciate it!

Also visit my web-site :: Skin care

Anonymous said...

Good day! I could have sworn I've visited this web site before but after going through many of the posts I realized it's new to me.
Regardless, I'm certainly happy I discovered it and I'll be bookmarking it and
checking back often!

Feel free to visit my web page - Pure GCE Diet

Anonymous said...

What i don't understood is actually how you're
no longer really much more well-appreciated than you may be right
now. You are so intelligent. You realize therefore considerably when it comes to this
subject, made me in my opinion imagine it from a lot of varied angles.
Its like women and men don't seem to be interested unless it is one thing to accomplish with Lady gaga! Your own stuffs great. All the time deal with it up!

Stop by my blog: Order Pur Essence

Anonymous said...

Heya i'm for the first time here. I came across this board and I find It truly useful & it helped me out a lot. I hope to give something back and aid others like you helped me.

My homepage: Saphire Ecigs

Anonymous said...

I'm really enjoying the design and layout of your site. It's a very easy on the eyes which
makes it much more pleasant for me to come here and visit more often.
Did you hire out a developer to create your theme?
Superb work!

Take a look at my weblog - by acai ultral lean

Anonymous said...

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

Feel free to visit my homepage :: Acai Ultra Lean Diet

Anonymous said...

Hurrah! After all I got a weblog from where I can truly take helpful information regarding my study and knowledge.


my webpage :: get money online

Anonymous said...

Attractive section of content. I just stumbled upon your website and in accession capital to assert that I get
in fact enjoyed account your blog posts. Any way I will be subscribing to your
augment and even I achievement you access consistently rapidly.


Also visit my web blog: Easy money

Anonymous said...

I rarely create responses, however I glanced through some comments
on "Procedure to apply the PROD incremental backup based on the SCN of the DR".
I do have 2 questions for you if you do not mind. Is it just me or does it seem like some of these comments
come across like they are coming from brain dead individuals?
:-P And, if you are writing on additional online social sites, I'd like to keep up with you. Could you make a list of all of your social networking sites like your Facebook page, twitter feed, or linkedin profile?

Feel free to surf to my blog - Buy pure garciniacambogia

Anonymous said...

Hi there friends, good article and good arguments commented at
this place, I am truly enjoying by these.

Here is my web-site :: weight loss

Anonymous said...

When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I
get four e-mails with the same comment. Is there
any way you can remove people from that service? Thank you!


My page :: http://dermaroseblog.com/

Anonymous said...

I relish, lead to I found just what I was looking for.
You have ended my four day long hunt! God Bless you man.
Have a great day. Bye

My homepage - Garcinia Cambogia ExtractGarcinia Cambogia HCA

Anonymous said...

Your style is really unique compared to other people I
have read stuff from. Thanks for posting when you
have the opportunity, Guess I'll just book mark this page.

Also visit my web-site ... Buy Anatomy X5

Anonymous said...

It's an awesome piece of writing in support of all the online people; they will take advantage from it I am sure.

Check out my website: Work From Home

Anonymous said...

That is really attention-grabbing, You're an excessively skilled blogger. I've joined
your feed and look forward to in the hunt for more of your fantastic post.
Also, I've shared your website in my social networks

Look into my website: Lost longer

Anonymous said...

Thanks for sharing such a nice thinking, post is nice, thats why i have
read it fully

Feel free to surf to my web-site - muscle building

Anonymous said...

Normally I do not read article on blogs, but I wish to say that this
write-up very compelled me to try and do it! Your writing style has been amazed me.
Thank you, quite nice article.

my website :: rvtlskincare.com

Anonymous said...

Definitely believe that which you stated. Your favorite justification appeared to be on
the web the easiest thing to keep in mind of.
I say to you, I certainly get irked while folks think about concerns that they plainly do not realize about.
You controlled to hit the nail upon the top and outlined
out the whole thing with no need side effect , other people could
take a signal. Will probably be again to get more.
Thanks

Feel free to surf to my site :: Automated pay days review

Anonymous said...

I'm not sure where you are getting your information, but good topic. I needs to spend some time learning much more or understanding more. Thanks for great info I was looking for this info for my mission.

Feel free to visit my homepage ... Garcinia Cambogia Diet

Anonymous said...

you're really a just right webmaster. The website loading speed is incredible. It kind of feels that you are doing any distinctive trick. Moreover, The contents are masterpiece. you have performed a fantastic task in this matter!

Feel free to surf to my web site; Buy 1285 and elevate GF

Anonymous said...

Hello to every body, it's my first pay a visit of this weblog; this web site contains amazing and in fact excellent material in support of readers.

my web page ... natural weight loss pills reviews

Anonymous said...

WOW just what I was searching for. Came here by searching for fat burning

My webpage loss weight now

Anonymous said...

Nice post. I learn something new and challenging on sites I stumbleupon everyday.

It will always be helpful to read through articles from other authors and practice
a little something from other web sites.

my web page :: Green tone pro

Anonymous said...

Great article. I will be facing many of these issues as well.
.

Here is my weblog: mw2 aimbot

Anonymous said...

Actually when someone doesn't understand after that its up to other people that they will help, so here it takes place.


Chronic profits list

Anonymous said...

Hello, I log on to your blog like every week. Your humoristic style is
awesome, keep it up!

My web page :: optimalstacks.net

Anonymous said...

Having read this I thought it was extremely enlightening.
I appreciate you taking the time and effort to put this informative article together.
I once again find myself spending a significant amount
of time both reading and posting comments. But so what, it was still worth it!


Feel free to surf to my weblog No2 maximus review

Anonymous said...

Greetings from Colorado! I'm bored to tears at work so I decided to check out your blog on my iphone during lunch break. I enjoy the knowledge you present here and can't wait to take a look when
I get home. I'm shocked at how fast your blog loaded on my phone .. I'm not even using WIFI, just 3G .
. Anyways, superb blog!

Stop by my site - Test Force Xtreme And Lean Muscle X

Anonymous said...

Hello! I've been following your site for a while now and finally got the bravery to go ahead and give you a shout out from New Caney Texas! Just wanted to tell you keep up the excellent work!

My webpage: Order Grow XL

Anonymous said...

It's sort of a storybook game, created from a child's dream anԁ filleԁ with whimsical аrtwork, and it
really teaches kids tο think strategically and mаke
сhοices based on a desiгeԁ outcome.
And, of course, the treasures can be аnythіng you can think of that would hаvе ѕignificant value wіthіn your pаrticular fаmily unit.
Τhe i - Pod Touch version hаs evеrything the original had,
frоm the tοp down viеw to thе funny characters.
The monster walks forward with the group following calling out
Fгankenstein are you аlive. Υou сan get mаnу options and ideas of оrgаnizіng
the party online.

my web page :: play games at school unblocked

Anonymous said...

Nice post. I learn something new and challenging on blogs I stumbleupon
on a daily basis. It's always interesting to read articles from other authors and practice a little something from other sites.

Check out my web page :: make cash online ()

Anonymous said...

In fact no matter if someone doesn't understand afterward its up to other viewers that they will assist, so here it occurs.


Test Force Extreme

Anonymous said...

Marvelous, what a blog it is! This webpage gives helpful
data to us, keep it up.

Have a look at my blog psn Code generator

Anonymous said...

It's hard to find well-informed people for this topic, but you seem like you know what you're talking about!
Thanks

Feel free to visit my blog post: workout stacks

Anonymous said...

Definitely believe that which you said. Your favorite reason appeared to
be on the web the simplest thing to be aware of. I say to you,
I certainly get annoyed while people think about worries that they just don't know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people can take a signal. Will likely be back to get more. Thanks

Visit my homepage ... unemployed loans

Anonymous said...

Tеrrіfic work! This is the kinԁ οf information that are
supposed to bе shаred arounԁ the wеb.

Shame on the seeκ engines for not positioning this put
up highеr! Cοme on oνer and ԁiscuss with my sіte .
Thank yοu =)

my blog ... storm 3D tattoos

Anonymous said...

bookmarked!!, I love your web site!

make money online

Anonymous said...

I simply could not depart your site prior to suggesting that I extremely loved the usual
information a person supply on your guests?
Is gonna be again ceaselessly in order to investigate cross-check new posts

Also visit my website :: Generateur de Code PSN

Anonymous said...

Hey! Someone in my Myspace group shared this website with us so I came to give it a look.
I'm definitely loving the information. I'm bookmarking and
will be tweeting this to my followers! Exceptional blog
and excellent design.

My website; get dragonvale

Anonymous said...

It's going to be ending of mine day, except before finish I am reading this wonderful article to increase my knowledge.

Feel free to surf to my web-site way to make money online

Anonymous said...

Aw, thіѕ was an extгеmely gooԁ post.

Taking а fеw minutеѕ and actual effоrt tο create a rеаlly good artiсlе… but what can Ӏ ѕаy…
I heѕitate a wholе lot and nеѵer ѕeеm tо get
anything dοne.

Hеre іs my web-site: click through the next page

Anonymous said...

If you are going for best contents like I do, only visit this site every day because it presents quality contents,
thanks

Feel free to visit my webpage - Payday Loans Online

Anonymous said...

Do you havе a spаm problem on this blog; I also am
a bloggег, аnd I ωas wondеring your situаtion; many of us haνe cгеated some nice methodѕ anԁ we
are lοoking to ѕwap technіquеs with other folks,
be sure to shoot me an e-mаіl іf inteгested.



Have а look at my pаgе; Should you be considering to go to The european countries

Anonymous said...

Vеrу shοrtly this wеb page will
be famous amοng all blogging аnd sіte-building
visitors, duе tο it's nice posts

Feel free to surf to my web blog - Motels In Stansted airport

Anonymous said...

This design is wicked! You certainly know how to keep a reader amused.
Between your wit and your videos, I was almost moved to start my own blog (well, almost.
..HaHa!) Great job. I really enjoyed what you had to say, and
more than that, how you presented it. Too cool!


Here is my web-site ... Order Androsolve

Anonymous said...

I do not leave a ton of responses, however i did a few searching and wound up here "Procedure to apply the PROD incremental backup based on the SCN of the DR".

And I actually do have 2 questions for you if it's allright. Is it simply me or does it look as if like a few of these responses look as if they are written by brain dead people? :-P And, if you are posting on additional social sites, I would like to keep up with anything new you have to post. Could you make a list of all of all your social pages like your Facebook page, twitter feed, or linkedin profile?

Look into my homepage African Mango Review

Anonymous said...

wonderful points altogether, you just won a new reader.
What may you suggest in regards to your publish
that you just made some days ago? Any positive?


build muscle now

Anonymous said...

online dating site in australia http://loveepicentre.com triplex dating
dating vietnamese tuvi [url=http://loveepicentre.com/faq/]dating chiefland florida[/url] airline pilot dating site
dating customs [url=http://loveepicentre.com/advice/]dating for big beautiful black women[/url] hogan wife dating [url=http://loveepicentre.com/user/marybaby200/]marybaby200[/url] canada stockings dating

Anonymous said...

dating customs in sudan http://loveepicentre.com/faq/ indian dating personals
free online dating services for teens [url=http://loveepicentre.com/contact/]adult on line dating[/url] free online games dating
kate gosselin dating show [url=http://loveepicentre.com/articles/]fat guy dating sites[/url] who is kenny chesney dating [url=http://loveepicentre.com/user/devosnmith11/]devosnmith11[/url] antique photo restoration and dating

Anonymous said...

It's a pity you don't have a donate button! I'd most certainly donate to this brilliant blog! I suppose for now i'll settle for bookmarking and adding your RSS feed
to my Google account. I look forward to fresh updates and will share this blog with my Facebook group.
Chat soon!

Feel free to surf to my web blog no2 maximus ()

Anonymous said...

My brothеr suggested I mіght like this web sіte.
He wаs onсe totally гight. This ρost truly made my day.
You cаn not іmаgine simply how much
time ӏ had spent for this іnformation!
Thank you!

Loοk into my website - Search For Marriage ceremony Resorts On the net Now

Anonymous said...

Hey There. I found your blog using msn. This
is a very well written article. I will make sure to bookmark it
and return to read more of your useful information.
Thanks for the post. I'll definitely comeback.

My homepage Discount rolex watches

Anonymous said...

Thanks on your marvelous posting! I quite enjoyed reading it, you will be a great author.

I will make certain to bookmark your blog and will eventually come back later in life.
I want to encourage continue your great writing,
have a nice evening!

my web blog; Rolex watches

Anonymous said...

Admiring the commitment you put into your site and in depth information you
offer. It's good to come across a blog every once in a while that isn't the
same out of date rehashed information. Wonderful read!
I've bookmarked your site and I'm including your
RSS feeds to my Google account.

buy testostrong

Anonymous said...

Great work! That is the type of information that should
be shared around the web. Disgrace on Google
for now not positioning this publish higher! Come on over and discuss with my site .
Thank you =)

Le Parfait

Anonymous said...

Hi! I've been following your site for some time now and finally got the courage to go ahead and give you a shout out from Huffman Texas! Just wanted to say keep up the excellent job!

my weblog ... Cheap Hotels throughout Portugal ()

Suseela said...




What an awesome post, I just read it from start to end. Learned something new after a long time.



Manual testing training in Chennai


Selenium testing training in Chennai

deeksha said...

This blog is really nice and very much interesting it is very well done and very useful too to understand the concepts.

Informatica Training in Chennai

deeksha said...

This blog is very well done and it is very well exclusive , thus it is very much helpful and useful too. thanks for sharing these kind of information.


cognos Training in Chennai

Unknown said...

Really i enjoyed very much. And this may helpful for lot of peoples. So you are provided such a nice and great article within this.

Best Dental Clinic In Adyar

sathya said...

This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.

MSBI Training in Chennai

Anonymous said...

Interesting blog which attracted me more.Spend a worthful time.keep updating more.
Digital marketing company in Chennai

jeje said...

nike mercurial vapor
golden goose
longchamp longchamps
adidas yeezy
jordan 12
adidas store
air jordan 12
vans shoes
adidas tubular UK
lacoste outlet

jeje said...

nike huarache
nike huarache sale
yeezy boost 350 v2
nike roshe one
yeezy shoes
gucci belts for men
nike air max 2017
pandora bracelet
air jordans
air max 90

Unknown said...

Past the tour-de-force of acting, the sets and locations are exquisitely detailed and capture both the claustrophobic feeling of being caught on a ship in the wilderness to what seems like the endless expanse of the ice of the arctic. I'd like to point a particular detail that stood out to me. happy death day movie


In episode two a smaller expedition leaves Royal Navy issued notes of the kind of "Whomever may find this..." in a desperate effort to both reach and be reached by the outside world. The letter contains translations to every language of every nation that mattered in the age of sail. I already find this a masterful detail that is unusual in Anglo-Saxon productions in general, and American productions in particular. the devils candy


But what's more, the translations are written in the language appropriate for the age. Being Dutch, to find in that letter the correct use of 19th century Dutch was a small but delightful detail - and indicative of the rest of the series' attention to both the big and the small. watch Avengers Infinity War online

Two episodes in and I am certainly hooked. This is Ridley Scott at his finest, and to be honest didn't expect him to get back into form after the disasters that were his last two Alien movies. Even with being one wikipedia consultation away from knowing the outcome of this story, it is a gripping, haunting series which leave you curious what will happen next.

Unknown said...

Thank you very much for accepting the comment
شركة مكافحة النمل الابيض بالرياض|شركة مكافحة الفئران بالرياض|
كفاة الاعمال المنزلية من خدمة تنظيف اومكافحة للحشرات او مزيد من الخدمات تفضل الرابط التالى
ارخص شركة تنظيف منازل بالرياض
شركة تنظيف ستائربالرياض
شركة تنظيف فلل بالرياض
شركة تنظيف موكيت بالرياض
شركة تنظيف سجاد بالرياض
افضل شركة غسيل سجاد بالرياض
شركة تنظيف مكيفات بالرياض

ganga said...

I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

angularjs2-Training in sholinganallur

angularjs4-Training in sholinganallur

angularjs-Training in annanagar

angularjs2-Training in annanagar

angularjs4-Training in annanagar


LENIN said...

I am really impressed with your efforts and really pleased to visit this post.
Data Science training in Chennai | Data science training in bangalore
Data science training in pune| Data science online training
Python training in Kalyan nagar

Mounika said...

Useful information.I am actual blessed to read this article.thanks for giving us this advantageous information.I acknowledge this post.and I would like bookmark this post.Thanks
online Python certification course | python training in OMR | python training course in chennai

Unknown said...

hank you for benefiting from time to focus on this kind of, I feel firmly about it and also really like comprehending far more with this particular subject matter. In case doable, when you get know-how, is it possible to thoughts modernizing your site together with far more details? It’s extremely useful to me 
java training in jayanagar | java training in electronic city

java training in chennai | java training in USA

Sheela said...

Thank you for allowing me to read it, welcome to the next in a recent article. And thanks for sharing the nice article, keep posting or updating news article.
Devops Training courses
Devops Training in Bangalore
Best Devops Training in pune
Devops interview questions and answers

Bytes Computer Centre said...


Very Nice and Informative Article. Share something onEmail Data Recovery

Richardsilverstein said...


Hope many ppl come in here and get the most out of this ... keep going buddy, may god bless you .RichardsilversteinThanks for you sharing

All Bio said...

Đâu là cách đánh lô ngày nào cũng trúng nhất hiện nay? Để có được thông tin chuẩn xác nhất cho điều này, bạn tham khảo những chia sẻ sau đây của chúng tôi. cach danh lo ngay nao cung trung

yanmaneee said...

air jordan
jordan 12
yeezy boost
yeezy
hermes
golden goose
lebron shoes
golden goose sneakers
golden goose
nike x off white

Abu fateh said...

I read the post it is a very good post . Its really nice post. I hope its useful to everyone . https://edufy.club/

Jaff Parker said...
This comment has been removed by the author.
Custom Packaging Solution said...
This comment has been removed by the author.
Anonymous said...

jordan shoes
supreme clothing
moncler outlet
hermes handbags
supreme clothing
palm angels
supreme hoodie
off white hoodie
bape sta
kyrie 7

Anonymous said...

fear of god outlet
jordans
kyrie shoes
golden goose sneakers
yeezy boost 350
fear of god
air jordan
supreme outlet
golden goose sneakers
jordan 4

«Oldest ‹Older   201 – 290 of 290   Newer› Newest»