Backup Standy Database and restore using Duplicate Database
Ok, here's my situation. I am backing up my 11.1.0.6 database from the standby server (backing up from primary is not allowed, which has ruled out an active duplicate) using a recovery catalog. My goal is to restore this database as another name called (TEST) on another server using the duplicate database command. My questions are:
(1) I know I can backup my standby database using RMAN but do I have to backup the control file and spfile from the primary database as well?
(2) I am using a recovery catalog (which I have already registered the primary database only with), do I have to register the backup pieces from the above backup with the recovery catalog (or are they already registered since I connected to the catalog when taking the backup of the standby database?)
(3) If I need to backup up the primary controlfile, can I manually copy the file to the new server or should I create it by issuing a "backup controlfile to trace" command on the primary database server and recreate it.
I guess my sticking points would be how to issue the duplicate database command once I have all the pieces. If I am missing something please let me know. This is a 1.5TB database and I only have one(1) time to get this right. Lucky me....Thanks everyone