11gRAC local data file migration to ASM
Environment related:
OS: CentOS release 6.6
RAC: 11.2.0.4.0 dual node ASM Library
1. Cause of failure
Today, four data files are added in batches. add datafile '+ DATADG' in the second to fourth data file add SQL misses' + '. After oracle successfully adds the first data file, it is found that the second data fil ...
Added by grahamb314 on Fri, 01 May 2020 22:00:41 +0300
Duplicate replicates the database and creates a physical StandBy (pfile version)
1 the setting environment is as follows:
Primary database
IP
172.17.22.16
SID
orcl
Standby database
IP
172.17.22.17
SID
orcl
Set prompts to distinguish the location of operations
primary database
set SQLPROMPT Primary>
standby database
set SQLPROMPT StandBy>
1. Set Archive Mode + force log on Primary side
Make sure the pri ...
Added by kaoskorruption on Sun, 05 Jan 2020 18:54:41 +0200