Interview Questions.

Question 1. What Is Level zero, Level 1 Backup?

Answer :

A stage zero incremental backup, that is the bottom for subsequent incremental backups, copies all blocks containing data, backing the facts file up right into a backup set simply as a complete backup could. A level 1 incremental backup may be both of the following kinds:
A differential backup, which backs up all blocks changed after the maximum recent incremental backup at level 1 or 0
A cumulative backup, which backs up all blocks modified after the maximum recent incremental backup at degree zero
Question 2. How Do You Setup The Rman Tape Backups?

Answer :

Configure channel as SBT_TAPE and use “ENV” parameter to set the tape configurations.

Oracle 10g Interview Questions
Question 3. What Is The Init Parameter Specify The Minimum Number Of Days That Oracle Keeps Backup Information In The Control File?

Answer :

You can use the CONTROL_FILE_RECORD_KEEP_TIME parameter to specify the minimal range of days that Oracle maintains this records in the manipulate file.

Question 4. What Is The Difference Between Validate And Crosscheck ?

Answer :

The repair/validate and validate backupset commands check whether or not you could repair backups or copies.

You should use:

restore : validate while you want RMAN to pick out which backups or copies need to be tested.
Validate backupset when you need to specify which backup units have to be tested.
Oracle 10g Tutorial
Question 5. How Do I Go About Backing Up My Online Redo Logs?

Answer :

Online redo logs need to never, ever be protected in a backup, irrespective of whether or not that backup is accomplished hot or cold. The reasons for this are two-fold. First, you physically can not backup a warm on-line redo log, and 2d there's exactly 0 want to accomplish that in the first location because an archive redo log is, through definition, a backup reproduction of a previously online log. There is, but, a extra sensible reason: backing up the online logs your self increases the risk that you'll lose.

Oracle 9i Interview Questions
Question 6. What Is Backup Set?

Answer :

RMAN can save backup records in a logical structure known as a backup set, that's the smallest unit of an RMAN backup. A backup set contains the information from one or more statistics documents, archived redo logs, or control documents or server parameter file.

Question 7. What Is Channel? How Do You Enable The Parallel Backups With Rman?

Answer :

Use the ALLOCATE CHANNEL command to manually allocate a channel, which is a connection among RMAN and a database instance. To permit the parallel backups, allocate a couple of guide channels inside the run block or configure parallelism

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

Oracle 9i Tutorial Oracle 8i Interview Questions
Question eight. What Is Auxiliary Channel In Rman? When Do You Need This?

Answer :

An auxiliary channel is a link to auxiliary instance. If you do not have automatic channels configured, then before issuing the DUPLICATE command, manually allocate at the least one auxiliary channel in the same RUN command. When a Duplicate Database created or desk space factor in time healing is carried out Auxiliary database is used. This database can both on the identical host or a specific host.

Question nine. Is It Possible To Specific Tables When Using Rman Duplicate Feature? If Yes, How?

Answer :

No, table based totally recuperation now not feasible in RMAN replica command.

Oracle 11g Interview Questions
Question 10. Outline The Steps Involved In Cancel Based Recovery From The Full Database From Hot Backup?

Answer :

RMAN doesn’t help cancel-primarily based recuperation like SQL*plus does.

Oracle 8i Tutorial
Question eleven. Outline The Steps Involved In Scn Based Recovery From The Full Database From Hot Backup?

Answer :

startup mount;
restore database UNTIL SCN 233545;
recover database UNTIL SCN 233545;
adjust database open resetlogs;
Oracle SOA Interview Questions
Question 12. How Do You Verify The Integrity Of The Image Copy In Rman Environment?

Answer :

Use under instructions :

rman> catalog datafilecopy ‘f:testsystem.Dbf’;
rman> backup validate test logical datafile ‘f:testsystem.Dbf’;
SQL> SELECT * FROM v$database_block_corruption;
Oracle 10g Interview Questions
Question 13. Is It Possible To Take Catalog Database Backup Using Rman? If Yes, How?

Answer :

Recovery catalog is a schema saved in a database that tracks backups and stores of goal databases. So higher to take a export backup.

Oracle 11g Tutorial
Question 14. How Do You Identify The Expired, Active, Obsolete Backups? Which Rman Command You Use?

Answer :

Obsolete backups:

RMAN> report obsolete;
expired backup:

RMAN> list expired backup;
Active database: RMAN> listing backup;
Question 15. Outline The Steps Involved In Time Based Recovery From The Full Database From Hot Backup?

Answer :

startup mount;
repair database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;
recover database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;
modify database open resetlogs;
Oracle SOA fit 11g Interview Questions
Question sixteen. Explain The Steps To Perform The Point In Time Recovery With A Backup Which Is Taken Before The Resetlogs Of The Db?

Answer :

We need to listing the database incarnations by way of the usage of listing incarnation command.
Shutdown the database
startup mount the database
Issue reset database to incarnation to reset the incarnation.
Restore the database the usage of restore command (e.G restore till scn 23243)
get better database
Open the database the use of resetlogs command
RMAN> listing incarnation of database;
RMAN>reset database to incarnation five;
run

set until scn 234345;
restore database;
rec  ….

Question 17. Outline The Steps For Changing The Dbid In A Cloned Environment?

Answer :

shutdown Immediate
startup mount 
Then, run the the DBNEWID application from command line.
Nid target =/
SQL> modify database open resetlogs;
Oracle Apps ERP Interview Questions
Question 18. How Do You Install The Rman Recovery Catalog? Or List The Steps Required To Enable The Rman . Backup For A Target Database?

Answer :

Steps to be accompanied:

Create connection string at catalog database.
At catalog database create one new consumer or use current person and supply that user a recovery_catalog_owner privilege.
Login into RMAN with connection string
export ORACLE_SID
rman target catalog @connection string
rman&g ….
Oracle 9i Interview Questions
Question 19. List Some Of The Rman Catalog View Names Which Contain The Catalog Information?

Answer :

RC_DATABASE_INCARNATION, RC_BACKUP_COPY_DETAILS, RC_BACKUP_CORRUPTION, RC_BACKUP_DATAFILE_SUMMARY to name some

Question 20. What Is The Difference Between Obsolete Rman Backups And Expired Rman Backups?

Answer :

The term out of date does not mean the same as expired. In short obsolete method “now not wished ” while expired way “not located.”

A repute of “expired” method that the backup piece or backup set isn't always found inside the backup vacation spot. A status of “out of date” way the backup piece continues to be to be had, but it's miles no longer wanted. The backup piece is not needed considering that RMAN has been configured to no longer want this piece after such a lot of days have elapsed, or such a lot of backups had been completed.

Oracle 7.3 Interview Questions
Question 21. When Do You Use Crosscheck Command?

Answer :

Crosscheck can be useful to test whether or not the catalog data is undamaged with OS stage information.

Question 22. If Some Of The Blocks Are Corrupted Due To System Crash, How Will You Recover?

Answer :

Using RMAN BLOCK RECOVER command

Question 23. You Have Taken A Manual Backup Of A Datafile Using O/s. How Rman Will Know About It? Or How To Put Manual/user-managed Backup In Rman (recovery Catalog)?

Answer :

By using catalog command.You ought to catalog that manual backup in RMAN’s repository with the aid of command 
RMAN> catalog datafilecopy ‘/DB01/BACKUP/users01.Dbf’;
or
RMAN> CATALOG START WITH ‘/tmp/backup.Ctl’;
Restrictions:
> Accessible on disk
> A complete image reproduction of a single report

Oracle ADF Interview Questions
Question 24. Where Rman Keeps Information Of Backups If You Are Using Rman Without Catalog?

Answer :

RMAN keeps statistics of backups within the control document.

Oracle 8i Interview Questions
Question 25. What Is The Diff Between Catalog And Nocatalog?

Answer :

The difference is best who continues the backup statistics like when is the remaining a hit backup incremental differential and so forth.

In CATALOG mode any other database (TARGET database) shops all the data.
In NOCATALOG mode controlfile of Target database is accountable.
Question 26. How Do You See Information About Backups In Rman?

Answer :

RMAN> List Backup;

Oracle HRMS Interview Questions
Question 27. How Do You Monitor Rman Backup Job Status?

Answer :

Use this SQL to check

SQL> SELECT sid totalwork sofar FROM v$session_longops WHERE sid 153;

Here supply SID whilst returned start it'll show SID

Oracle 11g Interview Questions
Question 28. How Rman Improves Backup Time?

Answer :

RMAN backup time intake may be very less than compared to ordinary on-line backup as RMAN copies handiest changed blocks.

Question 29. What Is The Difference Between Cumulative Incremental And Differential Incremental Backups?

Answer :

Differential backup: This is the default sort of incremental backup which backs up all blocks changed after the most latest backup at degree n or decrease.

Cumulative backup: Backup all blocks modified after the maximum latest backup at stage n-1 or decrease.

Oracle Architecture Interview Questions
Question 30. How Do You Enable The Autobackup For The Controlfile Using Rman?

Answer :

difficulty command at rman activate…..

RMAN> configure controlfile autobackup on;

also we are able to configure controlfile backup layout……

RMAN> configure controlfile autobackup layout for tool kind disk to ‘$HOME/BACKUP/RMAN/ F.Bkp’; — $HOME/BACKUP/RMAN/ this can be any desired place.