We're here to help!

Copy ASM password file from Primary to Standby

Follow

Read our docs 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
 
 
Have more questions? Submit a request

Comments