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#.


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;



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
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
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
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
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
pasar maskam lathyris

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

votar mintz reprints
muncy cricket
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
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
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
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!

sickles united kingdom government babii tanzania clothing
french guiana population
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

Zheng junxai5 said...

louis vuitton outlet
adidas superstar
ray ban eyeglasses
kobe 8
burberry outlet online
coach outlet clearance
replica watches
gucci bags
basketball shoes
coach factory outlet
coach outlet clearance
louis vuitton outlet
coach factory outlet online
jordan shoes
louis vuitton purses
nike trainers sale
coach outlet store
louis vuitton purses
christian louboutin outlet
coach outlet
tiffany and co jewelry
louis vuitton outlet online
hollister clearance
ray bans
michael kors
jordan 3 powder blue
coach outlet
louis vuitton outlet stores
canada goose jackets
louis vuitton outlet online
adidas superstar trainers
coach factory outlet online
kate spade handbags
louis vuitton outlet online
nike air max uk
designer handbags
nike roshe run
gucci outlet
coach factory outlet online

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

jeje said...

kyrie irving shoes
jordan 13
adidas outlet
air jordan 11
adidas nmd
jordan retro
longchamp handbags
lacoste online shop
birkin bag
adidas eqt support adv

rehabgad1 said...

Good write-up. I definitely love this site. Keep it up