2009/02/06

Configuring Database for RMAN Operations

1. Create RMAN user with sysdba privilege and default tablespace.

SQL> CRAETE USER <user> IDENTIFIED BY <password>
SQL> DEFAULT TABLESPACE users;
SQL> GRANT sysdba TO <user>;
2. Create password file so that RMAN user can log in from remote via Oracle Net.
3.

SQL> ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE='exclusive';
4. Set CONTROL_FILE_RECORD_KEEP_TIME Parameter to a value no less than your selected database backup retention period.
5. Configure RMAN default settings.

No comments: