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.
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
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.
Click Here to Expand Forum to Full Width