Oracle BPM Interview Questions
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.
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
Ans: Configure the channel as SBT_TAPE and use the "ENV" parameter to set the tape configurations.
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.
If you want to enrich your career and become a professional in Oracle BPM, then visit Tekslate - a global online training platform: "Oracle BPM Training" This course will help you to achieve excellence in this domain.
Ans: The restore ... validate and validate backupset commands test whether you can restore backups or copies. You should use:
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
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.
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;
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.
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;
Checkout Our Frequently Asked Oracle BPM Tutorials
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;
Ans:
RMAN> list incarnation of database;
RMAN>reset database to incarnation 5;
run
{
set until scn 234345;
restore database;
rec ....
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
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.
Ans: Crosscheck will be useful to check whether the catalog information is intact with OS-level information.
21.How do you clone the database using RMAN? Give brief steps?Ans: Two commands available in RMAN to clone database:
1) Duplicate target database to ...
2) Restore.
22.What is the difference between cumulative incremental and differential incremental backups?Ans: Differential backup: This is the default type of incremental backup which backs up all blocks changed after the most recent backup at level n or lower.
Cumulative backup: Backup all blocks changed after the most recent backup at level n-1 or lower.
23.How RMAN improves backup time?Ans: RMAN backup time consumption is very less than compared to regular online backup as RMAN copies only modified blocks.
24.What is the diff between CATALOG vs NOCATALOG?Ans: 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 Target database is responsible.
25.If some of the blocks are corrupted due to system crash, How will you recover?Ans: Using RMAN BLOCK RECOVER command
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
