Shulou(Shulou.com)06/01 Report--

1. When you use RMAN to copy the standby database, you need to copy the RAC password file to the standby database, because the ORACLE12C RAC password file

On ASM, you first need to copy it to the file system.

2. Confirm the location of the password file:

ASMCMD > ls

1112560FDF1A273AE05362B51AAC43B4/

111287D3DD272EB4E05362B51AAC7F13/

CONTROLFILE/

DATAFILE/

DD7C48AA5A4404A2E04325AAE80A403C/

ONLINELOG/

PARAMETERFILE/

PASSWORD/

TEMPFILE/

Orapworarac

Spfileorarac.ora

ASMCMD > pwd

+ data/orarac

You can see that the password file is'+ DATA/ORARAC/orapworarac'

3. Use Oracle package to copy password files to the file system:

SQL > create or replace directory source_dir as'+ data/orarac'

Directory created.

SQL > create or replace directory dest_dir as'/ home/oracle'

Directory created.

SQL > begin

2 dbms_file_transfer.copy_file (

3 source_directory_object = > 'source_dir'

4 source_file_name = > 'orapworarac'

5 destination_directory_object = > 'dest_dir'

6 destination_file_name = > 'orapworarac'

7)

8 end

9 /

PL/SQL procedure successfully completed.

4. View

[oracle@rac1 ~] $ls-l orapw*

-rw-r- 1 oracle asmadmin 7680 Mar 26 08:04 orapworarac

The file has been copied over.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.