Oracle BPM Interview Questions
1.What is the business process management?
Ans: Business process management (BPM) is a systematic approach to making an organization’s workflow more effective, more efficient, and more capable of adapting to an ever-changing environment. A business process is an activity or set of activities that will accomplish a specific organizational goal.
2.What is the definition of process management?
Ans: Process management is the ensemble of activities of planning and monitoring the performance of a business process. The term usually refers to the management of business processes and manufacturing processes. Business process management (BPM) and business process re-engineering are interrelated, but not identical.
3.What is the BPM industry?
Ans: Business process management (BPM) is a field in operations management that focuses on improving corporate performance by managing and optimizing a company’s business processes. It can therefore be described as a “process optimization process.” know more at Oracle Bpm online training
4.What is Level 0, Level 1 backup?
Ans: A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data, backing the data file up into a backup set just as a full backup would. A level 1 incremental backup can be either of the following types:
A differential backup, which backs up all blocks changed after the most recent incremental backup at level 1 or 0
A cumulative backup, which backs up all blocks changed after the most recent incremental backup at level 0
5.How do you set up the RMAN tape backups?
Ans: Configure the channel as SBT_TAPE and use the “ENV” parameter to set the tape configurations. know more at Oracle bpm training
6.What is the init parameter specify the minimum number of days that Oracle keeps backup information in the control file?
Ans: 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.
7.What is the difference between validating and crosscheck?
Ans: The restore … validate and validate backupset 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.
8.How do I go about backing up my online redo logs?
Ans: 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 redoes log is, by definition, a backup copy of a formerly on-line log. There is, however, a more practical reason: backing up the online logs yourself increases the risk that you will lose
9.What is the backup set?
Ans: 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 file.
10.What is Channel? How do you enable the parallel backups with RMAN?
Ans: 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;
11.What is an auxiliary channel in RMAN? When do you need this?
Ans: 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 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.
12.Is it possible to specific tables when using the RMAN DUPLICATE feature? If yes, how?
Ans: No, table-based recovery not possible in RMAN duplicate command.
13.Outline the steps involved in CANCEL based recovery from the full database from a hot backup?
Ans: RMAN doesn’t support cancel-based recovery as SQL*plus does.
14.Outline the steps involved in SCN based recovery from the full database from a hot backup?
Ans: startup mount; restore database UNTIL SCN 233545; recover database UNTIL SCN 233545; alter database open resetlogs;
15.How do you verify the integrity of the image copy in the RMAN environment?
Ans:
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;
16.Outline the steps involved in TIME-based recovery from the full database from a hot backup?
Ans: 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;
17.Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the DB?
Ans:
- We need to list the database incarnations by using list incarnation command.
- Shutdown the database
- Startup mount the database
- Issue reset database to incarnation to reset the incarnation.
- Restore the database using restore command (e.g restore until scn 23243)
- Recover database
- Open the database using resetlogs command
18.List some of the RMAN catalog view names which contain the catalog information?
Ans: RC_DATABASE_INCARNATION, RC_BACKUP_COPY_DETAILS, RC_BACKUP_CORRUPTION, RC_BACKUP_DATAFILE_SUMMARY to name a few
19.What is the difference between obsolete RMAN backups and expired RMAN backups?
Ans: 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.
20.When do you use crosscheck command?
Ans: Crosscheck will be useful to check whether the catalog information is intact with OS-level information. know more at Oracle bpm training course
21.How do you clone the database using RMAN? Give brief steps?
Ans: Two commands available in RMAN to clone data base
1) Duplicate target database to …
2) Restore.
