Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

standby pdb's datafile not in right location while create pdbs in primary (single to rac)

edited Sep 19, 2020 5:03AM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 3 commentsAnswered

oracle 12.2.0.1 active data guard ,primary is single ,phisical standby is rac。

some standby parameter:

enabled_pdbs_on_standby='ssdpdb1','ssdpdb3'

db_create_file_dest ='+SSDDG'

use this sql to create pdb

create pluggable database ssdpdb1 admin user xxx identified by xxxxx STANDBYS=ALL;

the datafiles in standby is in $ORACLE_HOME/dbs not in ASM DISKGROUP  'SSDDG'

and use this sql to create pdb

create pluggable database ssdpdb1 admin user pdbadmin identified by oracle file_name_convert=('/data/SSDDB/AE34ECC896200A71E05378B40A0A2241/','+SSDDG/SSDDBN/ssdpdb1') STANDBYS=ALL;

error  is

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center