Below are oracle rman interview questions.
Q⟹ What is RMAN?
recovery and administrative tasks in oracle Database. It greatly simplifies the dba jobs by managing the production database’s backup, restoration, and recovery.
This tool integrates with sessions running on an Oracle database to perform a range of backup and recovery activities, including maintaining an RMAN repository of historical data about backups. There is no additional installation required for this tool. It’s by default get installed with the oracle database installation. The RMAN environment consists of the utilities and databases that play a role in backing up your data.You can access RMAN through the command line or through Oracle Enterprise Manager.
Q⟹ Difference between expired backup and obsolete backup.
Q⟹ What does mean by Level 0, Level 1 backups: –
RMAN Backup And Recovery Interview Questions
Q⟾ How to check RMAN configuration.
Q⟾ Can we take the rman backup while database in shutdown.
Q⟾ Difference between backup piece and backup set.
Q⟾ Crosscheck command in RMAN.
Q⟹ How to Reset to default Configuration?
Q⟹ RMAN terminology
A recovery Catalog: A separate database schema used to record RMAN activity against one or more target databases. A recovery catalog preserves RMAN repository metadata if the control file is lost, making it much easier to restore and recover following the loss of the control file. The database may overwrite older records in the control file, but RMAN maintains records forever in the catalog unless deleted by the user.
Backup sets: RMAN can store backup data in a logical structure called a backup set, which is the smallest unit of an RMAN backup. One backup set contains one or more datafiles a section of datafile or archivelogs.
Backup Piece: A backup set contains one or more binary files in an RMAN-specific format. This file is known as a backup piece. Each backup piece is a single output file. The size of a backup piece can be restricted; if the size is not restricted, the backup set will comprise one backup piece. Backup piece size should be restricted to no larger than the maximum file size that your filesystem will support.
Image copies: An image copy is a copy of a single file (datafile, archivelog, or controlfile). It is very similar to an O/S copy of the file. It is not a backupset or a backup piece. No compression is performed.
Snapshot Control file: When RMAN needs to resynchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. The default name for the snapshot control file is port specific.
Database Incarnation: Whenever you perform incomplete recovery or perform recovery using a backup control file, you must reset the online redo logs when you open the database. The new version of the reset database is called a new incarnation. The reset database command directs RMAN to create a new database incarnation record in the recovery catalog. This new incarnation record indicates the current incarnation.
Q⟹ What are the database file’s that RMAN can backup?
A⟹RMAN can backup objects such as Controlfile , Datafiles , Archive logs , standby database controfile, Spfile.
What is RMAN consistent backup and inconsistent backup?
A backup when the database is up and running is called an inconsistent backup. When a database is restored from an inconsistent backup, Oracle must perform media recovery before the database can be opened, applying any pending changes from the redo logs. You cannot take inconsistent backup when the database is in No Archivelog mode.