Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Pre Requisits to configure RMAN in catalog mode


Note : It is not only important to have a proper backup policy for all target databases, it is also equally important to have a backup policy for catalog database.
Example : everyday schema level logical backup.
 weekly once cold backup(recommanded to run catalog database in archive log mode).
1.Identify a low end server or least utilised server and install the same or higher version of oracle binaries.
2.create a catalog database
3.create a separate tablespace to hold RMAN metadata tables.
4.create a user and grant connect,resource,recovery_catalog_owner.
5.create catalog
6.configure tnsnames.ora so that it points to the target database listeners.
7.register target database into recovery catalog.
8.configure RMAN parameters
9.create backup,restore and recovery scripts.

Related Posts Plugin for WordPress, Blogger...

Flag Counter