Topic : Recovery Catalog

What is use of having catalog & not having catalog


Answer :

Catalog means that you have a recovery catalog database; nocatalog means that you are using the controlfile as rman repository

Show Answer Discuss

Which command is used to allow RMAN to store a group of commands in the recovery catalog?


  • ADD SCRIPT
  • CREATE SCRIPT
  • CREATE COMMAND
  • ADD BACKUP SCRIPT

Answer :

CREATE SCRIPT

Show Answer Discuss

When using Recovery Manager without a catalog; the connection to the target database


  • Must be a local connection.
  • Must be a remote connection.
  • Can be a local or a remote connection.
  • Must be specified using a Net8 service name.

Answer :

Can be a local or a remote connection.

Show Answer Discuss

Work is done by Recovery Manager through ____


  • PL/SQL packages.
  • External procedures.
  • Operating system scripts.
  • Operating system commands

Answer :

Operating system commands

Show Answer Discuss

When using Recovery Manager without a catalog; the connection to the target database should be made as _____.


  • User SYSDBA
  • User SYSTEM
  • A user with SYSDBA privilege
  • A user that owns the RMAN catalog

Answer :

A user with SYSDBA privilege

Show Answer Discuss