RMAN is a Oracle Utility to backup, restore and recovery of database.
RMAN configuration for first time:
Let us assume the database is in NOARCHIVELOG mode (by default). We need to change it to ARCHIVELOG mode for RMAN backup configuration. We can configure RMAN backup with catalog/repository database as well as control file. It is strongly recommended & very good practice to configure RMAN backup with catalog/repository database.
Catalog/repository database: It’s central repository & it requires separate database for backup operation. All registered target databases information stored in catalog database.
Control file: It contains registered target database information at server level itself & RMAN utility directly connects to target database by command “RMAN target /”
Note: Create catalog/repository database with the help of DBCA.
RMAN configuration for first time:
Let us assume the database is in NOARCHIVELOG mode (by default). We need to change it to ARCHIVELOG mode for RMAN backup configuration. We can configure RMAN backup with catalog/repository database as well as control file. It is strongly recommended & very good practice to configure RMAN backup with catalog/repository database.
Catalog/repository database: It’s central repository & it requires separate database for backup operation. All registered target databases information stored in catalog database.
Control file: It contains registered target database information at server level itself & RMAN utility directly connects to target database by command “RMAN target /”
Note: Create catalog/repository database with the help of DBCA.
Follow these steps to configure RMAN backup :
- Connect to Target database(Target DB: The database on which Backup & Recovery to be performed) as sysdba.
No comments:
Post a Comment