Home What is Oracle? Oracle Training Tutorials for Beginners Difference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11g Ora 28001 The Password Has Expired Error Cache and Nocache in Oracle Sequence BR*Tools Documentation ORA-01455: Converting Column Overflows Integer Datatype Oracle Wait Events Interview Questions Difference Between Primary, Secondary and Clustered Indexes in DBMS Difference Between Hot and Cold Backup Oracle Partitioning Interview Questions Update Statement Works in Oracle Architecture Differences Between SAP HANA and Oracle Group Functions Ignore Null Values in Processed Column ORA-10458: Standby Database Requires Recovery Oracle Interview Questions

Important RMAN Interview Questions and Answers

Updated May 19, 2018

Important FAQ's on RMAN asked by Interviewers.

I have few questions on RMAN. Please guide.

1.1 IF I DO RESTORE second time, WILL IT SKIP already backed up datafile and archivelog file FILE AND skip RESTORE them AGAIN?

1.2 Is that because of backup optimization on?

2 ) CAN I SCHEDULE FULL BACKUP like basically same cron same time FROM BOTH THE NODES.? Does it start backing up twice or its one process logically. How does this work, if possible.

3) What is the difference between active clone and dbrefresh?

4) In order to find SCN for PITR. How can I find what was SCN earlier when human error happened?

Thanks In advance!!

Comments

31 Aug 2015 2:19 pm Abhijeet Mudgal Helpful Answer

Hello Sugandh,
Please be more clear about your first question, I did not get it.....
And the rest answer are following
2) you cannot run multiple rman backups parallely.

3) Active duplication involves no backup. the required files are transferred to the destination via network whereas normal duplication/clone/db refresh involves taking a backup on source then transferring files to dest and restore/recover/duplicate.
4) Simple check with the user who commited the error .of course you cannot pin point the exact time unless you use logminer to look at the sql statement execution time.