Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
You need to apply at least one log generated after the control file was backed up, possibly more. So in your backup you should backup the data files with the control file, then backup the archive logs. You should not backup the control file after you backup the archive logs.
but my qusetion in details:
1. at 10 am from crontab
(1a. alter database backup controlfile to trace as ' /path/'
(1b alter database begin backup
at 10.30 am - backup begin through veritas server.
at 11.30 am ---backup end through veritas server.
2. at 12.10 pm from crontab
(2a. alter database end backup).
in this CASE i should have arhives atleast before 10 am --- till 12.10 pm + atleast 2 archive after end backup (12.10 pm)
BUT in this case TAPES will be having archives till-11.30 am , SO if i am restoring the backup to some other servers it is of no gud.
1)NOW i want to know how i can bring the DB UP?
2) I should create control file before begin backup or after end backup?
( As far my understanding i should create it before begin backup ( as SCN detail will be old one in control file) plz correct if i am wrong.