Java Programming - FAQ
- 1. How is RMAN used to backup and restore?
- 2. What is a Target Database?
- 3. What is a Catalog Database?
- 4. What is an Auxiliary Database?
- 5. How is a Catalog created?
1. How is RMAN used to backup and restore?
The biggest advantage of RMAN is that it will only backup used space in the database. RMAN doesn't put tablespaces in backup mode, saving on redo generation overhead. RMAN will re-read database blocks until it gets a consistent image of it. By default Oracle uses the database controlfiles to store information about backups, and optionally a Recovery Catalog.
2. What is a Target Database?
The database that you will use RMAN to back up and restore. You use RMAN to connect to the target database as SYSDBA.
3. What is a Catalog Database?
This database is optional: you can use RMAN with the default NOCATALOG option, in which case RMAN uses the control file as the exclusive repository to store backup information. A recovery catalog is a set of tables containing RMAN metadata. RMAN obtains the metadata from the target database control file.
4. What is an Auxiliary Database?
The auxiliary instance is used to create a duplicate database, also known as a Clone database, it can also be used to create a standby database using this DUPLICATE command and for tablespace point-in-time-recovery.
5. How is a Catalog created?
It is recommended to create a separate database and an RMAN schema (usually called rman), do it and grant the Rman user the recovery_catalog_owner role and the SYSDBA role.
