-
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
Akash
-
There is no catrman script in 8.1.x. Use CREATE CATALOG instead.
Jeff Hunter
-
Can u tell me how to use create catalog?
Thanks
Akash
-
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.
-
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
-
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 :-)
-
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
Akash
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|