Backup and Restore Flashcards by Rayan Aboufariss

What is the primary purpose of backup in Oracle Database?

To protect data from loss or corruption.

How well did you know this?

Not at all

Perfectly

True or False: Incremental backups only capture data that has changed since the last backup.

True

How well did you know this?

Not at all

Perfectly

What command is used to perform a full database backup in Oracle?

RMAN BACKUP DATABASE;

How well did you know this?

Not at all

Perfectly

What does RMAN stand for?

Recovery Manager

How well did you know this?

Not at all

Perfectly

Fill in the blank: Oracle Database backups can be performed using _____ or _____ methods.

RMAN, user-managed

How well did you know this?

Not at all

Perfectly

What are the two main types of backups in Oracle Database?

Full backups and incremental backups.

How well did you know this?

Not at all

Perfectly

True or False: A control file is essential for RMAN to perform backup and restore operations.

True

How well did you know this?

Not at all

Perfectly

What is a hot backup?

A backup taken while the database is open and in use.

How well did you know this?

Not at all

Perfectly

What is the purpose of the ‘SPFILE’ in Oracle Database?

It contains initialization parameters for the database.

How well did you know this?

Not at all

Perfectly

Which command is used to restore a database using RMAN?

RMAN RESTORE DATABASE;

How well did you know this?

Not at all

Perfectly

What does the term ‘datafile’ refer to in Oracle?

A physical file that stores the data of the database.

How well did you know this?

Not at all

Perfectly

Fill in the blank: The _____ command in RMAN is used to create a backup of the control file.

BACKUP CURRENT CONTROLFILE

How well did you know this?

Not at all

Perfectly

What is the difference between a ‘cold backup’ and a ‘hot backup’?

A cold backup is taken when the database is shut down, while a hot backup is taken while the database is running.

How well did you know this?

Not at all

Perfectly

What does the acronym ‘CDB’ stand for in Oracle Database?

Container Database

How well did you know this?

Not at all

Perfectly

What is the purpose of the ‘FLASHBACK’ feature in Oracle?

To restore the database to a previous point in time.

How well did you know this?

Not at all

Perfectly

True or False: RMAN can only back up datafiles, not archived redo logs.

False

How well did you know this?

Not at all

Perfectly

What is an archived redo log?

A log file that contains changes made to the database, stored for recovery purposes.

How well did you know this?

Not at all

Perfectly

What command is used to delete obsolete backups in RMAN?

DELETE OBSOLETE;

How well did you know this?

Not at all

Perfectly

Fill in the blank: RMAN allows for _____ backups, which capture only changes made since the last backup.

incremental

How well did you know this?

Not at all

Perfectly

What is the function of ‘RMAN catalog’?

To store metadata about RMAN backups.

How well did you know this?

Not at all

Perfectly

What is the difference between ‘level 0’ and ‘level 1’ backups?

Level 0 is a full backup, while level 1 is an incremental backup capturing changes since the last backup.

How well did you know this?

Not at all

Perfectly

True or False: You can perform a point-in-time recovery using RMAN.

True

How well did you know this?

Not at all

Perfectly

What is the purpose of the ‘RECOVERY’ command in RMAN?

To recover the database to a consistent state after a failure.

How well did you know this?

Not at all

Perfectly

What does the ‘VALIDATE’ command do in RMAN?

It checks the integrity of backup sets and datafiles.

How well did you know this?

Not at all

Perfectly

What is 'Oracle Data Pump'?

A utility for transferring data and metadata between Oracle databases.

Fill in the blank: The _____ command in RMAN is used to restore a specific datafile.

RESTORE DATAFILE

What is 'Oracle Secure Backup'?

A tape backup solution for Oracle databases.

True or False: You can only use RMAN for backups on Oracle databases.

True

What is the main advantage of using RMAN over user-managed backups?

RMAN provides automated management of backup and recovery processes.

What is the purpose of 'restore points' in Oracle Database?

To allow for fast recovery to a specific state of the database.

What command is used to create a restore point in Oracle?

CREATE RESTORE POINT ;

Fill in the blank: The _____ command is used to recover a database to a specific point in time.

RECOVER DATABASE UNTIL TIME

What is the role of the 'Data Recovery Advisor'?

To automate the recovery process and provide recommendations for repair.

Which view can be used to check the status of backups in Oracle Database?

V$BACKUP_SET

True or False: A backup can be restored to a different host than the original database.

True, if compatible.

What is the purpose of 'backup retention' policies in RMAN?

To define how long backups should be kept before being considered obsolete.

What does 'cross-platform transportable tablespace' mean?

It allows tablespaces to be moved between different operating systems.

Fill in the blank: The command to perform a complete recovery of the database is _____ followed by _____ commands.

RESTORE DATABASE, RECOVER DATABASE

What is a 'backup set' in RMAN?

A collection of backup pieces created by RMAN.

What does the 'CROSSCHECK' command do in RMAN?

It verifies that backup pieces are still available and valid.

What is the significance of using 'asynchronous I/O' for backups?

It improves the performance of backup operations.

True or False: RMAN can back up and restore both physical and logical structures in the database.

False, RMAN primarily handles physical structures.

What is a 'backup piece'?

A physical file that contains the data from a backup.

Fill in the blank: RMAN can back up to _____, _____, or _____.

disk, tape, cloud

What is the 'duplicate' command used for in RMAN?

To create a copy of a database.

What is the 'restore database' command used for?

To restore the entire database from backups.

True or False: You must have a complete set of backups to perform a restore operation.

True

What does the 'BACKUP INCREMENTAL LEVEL 1' command do?

It backs up only the changes made since the last level 0 or level 1 backup.

What is a 'restore operation'?

The process of copying data from backups to recreate the database.

Fill in the blank: The _____ command in RMAN is used to perform a point-in-time recovery.

RECOVER DATABASE UNTIL TIME

What is the purpose of the 'DELETE' command in RMAN?

To remove backup files that are no longer needed.

What are 'tablespace backups'?

Backups that target specific tablespaces within a database.

True or False: RMAN can automatically delete obsolete backups based on retention policies.

True

What is a 'snapshot control file'?

A copy of the control file that is used during recovery.

What is the purpose of 'media recovery'?

To recover the database after a media failure.

Fill in the blank: RMAN can be used to back up the _____ and _____ of the database.

datafiles, archived redo logs

What does the 'SET UNTIL' command do in RMAN?

It specifies a point in time for recovery.

What is a 'full backup'?

A backup that includes all data and metadata in the database.

True or False: You can use RMAN to back up a specific schema within a database.

False, RMAN backs up at the database or tablespace level.

What is the 'RECOVER' command used for?

To apply changes to the database from redo logs and archived logs.

What is the significance of 'backup validation'?

To ensure backups are usable and can be restored successfully.

Fill in the blank: An _____ backup is taken while the database is offline.

cold

What is the 'report obsolete' command used for in RMAN?

To display backups that can be deleted based on retention policies.

What is the purpose of 'flash recovery area'?

To store recovery-related files such as backups and archived logs.

True or False: RMAN can only be used with Oracle databases running on Unix-like operating systems.

False

What is the role of 'archiving' in Oracle Database backups?

To store redo logs for recovery purposes.

What is 'transportable tablespace'?

A feature that allows tablespaces to be moved between databases.

Fill in the blank: The _____ command is used to perform a full backup of the database.

BACKUP DATABASE

What is the 'DATA PUMP EXPORT' utility used for?

To export data and metadata from the database.

What is a 'recovery catalog'?

A database schema that stores RMAN metadata.

True or False: RMAN can back up only the datafiles but not the control files.

False

What is the function of 'media management' in RMAN?

To manage backups on media such as tapes or disks.

What does the 'BACKUP AS COPY' command do?

It creates a copy of the datafiles without compressing them.

Fill in the blank: The _____ command is used to delete backups that are no longer needed.

DELETE

What is the purpose of 'incremental merge' backups?

To combine incremental backups into a full backup.

What is the 'restore spfile' command used for?

To restore the server parameter file.

True or False: RMAN cannot perform backups if the database is in NOARCHIVELOG mode.

True

What is the significance of 'backup compression'?

To reduce the size of backup files.

What is a 'duplicate database'?

A copy of the original database created by RMAN.

Fill in the blank: RMAN can back up the database to _____ or _____ storage.

disk, tape

What is the 'restore controlfile' command used for?

To restore the control file from a backup.

True or False: RMAN can automatically manage backup scheduling.

True

What is the purpose of 'backup encryption'?

To secure backup files from unauthorized access.

What does the 'CROSSCHECK BACKUP' command do?

It checks the availability and validity of backup files.

What is the function of 'incremental backup'?

To back up only the data that has changed since the last backup.

Fill in the blank: The _____ command in RMAN is used to restore a specific tablespace.

RESTORE TABLESPACE