Database Software

Hi Guys,

I'm using control file as rman repository. Currently I have this backup running at 8pm nightly:

backup full filesperset 4 format '/Data_%d_%U/' (database);
sql 'alter system switch logfile';
sql 'alter system archive log current';
crosscheck archivelog all;
backup format 'arch_%s_%p_%t' archivelog all ;
delete archivelog all completed before 'sysdate-3';

And archive log backup running 7am, 11am, 4pm.


Have a few queries:

1. Understand that with the above, control file backup will also be included as RMAN automatically includes the control file and SPFILE in backups of datafile 1.
So in any case when my control file is accidentally deleted from server, I still can restore it from the backup right?
I believe i will need to set the db id first as control file is my repository. If control is missing, it can identify the control file to restore by setting db id?
2. my control autobackup is set to off. what is the different between control file backup taken via autobackup as compared to 1?
understand that controlfile autobackup is good as it will auto backup if there is any change in the db (like created new file, etc). Any other difference?
3.
•Run BACKUP CURRENT CONTROLFILE
•Include a backup of the control file within any backup by using the INCLUDE CURRENT CONTROLFILE option of the BACKUP command
What is the difference with such backup as compared to controlfile backup taken in item 1 and 2?

4. lastly, if my control file + datafiles + arch + redo is accidentally deleted at 6pm. I restored the control file taken at yesterday 8pm. Since the control file only consist of backup information of 8pm and before, how do i restore the rest of the arch logs taken at 7am, 11am, 4pm?



thanks