This article explains how to copy an ASM password file from Primary to Standby database.
Problem Details
Problem Statement
Manual steps to copy an ASM password file from Primary to the Standby.
Not currently handled by Standby 8.0.10
Applicable Error Code
n/a
Affected Versions
8.0.10
Affected Platforms
Windows
Description
Manual steps to copy an ASM password file from Primary to the Standby.
Solution
Manual steps to copy an ASM password file from Primary to the Standby.
Steps Performed
Copy the primary ASM PWD file from ASM to a temp location in filesystem (on the primary node)
> su grid
> . oraenv => +ASM1
> asmcmd
> pwcopy --dbuniquename sgpfpdc +DATA/SGPFPDC/PASSWORD/pwdsgpfpdc.256.915702925 V:\dbvisitrepl\dbvisit_backup\SGPFPDC\pwdsgpfpdc
Transfer the PWD file to a temp location on the standby
dbvctl -d sgpfpdc -f transfer_file -a source_file_name=V:\dbvisitrepl\dbvisit_backup\SGPFPDC\pwdsgpfpdc dest_file_name=V:\dbvisitrepl\dbvisit_backup\SGPFPDC\pwdsgpfpdc
Copy the PWD file V:\dbvisitrepl\dbvisit_backup\SGPFPDC\pwdsgpfpdc to OS default location ORACLE_HOME\database on both standby nodes:
on the node that runs ORACLE_SID=sgpfpdc_1 to C:\app\oracle\product\12.1.0\dbhome_1\database\PWDsgpfpdc_1.ORA
on the node that runs ORACLE_SID=sgpfpdc_2 to C:\app\oracle\product\12.1.0\dbhome_1\database\PWDsgpfpdc_2.ORA
Comments