Oracle Database Administration from Zero to Hero - Introduction to RMAN (Part 2 of 3)

The video tutorial covers RMAN, a tool for database backup and recovery. It explains RMAN's components, types of databases it connects to, and storage options for backups. The tutorial also details how to start RMAN, connect to databases, and the importance of using the SYSBACKUP privilege for role separation. Additionally, it discusses RMAN command line arguments and executing scripts.

What is the primary role of the Recovery Catalog database in RMAN?

• To perform database cloning

• To store RMAN's repository and history

• To store backup files

• To manage user access

Which privilege is recommended for connecting to a target database in RMAN?

• ADMIN

• DBA

• SYS BACKUP

• SYSDBA

What is required to connect to a remote target database using RMAN?

• A network service name in the DNS name file

• Direct access to the server

• A local database instance

• A physical connection to the database

What is a key advantage of using the SYS BACKUP privilege over SYSDBA?

• It provides full administrative control

• It allows data access

• It requires the database to be open

• It limits access to backup and recovery tasks

Which method does not require the database to be open when using SYS BACKUP privilege?

• Direct database connection

• Network service name authentication

• Password file authentication

• Operating system authentication

How can RMAN output be redirected to a file instead of the standard output?

• By using the log argument

• By using the script execution command

• By using the CMD file argument

• By using the append keyword

What happens if the log file already exists when using the log argument in RMAN?

• A new log file is created

• The existing content is overwritten

• The existing content is appended

• The existing content is deleted