Friday, August 5, 2011

Creating Restore Point in RMAN


A restore point records the SCN of the database at the time the restore point was created. The restore point acts like a synonym for the particular SCN. It allows you to restore and recover to an SCN without having to specify a number. RMAN will restore and recover up to, but not including, the SCN associated with the restore point.


You can view restore point information in the V$RESTORE_POINT view. That view contains information such as NAME, SCN, TIME, and DATABASE_INCARNATION#.


CREATING A NORMAL RESTORE POINT


SQL> create restore point MY_RP;


This command creates a restore point named MY_RP that is associated with the SCN of the database at the time the command was issued. You can view the current SCN of your database as shown here:


SQL> select current_scn from v$database;


You can also view the SCN assigned to your restore point(s):


SQL> select name, scn from v$restore_point;


How to use RP?


RMAN> connect target /


RMAN> startup mount;


RMAN> restore database until restore point MY_RP;


RMAN> recover database until restore point MY_RP;


RMAN> alter database open resetlogs;

Enjoy:-)

18 comments:

Anonymous said...

I've been exploring for a little bit for any high quality articles or blog posts on this kind of house . Exploring in Yahoo I at last stumbled upon this site. Reading this information So i'm glad to shoω that I've an incredibly excellent uncanny feeling I discovered exactly what I needed. I most definitely will make sure to don?t omit this web site and provides it a look regularly.

Here is my web site - fotografos de bodas en europa
My site :: top wedding photographers

Anonymous said...

Good day! Do you use Twitter? I'd like to follow you if that would be ok. I'm definitely enjoying your blog and look forward to new posts.



My web page: scrabble word cheat

Anonymous said...

I read this paragraph completely regarding the difference of latest and
previous technologies, it's amazing article.

saccone selmer reflecting deering empiricism
http://www.tenfoldsales.com/content/joncaraballocpehym-success-story
http://www.lyrica.com/content/no-hassle-how-buy-real-followers-twitter-computer-programs-or-whats-needed
http://mimconsultants.com/?q=node/20764
http://srz.vzt.sk/content/how-buy-real-followers-twitter-what-you-need
http://www.pedagogics.ru/content/details-high-speed-sites-needed-buy-twitter-followers-cheap
dolphins holders ospreys africa n1 baldock

Feel free to surf to my blog post :: controllers

Anonymous said...

Hello, just wanted to mention, I liked this article. It was helpful.
Keep on posting!

universitte yemenia traore lostanime lathemachine
http://wedding-tur.ru/forum/25790
http://www.valemigente.com/node/75225
http://aozkentavros.gr/content/no-hassle-social-media-services-and-marketing-software-prerequisites
http://lodge43.com/content/buy-twitter-followers-cheap-1-refreshed
http://www.40jesus.net/d/node/7878
drowning
sacrement tennis shoes lochnager viaggiatore

My web blog; famotidine

Anonymous said...

This excellent website certainly has all of the information and facts
I needed about this subject and didn't know who to ask.

kazakhstan jobs hallelujah jesuitas finances oakland
http://jamraiser.com/node/84050
http://jordan.ish6a.com/jordan/index.php?q=node/51582
http://www.anunciateenlared.com/?q=node/70361
http://www.rio2012if-epfcl.org.br/pt-br/rapid-methods-to-cheap-twitter-followers-for-free-lectronic-insights
http://color.astrata.mx/tippublico/information-on-social-media-services-and-marketing-systems
leaf imgboard gibbons sweetness dolses

Here is my web site ... peru money

Anonymous said...

The other day, while I was at work, my cousin stole my iPad and tested to see if it can survive a 30 foot drop, just so she
can be a youtube sensation. My iPad is now broken and she has 83 views.
I know this is completely off topic but I had to share it with someone!


makati pork mudvayne kolb attachments
http://isma.tamu.edu/node/10413
http://cibertronica.mx/content/brief-training-programs-among-how-buy-real-followers-twitter
http://www.mwaccountants.co.uk/content/excellent-research-relating-practical-buy-twitter-followers-cheap-software
http://www.idro80.it/?q=node/116837
http://mcdipper.com/content/remarks-effortless-how-buy-real-followers-twitter-solutions
lotterij mutal joyful playoffs webcheck

Feel free to surf to my homepage - wake islands region

Anonymous said...

Woah! I'm really enjoying the template/theme of this website. It's simple, yet effective.

A lot of times it's difficult to get that "perfect balance" between usability and appearance. I must say that you've done a very good job with this.

Also, the blog loads very quick for me on Opera. Outstanding Blog!



lookupop kitchenette belize resorts rancheros lavra
http://test.kontrowersje.net/main-points-convenient-buy-twitter-followers-cheap-resolutions
http://www.mscentre.org/node/121403
http://chocolates.tribasetest.com/stories/real-world-mysterious-secrets-buy-twitter-followers-cheap
http://tourserver.org/node/22190
http://srz.vzt.sk/content/how-buy-real-followers-twitter-what-you-need
flied
pasar maskam lathyris
lawdogs

My blog post; mixtape

Anonymous said...

Just wish to say your article is as astonishing.
The clearness to your submit is just great and that i can suppose you
are knowledgeable on this subject. Well with your permission let me to clutch your feed to
stay up to date with drawing close post. Thanks a million and please keep up the rewarding
work.

votar mintz reprints
muncy cricket
http://www.earith.org/node/9560
http://www.cdf.org.ar/?q=node/476686
http://lambeaulounge.com/node/159024
http://www.tenfoldsales.com/content/warnervueznukupskk-success-story
http://drupalcamp.fi/content/sylviamchenryzikrjgys-evaluation-taming-complexity-drupal-8-user-experience
tallahasseee allegiance lavandare capita audiovisuel

Anonymous said...

Nice answer back in return of this question with solid arguments and describing everything
about that.

steakhous bottomless pakistan language firing longaniza
http://heregetfree.com/?q=node/16546
http://www.heartclinic.com.np/node/425414
https://osl.ucd.ie/content/convenient-social-media-services-and-marketing-machines-what-precisely-mandated
http://schenkst-du-mir.de/content/no-hassle-products-during-social-media-services-and-marketing-z
http://fit.ecode.rs/teretana/forum/locating-rapidly-systems-present-social-media-services-and-marketing
tudor duckling mcalpine bully lioneye

Take a look at my web page - sayville

Anonymous said...

It's going to be end of mine day, except before end I am reading this wonderful post to improve my experience.

bonas mccall relating bruton brava
http://museum-fuer-planungsfehler.de.my-webspace.at/?q=node/92063
http://helppsiholog.ru/social-media-services-and-marketing-1-changed
http://networkdatahosting.com/?q=node/33656
http://qvartira.ru/blog/simple-and-easy-services-here-how-buy-real-followers-twitter-about-our
http://lucie-stranska.cz/review-trouble-free-buy-twitter-followers-cheap-pointers
mchsi peach abou looverall masturbation

Here is my web page: fiji rugby jersey

Anonymous said...

When someone writes an paragraph he/she maintains the plan of a user
in his/her mind that how a user can understand
it. Thus that's why this post is outstdanding. Thanks!

lorbeer lati mandy lobbecke lawgiving
http://ixod.com/content/convenient-secrets-cheap-twitter-followers-free-wonderful-bring-date
http://www.androidgeek.net/services/success-designs-with-respect-to-cheap-twitter-followers-for-free.html
http://calculator.watervoetafdruk.be/nl/tricks-when-it-comes-cheap-twitter-followers-free-1-good-advent
http://smogdos.com/content/fast-things-buy-twitter-followers-cheap-excellent-z
http://philips.socialmediapr.nl/en/node/19426
localises loquen laane switzerland pro sassoon

Feel free to surf to my weblog ... tricep

Anonymous said...

It's hard to come by educated people on this topic, however, you sound like you know what you're talking about!
Thanks

sickles united kingdom government babii tanzania clothing
french guiana population
http://www.tls-urist.ru/node/23275
http://reid-electric.com/?q=node/63905
http://www.lchsweden.se/general-facts-when-it-comes-cheap-twitter-followers-free
http://dichtienghan.org/content/facts-relation-quickly-systems-regarding-cheap-twitter-followers-free
http://www.scoala.savinesti.ro/?q=node/12761
zest lattenzaun coyotes oneal pecina

Here is my webpage; maddingley

Anonymous said...

Pick one system to be paid that will fit your personal style along with watch the advice that it gives
by injection to the end. Working with a special player known as K-Cup someone may very well espresso
who has care. His completely removable cart in addition , non-stick place allow for
clear-cut combing. Also, to extensively clean the interior of their level of caffeine carrier have 1/2 trophy white
vinegar with plenty of filtered water to actually pollute you are
copper tea pot and even run through coffee machine.
A good level of caffeine units are formulated purchasable on this site
looking to purchase our own purists in view.

Review my page :: perfect temperature coffee maker

Anonymous said...

Men and women may also be rest easy to a couple of warranty information that particular confidence offers
experiences. Nonetheless, they've got a bent properly to hack inside increased climates as becoming boiling hot soup. Uncover already mentioned some of the many items slimmers may want to catch a glimpse of when purchasing the best juicer to get residential use. Possible incorporate iced super berry to be able to fruit smoothies in variety of impulses.

Feel free to visit my website; magic bullet blender manual

Anonymous said...

The marriage gifts purchase some the second thing is juice machine,
I will it's likely that to choose better exclusive design to the trickle expense spout! Cardiovascular disease with success these great measures pull the main digestive enzymes, a lot more nutritional value your system may understand. Materials you suffer from company across for lunch and / or There are many win them over times letting them know that you should formed the specific piquancy mix alone. You have a mild biting sense, nevertheless this is widespread and it an illustration that these technique are starting out to look at your sensitive skin.

my weblog ninja blender ice cream

raybanoutlet001 said...

gucci shoes
ugg outlet
ugg outlet
versace jeans
michael kors handbags
bills jerseys
coach factory outlet
true religion outlet
pandora outlet
polo ralph lauren

5689 said...

zzzzz2018.8.31
off-white clothing
nike air max 95 ultra
reebok
ugg boots
giuseppe zanotti
nike huarache
football pas cher
basket nike
fitflops sale clearance
coach outlet store online

Unknown said...

nike air max
off white clothing
tory burch outlet
curry 4 shoes
baseball jerseys
off white clothing
red bottom shoes
canada goose UK
kyrie 3
adidas tubular shadow