Home / Oracle BPM

Oracle BPM Interview Questions

Rating: 5.0Blog-star
Views: 5682
by Ruchitha Geebu
Last modified: July 16th 2021

If you're looking for Oracle BPM Interview Questions for Experienced or Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle BPM has a market share of about 5.5%. So, You still have the opportunity to move ahead in your career in Oracle BPM Development. Mindmajix offers Advanced Oracle BPM Interview Questions 2019 that helps you in cracking your interview & acquire a dream career as Oracle BPM Developer.

Oracle BPM Interview Questions and Answers

1. How do you set up the RMAN tape backups?

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

2. What is the init parameter that specifies 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 number of days that Oracle keeps this information in the control file.

3. What is the difference between validating and crosscheck?

The restore … validate and validate backup set commands test whether you can restore backups or copies. You should use:

restore: validate when you want RMAN to choose which backups or copies should be tested.

validate backup set when you want to specify which backup sets should be tested.

If you would like to Enrich your career with an Oracle BPM certified professional, then visit Mindmajix - A Global online training platform: “Oracle BPM Training”  Course.  This course will help you to achieve excellence in this domain.

4. How do I go about backing up my online redo logs?

Online redo logs should never, ever be included in a backup, regardless of whether that backup is performed hot or cold. The reasons for this are two-fold. First, you physically cannot backup a hot online redo log, and second, there is precisely zero need to do so in the first place because an archive redo log is, by definition, a backup copy of a formerly online log. There is, however, a more practical reason: backing up the online logs yourself increases the risk that you will lose

5. What is a backup set?

RMAN can store backup data in a logical structure called a backup set, which is the smallest unit of an RMAN backup. A backup set contains the data from one or more data files, archived redo logs, or control files, or server parameter files.

MindMajix YouTube Channel

6. 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 between RMAN and a database instance. To enable the parallel backups, allocate multiple manual channels in the run block or configure parallelism

CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;

7. What is an auxiliary channel in RMAN? When do you need this?

An auxiliary channel is a link to an auxiliary instance. If you do not have automatic channels configured, then before issuing the DUPLICATE command, manually allocate at least one auxiliary channel within the same RUN command. When a Duplicate Database created or table space point in time recovery is performed Auxiliary database is used. This database can either on the same host or a different host.
Is it possible to specific tables when using the RMAN DUPLICATE feature? If yes, how?
No, table-based recovery not possible in RMAN duplicate command.

8. Outline the steps involved in CANCEL-based recovery from the full database from a hot backup?

RMAN doesn’t support cancel-based recovery like SQL*plus does.

9.Outline the steps involved in SCN based recovery from the full database from a hot backup?

startup mount;
restore database UNTIL SCN 233545;
recover database UNTIL SCN 233545;
alter database open resetlogs;

10. How do you verify the integrity of the image copy in the RMAN environment?

Use below commands :
rman> catalog datafilecopy ‘f:testsystem.dbf’;
rman> backup validate check logical datafile ‘f:testsystem.dbf’;
SQL> SELECT * FROM v$database_block_corruption;

11. Is it possible to take Catalog Database Backup using RMAN? If Yes, How?

A recovery catalog is a schema stored in a database that tracks backups and stores of target databases. So better to take an export backup How do you identify the expired, active, obsolete backups? Which RMAN command do you use?

Obsolete backups:
RMAN> report obsolete;
expired backup:
RMAN> list expired backup;
Active database: RMAN> list backup;

12. Outline the steps involved in TIME-based recovery from the full database from a hot backup?

startup mount;
restore 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’)”;
alter database open resetlogs;

13. Explain the steps to perform the point-in-time recovery with a backup that is taken before the resetlogs of the DB?

  • We need to list the database incarnations by using the list incarnation command.
  • shutdown the database
  • startup mount the database
  • Issue reset the database to incarnation to reset the incarnation.
  • Restore the database using the restore command (e.g restore until scn 23243)
  • recover database
  • Open the database using resetlogs command
RMAN> list incarnation of the database;
RMAN>reset the database to incarnation 5;
run
{
set until scn 234345;
restore database;
rec  ….

14. Outline the steps for changing the DBID in a cloned environment?

shutdown immediate
startup mount
Then, run the DBNEWID utility from the command line.

nid target =/
SQL> alter database open resetlogs;

15. 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:

1) Create a connection string at the catalog database.
2) At the catalog, the database creates one new user or uses an existing user and gives that user a recovery_catalog_owner privilege.
3)  Login into RMAN with the connection string

  • export ORACLE_SID
  • rman target catalog @connection string

4) rman&g ….

16. 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 a few

17. What is the difference between obsolete RMAN backups and expired RMAN backups?

The term obsolete does not mean the same as expired. In short obsolete means “not needed ” whereas expired means “not found.”
A status of “expired” means that the backup piece or backup set is not found in the backup destination. A status of “obsolete” means the backup piece is still available, but it is no longer needed. The backup piece is no longer needed since RMAN has been configured to no longer need this piece after so many days have elapsed, or so many backups have been performed. ….

18. When do you use the crosscheck command?

Crosscheck will be useful to check whether the catalog information is intact with OS-level information.

19. How do you clone the database using RMAN? Give brief steps

Two commands available in RMAN to clone the database:

  • Duplicate target database to …
  • Restore.

20. How do you identify the block corruption in the RMAN database? How do you fix it?

Typically, block corruption is reported in the following locations:
Results of the

 LIST FAILURE, VALIDATE, or BACKUP … VALIDATE 

command
The 

V$DATABASE_BLOCK_CORRUPTION

view
Error messages in standard output
The alert log
User trace files
Results of the SQL commands ANALYZE TABLE and ANALYZE INDEX
Results of the DBVERIFY utility
Third-party media management output
& ….

21. What is the difference between cumulative incremental and differential incremental backups?

Differential backup: This is the default type of incremental backup that backs up all blocks changed after the most recent backup at level n or lower. Cumulative backup: Back up all blocks changed after the most recent backup at level n-1 or lower.

22. How do you enable the auto backup for the controlfile using RMAN?

issue command at rman prompt…..
RMAN> configure controlfile autobackup on;
also, we can configure the controlfile backup format……
RMAN> configure controlfile autobackup format for device type disk to 

‘$HOME/BACKUP/RMAN/ F.bkp’; — $HOME/BACKUP/RMAN/

this can be any desired location.

23. How RMAN improves backup time?

RMAN backup time consumption is very less than compared to regular online backup as RMAN copies only modified blocks

24. How do you monitor RMAN backup job status.

Use this SQL to check

SQL> SELECT

 sid total work sofar FROM 

v$session_longops WHERE sid 153;


Here give SID when back start it will show SID

25. How do you see information about backups in RMAN?

 RMAN> List Backup;

26. What is the diff between CATALOG vs NOCATALOG?

The difference is only who maintains the backup records like when is the last successful backup incremental differential etc.

  • In CATALOG mode another database (TARGET database) stores all the information.
  • In NOCATALOG mode controlfile of the Target database is responsible.

27. Where RMAN keeps information of backups if you are using RMAN without Catalog?

RMAN keeps information of backups in the control file.

28. You have taken a manual backup of a data file using o/s. How RMAN will know about it? or How to put manual/user-managed backup in RMAN (recovery catalog)?

By using catalog command. You have to catalog that manual backup in RMAN’s repository by command

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

or

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


Restrictions:
> Accessible on disk
> A complete image copy of a single file

29) If some of the blocks are corrupted due to a system crash, How will you recover?

Using RMAN BLOCK RECOVER command

About Author

author
NameRuchitha Geebu
Author Bio

I am Ruchitha, working as a content writer for MindMajix technologies. My writings focus on the latest technical software, tutorials, and innovations. I am also into research about AI and Neuromarketing. I am a media post-graduate from BCU – Birmingham, UK. Before, my writings focused on business articles on digital marketing and social media. You can connect with me on LinkedIn.