RMAN

[akash]

Hi gurus
I have created user rman in tablespace rcvcat.
I have granted all the necessary rights to rman
Now i am trying to run the catrman.sql script to create the necessary tables for the recovery catalog.
But i am getting following error.

SP2-0310: unable to open file "\Oracle\Ora81\RDBMS\ADMIN\catrman.sql"

I am using Release 8.1.6.0.0 personal edition Win98
Any idea???
Thanks

[marist89]

There is no catrman script in 8.1.x. Use CREATE CATALOG instead.

[akash]

Can u tell me how to use create catalog?


Thanks

[julian]

Originally posted by akash
Can u tell me how to use create catalog?

Thanks

I assume you have a user called RMAN with default tablespace RCVCAT.

As sys:

1. GRANT recovery_catalog_owner TO rman;

2. GRANT connect, resource TO rman;

Open Command Prompt and write (assuming you have a primary DB called primary and the recovery catalog is in DB called catalog):

3. rman catalog rman/password@catalog

Now (being in RMAN) write:

4. CREATE CATALOG tablespace "RCVCAT";
EXIT;

Important: the tablespace in capitals! Beats me why Oracle wants it like that. Also: the quotes!

5. rman target sys/password@primary rcvcat rman/password@catalog

Now (being again in RMAN) write:

6. REGISTER DATABASE;

That's it.

[rohitsn]

Hi,
At the command prompt enter the following command :

c:\>rman target="sys/sys@prod" rcvcat="rman/rman@grman"

RMAN>create catalog ---catalog created

RMAN>register database ---information about the target
database is stored in the recovery
catalog from the controlfile of the
target database;

RMAN>list incarnation of database --- check whether the
target database is
registered

In case of any doubts please be free to ask me at rohitsn@altavista.com


Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[julian]

Originally posted by rohitsn
Hi,
At the command prompt enter the following command :

c:\>rman target="sys/sys@prod" rcvcat="rman/rman@grman"

RMAN>create catalog ---catalog created

RMAN>register database ---information about the target
database is stored in the recovery
catalog from the controlfile of the
target database;

RMAN>list incarnation of database --- check whether the
target database is
registered

In case of any doubts please be free to ask me at rohitsn@altavista.com


Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

For Oracle version 8.1.7 the following

RMAN>create catalog ---catalog created

is not good.

You should use:

CREATE CATALOG TABLESPACE "TABLESPACE_NAME"

And "tablespace_name" or just TABLESPACE_NAME does not work.

Bad experience :-)

[akash]

So I need to have two databases..... Right?
My first database name is ORCL now I will create another.

Just tell me how these two database will interact (link)?

Thanks

[julian]

Originally posted by akash
So I need to have two databases..... Right?
My first database name is ORCL now I will create another.

Just tell me how these two database will interact (link)?

Thanks

Two DBs is not a must. However, you want you Catalog outside the Target DB. What happens if for some reason you loose your Primary DB. You loose the Catalog.

It is also a good idea to have a Backup strategy for the Catalog.

How they interact:

rman target sys/password@primary rcvcat rman/password@catalog