Friday, December 27, 2013

replicate controlfile or restore controlfile

something i noticed today

I remember that once i used following in rman

 replicate controlfile from '/export/home/oracle/control_ACP1.cont';

I thought it would also update the spfile however that seemed not the case.

how ever what automatically updates the spfile is the following

RMAN> restore controlfile from '/export/home/oracle/control_ACP1.cont';

Starting restore at 27-DEC-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=110 instance=EUACP11 device type=DISK

channel ORA_DISK_1: copied control file copy
output file name=+DATADG1/euacp1/controlfile/current.4907.835270147
output file name=+ARCHDG1/euacp1/controlfile/current.16585.835270147

Finished restore at 27-DEC-13