-
hi,
i want to setup rman on 8i and 9i for performing backup and recovery.
can someone how to start with and what dows the following term means:
CONNECT CATALOG rman/cat_pwd@cat_str
when i issue this command it give no user is there and when i change it to
CONNECT CATALOG sys/password@cat_str it gives connect but no recovery catalague installed.
how should i do it.
please help
thanks
Saurabh Garg
OCP 9i
-
You have to create a recovery catalog first.
Create a new database or pickup an existing database.
Create a tablespace for RMAN objects, about 50 MB size.
Create a user 'rman' and set his default tablespace as that created above.
Grant RECOVERY_CATALOG_OWNER to rman.
Grant DBA, Connect & Resource roles to rman.
Now connect to recovery catalog as user rman to create recovery catalog objects.
-
You can also refer to this thread
http://www.dbasupport.com/forums/sho...threadid=16939
It shows how to create the catalog and register the database.
-
As much as possible create your rman in another database or much better if in another machine. Otherwise, your rman will defeat its intention if something goes wrong with the database that you intend to apply with rman.
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
|