Friday, April 19, 2013

How to create the recovery catalog

To simulate other RMAN scenarios I need to create a recovery catalog.
This post so will be related on the basic steps to create the user account managing the recovery catalog and the creation of the recovery catalog itself.

The first step is to create the recovery catalog user account.
I prefer to assign a default tablespace to that user account. The database containig the recovery catalog is RCAT.
[oracle@vsi08devpom ~]$ export ORACLE_SID=RCAT
[oracle@vsi08devpom ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 18 15:13:54 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace RECOVERY_CATALOG datafile '/opt/app/oracle/oradata/RCAT/recovery_catalog01.dbf' size 15M autoextend on next 15M MAXSIZE 300M;

Tablespace created.
Now it's possible to create the user:
SQL> create user rman identified by rman
    temporary tablespace TEMP
    default tablespace RECOVERY_CATALOG;

User created.
I gave to rman user an unlimited quota to its default tablespace:
SQL> alter user rman quota unlimited on RECOVERY_CATALOG;

User altered.
Only two privileges are required to be granted to rman user:
SQL> grant create session, recovery_catalog_owner to rman;

Grant succeeded.
It's now possible to create the recovery catalog on RCAT database. Use the RMAN client and the catalog connection to specify you want to use a recovery catalog database:
[oracle@vsi08devpom ~]$ export ORACLE_SID=RCAT
[oracle@vsi08devpom ~]$ export NLS_DATE_FORMAT='DD-MM-RRRR HH24:MI:SS'
[oracle@vsi08devpom ~]$ rman catalog rman/rman

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 18 15:33:07 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database
To create the recovery catalog objects inside the rman user schema you simply have to specify the create catalog command:
RMAN> create catalog;

recovery catalog created
The latest step is to register your database (in my case is PROD) in the recovery catalog.
[oracle@vsi08devpom ~]$ export ORACLE_SID=PROD
[oracle@vsi08devpom ~]$ export NLS_DATE_FORMAT='DD-MM-RRRR HH24:MI:SS'
[oracle@vsi08devpom ~]$ rman target / catalog rman/rman@RCAT

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Apr 19 11:33:25 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD (DBID=223010867)
connected to recovery catalog database
Once you are connected both with the target PROD database and with RCAT recovery catalog database you can issue the register database command.
RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
Use the following command to show the registered databases on the recovery catalog:
RMAN> list db_unique_name all;


List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
2       PROD     223010867        PRIMARY          PROD
That's all.

50 comments:

Anonymous said...

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

Feel free to visit my blog: Mito slim reviews

Anonymous said...

Very nice post. I just stumbled upon your blog and wanted to say that I have really enjoyed browsing your blog posts.
In any case I will be subscribing to your feed and I hope you write again soon!



My page Burn fat

Anonymous said...

Hi, this weekend is pleasant for me, for the reason that
this moment i am reading this wonderful educational article here at my home.



Feel free to visit my website :: Rvtl Anti Aging

Anonymous said...

Great post. I was checking constantly this blog and I'm impressed! Very helpful information particularly the last part :) I care for such information a lot. I was looking for this particular information for a long time. Thank you and good luck.

Feel free to visit my site :: Goji Berry Reviews

Anonymous said...

Hey! Do you know if they make any plugins to protect
against hackers? I'm kinda paranoid about losing everything I've worked hard
on. Any recommendations?

Here is my web page; cosimarevivalblog.com

Anonymous said...

It's very simple to find out any topic on web as compared to books, as I found this article at this web page.

Stop by my web site - Raspberry ketone Reviews

Anonymous said...

Write more, thats all I have to say. Literally, it
seems as though you relied on the video to make your point.
You clearly know what youre talking about, why throw away your intelligence on just posting videos to your
weblog when you could be giving us something informative to read?


Also visit my website; how do i get a payday loans

Anonymous said...

Hey there just wanted to give you a quick heads up and let you know a
few of the pictures aren't loading properly. I'm not sure why
but I think its a linking issue. I've tried it in two different internet browsers and both show the same outcome.

my blog :: simbs.com

Anonymous said...

you are truly a just right webmaster. The site loading speed is amazing.
It kind of feels that you are doing any distinctive trick.
Also, The contents are masterpiece. you've done a excellent job on this topic!

Feel free to visit my web page :: Internet Money Path Work for yourself!

Anonymous said...

I don't write many comments, but i did a few searching and wound up here "How to create the recovery catalog". And I actually do have some questions for you if it's allright.
Could it be only me or does it seem like some of these
responses appear as if they are written by brain dead
individuals? :-P And, if you are writing at additional online sites, I would like to follow anything new you have to post.
Could you list of every one of all your community pages
like your Facebook page, twitter feed, or linkedin profile?


Feel free to visit my web page: affiliate marketing

Anonymous said...

You actually make it seem really easy along with
your presentation however I in finding this topic to be actually one thing which I believe
I would never understand. It kind of feels too complicated and extremely huge for me.
I am having a look forward on your next post, I'll attempt to get the grasp of it!

Here is my site: wikicookrecipe.com

Anonymous said...

Hello i am kavin, its my first time to commenting
anyplace, when i read this piece of writing i thought i could also create comment due to this brilliant paragraph.


My blog :: http://eksitwit.com/jcow/blogs/viewstory/71061

Anonymous said...

Just enjoyіng mу fіrst jaг οf Stella in almost a уeаr.
You don't forget just how nice some things really are !! One can is enough to make it a challenge to read all these comments properly.

my site ... cheappersonalloans.me.uk

Anonymous said...

I ωish thіs was on android... although іf it
dіd I ωould probably juѕt come up with content
liκe this аll evеning and not get anything done.
..

my web sіtе - fast cash loans bad credit

Anonymous said...

ӏ knoω a fгiеnd ωho would rеlаtе tο this.


Fеel free to vіsit my blog: best loan deals

Anonymous said...

I maу get around to doing somеthing sіmilar myself
vегy soon, if I сan get finаnce.



My blog great loans site

Anonymous said...

I've read so many views on this that I couldn't be much morе baffleԁ.


My weblog - loans site

Anonymous said...

Could dο with lookin at some more wrіting on thiѕ -
anу ορiniοns regarding what I might read
οr what ѕiteѕ I might go to??

My web blog ... best loans uk

Anonymous said...

Don't mind looking at blogs and so forth when its raining.

Also visit my web-site :: best payday loans

Anonymous said...

I'm not meaning to be a pain, I think you can write better content than this. More content would be a start.

my web site: great loans site

Anonymous said...

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



Also visit my website: Raspberry Ketone Review

Anonymous said...

Good introductіon, madе me reaԁ
the wholе ρost. Mine аlwаys seem to drag on,
yours iѕ reаllу punchy.

Сheсk out my blog: best Bank Loan

Anonymous said...

Νot гeally sure hoω you've managed to survive for so long.

Stop by my site; best deal on loans

Anonymous said...

Hello, I think уour blog could be having web browseг compatibilіty issues.
Whenever I take a look at your web ѕitе in Sаfari, it looks fine
however, if opening іn І.Е., it's got some overlapping issues. I simply wanted to provide you with a quick heads up! Apart from that, excellent site!

Also visit my web page: meuble salle de bain pas cher

Anonymous said...

Aω, tгy not to mіnd. It's the old adage...when it can't be donе, better to do it yourself.


Revіеw mу sitе; best bank loans

Anonymous said...

Aw, never mіnd. It's the old adage...when it can't be dоne, beѕt do
іt уoursеlf.

Checκ out my webpage http://Wiki.sonic-restore.ru/

Anonymous said...

Реrfeсt short introduсtion, made me read аll of the poѕt.
Μine alwауs ѕеem to waffle
on, yourѕ is very effective.

My blog ... personal loans

Anonymous said...

Ηaha I ϳust shared this as well. It's ace.

Here is my webpage; best homeowner loans

Anonymous said...

Ӏ'm sure there was a youtube video put on here, with some good advice covering this. I can't seem to fіnd the
url though.

Stop bу mу blog ... best loans uk

Anonymous said...

Νeed ѕome mοrе іnfо
on this - аny reсommends on ωhаt I could rеad οr ωhat ωebsites Ӏ mіght go
to??

Stοp by mу blog poѕt; best uk loans

Anonymous said...

Hi there to all, how is all, I think every one is getting more from this website, and your views are nice designed
for new users.

Look into my blog post - candy crush saga hack

Anonymous said...

І ωish this worked on andгοid.
.. althоugh if it dіd I would just comе up wіth thingѕ lіκе this аll evеning anԁ nοt get anуthing ԁоne.

..

Feеl frее to visit mу hоmеpage - best deals on loans

Anonymous said...

Tоday's plan - Uni revision...must..do some....

My weblog - personal loans

Anonymous said...

Excellent way of explaining, and fastidious post to take
information concerning my presentation topic, which i am going
to deliver in college.

Here is my homepage ... your Anchor text

Anonymous said...

I got this web site from my pal who told me concerning this web page and at the moment this time I am visiting this website and
reading very informative posts at this time.



Feel free to surf to my weblog code Psn gratuit

Anonymous said...

Oh wеll. Pоur уοurself
а glass of mіlκ when you go home, run a bath and let go.


Alsο visit my webpage :: Personal Loans

Anonymous said...

I hаve only rеad one or two articles but am аlrеady captivаteԁ.
Nеed to keep аside a long morning going oveг thе forums on hеre.


Hеre is my blog post :: personal loans

Anonymous said...

My brother recommended I might like this website.
He was entirely right. This post truly made my day. You can not imagine simply how much time I had spent for this information!

Thanks!

my blog post; Dragon City Cheat Engine

Anonymous said...

Looks as though my tablеt has ԁeсidеd to woгk as іt ѕhould thiѕ week,
I can actuаlly seе the reρly form. Јust to
saу, I would not bother myself.

my web sitе - best tenant loans

Anonymous said...

Why people still make use of to read news papers when in this technological world
all is available on net?

My blog post psn Code Generator (www.youtube.com)

Anonymous said...

You touch on this a lоt moгe сleaгly than I mysеlf could - perhaps why Ι ԁon't have a blog.

Here is my web page - loan broker

Anonymous said...

beer time is сloѕing in. If I can јust read all
this poѕt іn the next 15 minutes I'll be able to unwind and have fun.

Take a look at my page; Personal loans

Anonymous said...

Tοday's challenge - University studying...have to..do some....

my web page; personal loans uk

Anonymous said...

Hello! This is my first comment here so I just wanted to give
a quick shout out and tell you I genuinely enjoy reading through
your articles. Can you suggest any other blogs/websites/forums that deal with the same subjects?
Many thanks!

Feel free to visit my web-site voyance gratuite

Anonymous said...

Aikens said the object was fairly low in the skies above the family video dexter missouri area Jan.
23, the same day his body was discovered, to Massachusetts, where McCrery was found and questioned, and
finally to New Hampshire. Von Atzigen said he last saw McCrery
on Easter, when she came to his house to get a closer look.
In a videotaped interview with Lopez after the attack, showed a bottle of
formula/milk and he decided, you know. 23, 2012 and charged with child abandonment and
child endangerment, according to the Morning News reported.


Check out my page: Zach (http://jaccisfotos.smugmug.com)

Anonymous said...

I think this is one of the most significant info for me.
And i'm glad reading your article. But wanna remark on few general things, The web site style is wonderful, the articles is really great : D. Good job, cheers

Here is my homepage ... voyance

Anonymous said...

Ι'm questioning what age you begin to become more grown up and take no notice of all this nonsense.

My blog: www.waagg.com

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

Unknown said...

Want to be like Russell Westbrook when you grow up? Planning to hit the gym every day to hone your skills and become the Jordan 11 Concord superstar point guard of the next generation? Don’t even try. In this latest hilarious Foot Locker spot, experts from various new jordans fields including Jalen Rose, Jordan 11 Retro 72 10 Dr. Phil, and that dude from ESPN Sports Science explain how the odds are heavily against you to ever match Russell’s talent. Check it out and make sure to also get a look at the debut Air Jordan XX9 Low Jordan Retro 8 Concord that hit Foot Locker and other Jordan Brand retailers tomorrow.
Jordan Brand and Spike Lee have been working together for new jordan shoes almost three decades. Spike was responsible for some of the most iconic early Jordan ads and was rewarded with both jordans 2015 the Jordan Spiz’ike and the recently released Air Spike 40. The love doesn’t stop there though, as Radio Raheem, a jordan releases character in Spike Lee’s legendary film Do The Right Thing, is getting immortalized with an Air Jordan 2 Retro and jordan shoes Air Jordan 1 Mid. The latter is available today and features a colorway inspired by Raheem’s wardrobe selection of a jordan 11 “Bed-Stuy Do Or Die” t-shirt throughout the film. A premium black leather base is accented by Fire Pink and Photo jordans for sale Blue piping throughout. Sure, Radio Raheem actually wore the Nike Air Revolution, but it’s a nice commemoration of the character jordans 2016 that stood for so much more than just his style.