This discussion is archived
6 Replies Latest reply: Sep 29, 2013 2:27 AM by Baris Yildirim RSS

Standby Redo Log Files and Directory Structure in Standby Site

vk82 Explorer
Currently Being Moderated

Hi Guru's

 

I just want to confirm, i know that if the Directory structure is different i need to mention these 2 parameter in pfile

on primary site:

DB_CONVERT_DATAFILE='standby','primary'

LOG_CONVERT_DATAFILE='standby','primary'

 

On secondary Site:

DB_CONVERT_DATAFILE='primary','standby'

LOG_CONVERT_DATAFILE='primary','standby'

 

 

But i want to confirm this wheather i need to issue the complete path of the directory in both the above paramtere:

like:

DB_CONVERT_DATAFILE='/u01/oracle/app/oracle/oradata/standby','/u01/oracle/app/oracle/oradata/primary'

LOG_CONVERT_DATAFILE='/u01/oracle/app/oracle/oradata/standby','/u01/oracle/app/oracle/oradata/primary'

 

Second Confusion:-

 

After transferring Redo Standby log files created on primary and taken to standby on the above mentioned directory structure and after restoring the backup of primary db alongwith the standby control file will not impact the physical standby redo log placed on the above mentioned location.

 

Thanks in advance for your help

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points