Wednesday, April 23, 2008

Interact with RMAN Client.

Types and Authentication of Database that RMAN used to Connect:
-------------------------------------------------

RMAN client can connect to three types of databases
1)The Target Database: The database which need to perform backup and recovery operation that database connection with RMAN client must be the target database.
To connect to the target database you must have the SYSDBA privilege.

2)The Recovery Catalog Database:
The recovery catalog database provides an optional backup store for the RMAN repository. To connect to the recovery catalog database you must need the RECOVERY_CATALOG_OWNER role.

3)The Auxiliary Database:RMAN connect to the auxiliary database for performing a specific task such as duplicating a database, transporting tablespaces without taking the making database read-only, or performing tablespace point-in-time recovery.

RMAN does not require that you specify the SYSDBA privilege when connecting to a database. Because all RMAN database connections require SYSDBA privilege, RMAN always implicitly attempts to connect with this privilege.

To connect to RMAN client you can use password file for either local or remote access. But,if you are connecting remotely as SYSDBA with a net service name you must use a password file with a net service name.

Connecting to the target Database with and without Password file:


To use OS Authentication,
rman target /

To use Password file Authentication if OS Authentication not available,
rman target SYS/arju@arju


Related Documents:
----------------------

No comments:

Post a Comment