Situation: Primary (Production) DB and Standby DB exists on 2 separate machines. We want to test the DR and then rebuild it from scratch.

In the process of performing this activity, I have a couple of doubts:

(Before Breaking DR)

1. Primary DB is in archivelog mode. So, generally, there is a frequency by which the archivelogs are generated. However, now, I would like to generate an archivelog at will. How do I go about it? Will it be absolutely harmless to the Primary DB? Are the below 2 statements sufficient to generate an archivelog at will? (no risk factor involved?)

SQL>alter system switch logfile;
SQL>alter system archive log current;

(After breaking DR, conducting the test, rebuilding the DR)

2. While taking cold backup of the primary DB, how do i take backup of the control file?

3. Do I need to take cold back up of temp files in temp tablespace of primary DB and restore them in the DR server?

4. The ORACLE_HOME OF primary and standby are different. However, I will be rebuilding the DR from the standby control file generated in the Primary DB. In that case, will it create a conflict in DR (standby DB)?

Thanks in Advance!

Abhishek G
Kolkata, India

select name from v$controlfile
union all
select name from v$datafile
union all
select member from v$logfile
union all
select name from v$tempfile