YouTube Icon

Interview Questions.

Top 30 Oracle Bpm Interview Questions - Jul 26, 2022

fluid

Top 30 Oracle Bpm Interview Questions

Q1. How Do You Monitor Rman Backup Job Status?

Use this SQL to check

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

Here deliver SID while lower back begin it will display SID

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

Using RMAN BLOCK RECOVER command

Q3. Outline The Steps Involved In Cancel Based Recovery From The Full Database From Hot Backup?

RMAN doesn’t assist cancel-based restoration like SQL*plus does.

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

The term out of date does not suggest the same as expired. In short obsolete me “not wanted ” while expired me “now not observed.”

A status of “expired” me that the backup piece or backup set isn't always located within the backup destination. A status of “out of date” me the backup piece remains to be had, but it's miles now not needed. The backup piece is not wanted since RMAN has been configured to now not want this piece after such a lot of days have elapsed, or so many backups were done.

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

Shutdown Immediate

startup mount 

Then, run the the DBNEWID application from command line.

Nid target =/

SQL> modify database open resetlogs;

Q6. What Is Auxiliary Channel In Rman? When Do You Need This?

An auxiliary channel is a link to auxiliary instance. If you do no longer have automated channels configured, then before issuing the DUPLICATE command, manually allocate as a minimum one auxiliary channel in the identical RUN command. When a Duplicate Database created or table area point in time recovery is accomplished Auxiliary database is used. This database can either on the same host or a exclusive host.

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

Differential backup: This is the default form of incremental backup which backs up all blocks modified after the most recent backup at level n or decrease.

Cumulative backup: Backup all blocks changed after the most latest backup at level n-1 or lower.

Q8. Where Rman Keeps Information Of Backups If You Are Using Rman Without Catalog?

RMAN keeps records of backups within the manage file.

Q9. How Do You Install The Rman Recovery Catalog? Or List The Steps Required To Enable The Rman . Backup For A Target Database?

Steps to be followed:

Create connection string at catalog database.

At catalog database create one new person or use existing person and supply that consumer a recovery_catalog_owner privilege.

Login into RMAN with connection string

export ORACLE_SID

rman goal catalog @connection string

rman&g ….

Q10. How Do You Enable The Autobackup For The Controlfile Using Rman?

Trouble command at rman set off…..

RMAN> configure controlfile autobackup on;

also we will configure controlfile backup layout……

RMAN> configure controlfile autobackup layout for device type disk to ‘$HOME/BACKUP/RMAN/ F.Bkp’; — $HOME/BACKUP/RMAN/ this could be any preferred area.

Q11. Outline The Steps Involved In Time Based Recovery From The Full Database From Hot Backup?

Startup mount;

repair database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;

get better database UNTIL TIME “TO_DATE(’28/12/2012 18:00:00′, ‘DD/MM/YYYY HH24:MI:SS’)”;

regulate database open resetlogs;

Q12. What Is Backup Set?

RMAN can shop backup statistics in a logical shape called a backup set, that is the smallest unit of an RMAN backup. A backup set contains the information from one or greater data files, archived redo logs, or manage files or server parameter record.

Q13. When Do You Use Crosscheck Command?

Crosscheck might be useful to check whether the catalog statistics is unbroken with OS degree data.

Q14. Explain The Steps To Perform The Point In Time Recovery With A Backup Which Is Taken Before The Resetlogs Of The Db?

We want to list the database incarnations by the usage of list incarnation command.

Shutdown the database

startup mount the database

Issue reset database to incarnation to reset the incarnation.

Restore the database the use of restore command (e.G repair till scn 23243)

get better database

Open the database the usage of resetlogs command

RMAN> list incarnation of database;

RMAN>reset database to incarnation five;

run

set until scn 234345;

restore database;

rec  ….

Q15. How Do You Identify The Expired, Active, Obsolete Backups? Which Rman Command You Use?

Obsolete backups:

RMAN> document out of date;

expired backup:

RMAN> listing expired backup;

Active database: RMAN> list backup;

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

No, desk primarily based restoration no longer feasible in RMAN duplicate command.

Q17. List Some Of The Rman Catalog View Names Which Contain The Catalog Information?

RC_DATABASE_INCARNATION, RC_BACKUP_COPY_DETAILS, RC_BACKUP_CORRUPTION, RC_BACKUP_DATAFILE_SUMMARY to name some

Q18. How Do You See Information About Backups In Rman?

RMAN> List Backup;

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

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

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

Q20. What Is The Difference Between Validate And Crosscheck ?

The restore/validate and validate backupset instructions take a look at whether you can restore backups or copies.

You have to use:

repair : validate while you need RMAN to pick out which backups or copies must be examined.

Validate backupset when you want to specify which backup sets need to be tested.

Q21. How Rman Improves Backup Time?

RMAN backup time consumption could be very less than compared to ordinary on line backup as RMAN copies only changed blocks.

Q22. Outline The Steps Involved In Scn Based Recovery From The Full Database From Hot Backup?

Startup mount;

repair database UNTIL SCN 233545;

get better database UNTIL SCN 233545;

modify database open resetlogs;

Q23. Is It Possible To Take Catalog Database Backup Using Rman? If Yes, How?

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

Q24. What Is The Diff Between Catalog And Nocatalog?

The difference is handiest who keeps the backup data like when is the last a hit backup incremental differential etc.

In CATALOG mode some other database (TARGET database) stores all of the facts.

In NOCATALOG mode controlfile of Target database is responsible.

Q25. How Do You Setup The Rman Tape Backups?

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

Q26. How Do I Go About Backing Up My Online Redo Logs?

Online redo logs have to in no way, ever be protected in a backup, irrespective of whether or not that backup is accomplished warm or bloodless. The reasons for this are two-fold. First, you physically can not backup a hot online redo log, and 2nd there's precisely 0 want to accomplish that within the first vicinity because an archive redo log is, with the aid of definition, a backup copy of a previously on line log. There is, but, a extra practical motive: backing up the net logs yourself increases the threat that you'll lose.

Q27. How Do You Verify The Integrity Of The Image Copy In Rman Environment?

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;

Q28. What Is The Init Parameter Specify The Minimum Number Of Days That Oracle Keeps Backup Information In The Control File?

You can use the CONTROL_FILE_RECORD_KEEP_TIME parameter to specify the minimum quantity of days that Oracle continues this statistics within the manage file.

Q29. What Is Level 0, Level 1 Backup?

A degree zero incremental backup, that is the base for subsequent incremental backups, copies all blocks containing data, backing the information file up into a backup set simply as a complete backup might. A stage 1 incremental backup may be either of the subsequent kinds:

A differential backup, which backs up all blocks modified after the maximum recent incremental backup at level 1 or zero

A cumulative backup, which backs up all blocks changed after the most current incremental backup at stage zero

Q30. You Have Taken A Manual Backup Of A Datafile Using O/s. How Rman Will Know About It? Or How To Put Manual/consumer-controlled Backup In Rman (restoration Catalog)?

By the usage of catalog command.You should catalog that manual backup in RMAN’s repository by means of command 

RMAN> catalog datafilecopy ‘/DB01/BACKUP/users01.Dbf’;

or

RMAN> CATALOG START WITH ‘/tmp/backup.Ctl’;

Restrictions:

> Accessible on disk

> A whole image replica of a unmarried document




CFG