Description:-
In this is the article we are going to see step-by-step to Creating Oracle 19c Standby Database For A Pluggable Data
Demo:-
set lines 200
col name forma a20
select con_id, name,open_mode, restricted from v$pdbs;
CON_ID NAME OPEN_MODE RES
———- ——————– ———- —
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
The environment is Multitenant database.
Environment Details:-
Primary Server side Configurations:-
Step1:-Change Archivelog mode,Flashback and force logging mode
[oracle@prod19c ~]$ export ORACLE_SID=ind21
[oracle@prod19c ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Tue Dec 17 12:46:36 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> startup mount
ORACLE instance started.
Total System Global Area 1157627856 bytes
Fixed Size 9134032 bytes
Variable Size 301989888 bytes
Database Buffers 838860800 bytes
Redo Buffers 7643136 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> ALTER DATABASE FORCE LOGGING;
Database altered.
SQL> alter database flashback on;
Database altered.
SQL> select name,force_logging,log_mode,flashback_on from v$database;
NAME FORCE_LOGGING LOG_MODE FLASHBACK_ON
——— ————— ——– ————-
IND21 YES ARCHIVELOG YES
Step2:-Adding Redologfile for standby database
alter database add standby logfile group 4 ‘/u01/app/oracle/oradata/IND21/redo04.log’ size 200m;
Database altered.
alter database add standby logfile group 5 ‘/u01/app/oracle/oradata/IND21/redo05.log’ size 200m;
Database altered.
alter database add standby logfile group 6 ‘/u01/app/oracle/oradata/IND21/redo06.log’ size 200m;
Database altered.
alter database add standby logfile group 7 ‘/u01/app/oracle/oradata/IND21/redo07.log’ size 200m;
Database altered.
SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
GROUP# THREAD# SEQUENCE# ARC STATUS
———- ———- ———- — ———-
4 0 0 YES UNASSIGNED
5 0 0 YES UNASSIGNED
6 0 0 YES UNASSIGNED
7 0 0 YES UNASSIGNED
Step3:-Adding the network entry in primary and standby side(Both servers)
Step3:-Adding the network entry in primary and standby side(Both servers)
Tnsnames.ora
IND21 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prod19c)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ind21)
)
)
IND21STBY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dev19c)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ind21stby)
)
)
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ind21)
(ORACLE_HOME = /u01/app/oracle/product/19.3.0/db_1)
(SID_NAME = ind21)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = prod19c)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
[oracle@prod19c admin]$ tnsping ind21
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 17-DEC-2019 15:43:21
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.143)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ind21)))
OK (10 msec)
[oracle@prod19c admin]$ tnsping ind21stby
TNS Ping Utility for Linux: Version 19.0.0.0.0 – Production on 17-DEC-2019 15:43:24
Copyright (c) 1997, 2019, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.144)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ind21stby)))
OK (0 msec)
step4:-Changing parameters in primary database
ALTER SYSTEM SET log_archive_config=’dg_config=(ind21,ind21stby)’ SCOPE=both;
System altered.
ALTER SYSTEM SET log_archive_dest_1=’location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=ind21′ SCOPE=both;
System altered.
ALTER SYSTEM SET log_archive_dest_2=’service=ind21stby async valid_for=(online_logfiles,primary_role) db_unique_name=ind21stby’ SCOPE=both;
System altered.
ALTER SYSTEM SET fal_server=’ind21stby’ SCOPE=both;
System altered.
ALTER SYSTEM SET fal_client=’ind21′ SCOPE=both;
System altered.
ALTER SYSTEM SET standby_file_management=’AUTO’ SCOPE=both;
System altered.
Check using the below query.
select name, value
from v$parameter
where name in (‘db_name’,’db_unique_name’,’log_archive_config’,
‘log_archive_dest_1′,’log_archive_dest_2’,
‘log_archive_dest_state_1′,’log_archive_dest_state_2’,
‘remote_login_passwordfile’, ‘log_archive_format’, ‘log_archive_max_processes’,
‘fal_server’,’db_file_name_convert’, ‘log_file_name_convert’, ‘standby_file_management’);
Step5:- Password file creation
copy the remote login password file (orapwind21) from the primary database server to the $ORACLE_HOME/dbs directory on the
standby database server, renaming it to orapwind21stby.
[oracle@prod19c admin]$ cd $ORACLE_HOME/dbs
[oracle@prod19c dbs]$ scp orapwind21 oracle@192.168.201.144:$ORACLE_HOME/dbs
The authenticity of host ‘192.168.201.144 (192.168.201.144)’ can’t be established.
ECDSA key fingerprint is SHA256:9ngU7dHd3U+4VprdmTolulpeCnX3zlJKbX2qqXMgZSg.
ECDSA key fingerprint is MD5:f8:69:0d:e3:68:0d:24:30:cf:e3:17:6c:7a:59:05:94.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added ‘192.168.201.144’ (ECDSA) to the list of known hosts.
oracle@192.168.201.144’s password:
orapwind21 100% 2048 183.3KB/s 00:00
Standby Side
[oracle@dev19c dbs]$ mv orapwind21 orapwind21stby
Step6:- Changing parameters in standby database
In the $ORACLE_HOME/dbs directory of the standby system, create an initialization parameter file named initind21stby.ora Containing a single parameter: DB_NAME=ind21
[oracle@dev19c dbs]$ vi initind21stby.ora
[oracle@dev19c dbs]$ cat initind21stby.ora
db_name=ind21
enable_pluggable_database=true
[oracle@dev19c dbs]$ pwd
/u01/app/oracle/product/19.3.0/db_1/dbs
Step7:- Create directory Structure in Standby database
[oracle@dev19c ~]$ mkdir -p /u01/app/oracle/oradata/IND21STBY/
[oracle@dev19c ~]$ mkdir -p /u01/app/oracle/oradata/IND21/pdbseed/
[oracle@dev19c ~]$ mkdir -p /u01/app/oracle/oradata/IND21/pdb/
[oracle@dev19c ~]$ mkdir -p /u01/app/oracle/fast_recovery_area
[oracle@dev19c ~]$ mkdir -p/u01/app/oracle/admin/ind21stby/adump/
Step8:- start the standby database using pfile
SQL> startup pfile=’initind21stby.ora’ nomount
ORACLE instance started.
Total System Global Area 297795128 bytes
Fixed Size 9133624 bytes
Variable Size 234881024 bytes
Database Buffers 50331648 bytes
Redo Buffers 3448832 bytes
Step9:- connect to the rman
[oracle@dev19c adump]$ rman target sys/oracle@ind21 auxiliary sys/oracle@ind21stby
Recovery Manager: Release 19.0.0.0.0 – Production on Tue Dec 17 17:09:18 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: IND21 (DBID=1941097789)
connected to auxiliary database: IND21 (not mounted)
Step10:-Build the oracle 19c standby using rman active duplicate method
RMAN> run
{
allocate channel p1 type disk;
allocate channel p2 type disk;
allocate channel p3 type disk;
allocate channel p4 type disk;
allocate auxiliary channel s1 type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert ‘ind21′,’ind21stby’
set db_name=’ind21′
set db_unique_name=’ind21stby’
set diagnostic_dest=’/u01/app/oracle/admin/ind21stby/adump/’
set db_file_name_convert=’/u01/app/oracle/oradata/ind21/’,’/u01/app/oracle/oradata/ind21stby/’
set log_file_name_convert=’/u01/app/oracle/oradata/ind21/’,’/u01/app/oracle/oradata/ind21stby/’
set control_files=’/u01/app/oracle/oradata/ind21stby/standby1.ctl’
set log_archive_max_processes=’5′
set fal_client=’ind21stby’
set fal_server=’ind21′
set standby_file_management=’AUTO’
set log_archive_config=’dg_config=(ind21,ind21stby)’
set compatible=’19.0.0.0.0′
set memory_target=’1500m’
nofilenamecheck;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25>
using target database control file instead of recovery catalog
allocated channel: p1
channel p1: SID=90 device type=DISK
allocated channel: p2
channel p2: SID=82 device type=DISK
allocated channel: p3
channel p3: SID=71 device type=DISK
allocated channel: p4
channel p4: SID=75 device type=DISK
allocated channel: s1
channel s1: SID=39 device type=DISK
Starting Duplicate Db at 17-DEC-19
contents of Memory Script:
{
backup as copy reuse
passwordfile auxiliary format ‘/u01/app/oracle/product/19.3.0/db_1/dbs/orapwind21stby’ targetfile
‘/u01/app/oracle/product/19.3.0/db_1/dbs/spfileind21.ora’ auxiliary format
‘/u01/app/oracle/product/19.3.0/db_1/dbs/spfileind21stby.ora’ ;
sql clone “alter system set spfile= ”/u01/app/oracle/product/19.3.0/db_1/dbs/spfileind21stby.ora””;
}
executing Memory Script
Starting backup at 17-DEC-19
Finished backup at 17-DEC-19
sql statement: alter system set spfile= ”/u01/app/oracle/product/19.3.0/db_1/dbs/spfileind21stby.ora”
contents of Memory Script:
{
sql clone “alter system set audit_file_dest =
”/u01/app/oracle/admin/ind21stby/adump” comment=
”” scope=spfile”;
sql clone “alter system set dispatchers =
”(PROTOCOL=TCP) (SERVICE=ind21stbyXDB)” comment=
”” scope=spfile”;
sql clone “alter system set db_name =
”ind21” comment=
”” scope=spfile”;
sql clone “alter system set db_unique_name =
”ind21stby” comment=
”” scope=spfile”;
sql clone “alter system set diagnostic_dest =
”/u01/app/oracle/admin/ind21stby/adump/” comment=
”” scope=spfile”;
sql clone “alter system set db_file_name_convert =
”/u01/app/oracle/oradata/ind21/”, ”/u01/app/oracle/oradata/ind21stby/” comment=
”” scope=spfile”;
sql clone “alter system set log_file_name_convert =
”/u01/app/oracle/oradata/ind21/”, ”/u01/app/oracle/oradata/ind21stby/” comment=
”” scope=spfile”;
sql clone “alter system set control_files =
”/u01/app/oracle/oradata/ind21stby/standby1.ctl” comment=
”” scope=spfile”;
sql clone “alter system set log_archive_max_processes =
5 comment=
”” scope=spfile”;
sql clone “alter system set fal_client =
”ind21stby” comment=
”” scope=spfile”;
sql clone “alter system set fal_server =
”ind21” comment=
”” scope=spfile”;
sql clone “alter system set standby_file_management =
”AUTO” comment=
”” scope=spfile”;
sql clone “alter system set log_archive_config =
”dg_config=(ind21,ind21stby)” comment=
”” scope=spfile”;
sql clone “alter system set compatible =
”19.0.0.0.0” comment=
”” scope=spfile”;
sql clone “alter system set memory_target =
1500m comment=
”” scope=spfile”;
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script
sql statement: alter system set audit_file_dest = ”/u01/app/oracle/admin/ind21stby/adump” comment= ”” scope=spfile
sql statement: alter system set dispatchers = ”(PROTOCOL=TCP) (SERVICE=ind21stbyXDB)” comment= ”” scope=spfile
sql statement: alter system set db_name = ”ind21” comment= ”” scope=spfile
sql statement: alter system set db_unique_name = ”ind21stby” comment= ”” scope=spfile
sql statement: alter system set diagnostic_dest = ”/u01/app/oracle/admin/ind21stby/adump/” comment= ”” scope=spfile
sql statement: alter system set db_file_name_convert = ”/u01/app/oracle/oradata/ind21/”, ”/u01/app/oracle/oradata/ind21stby/” comment= ”” scope=spfile
sql statement: alter system set log_file_name_convert = ”/u01/app/oracle/oradata/ind21/”, ”/u01/app/oracle/oradata/ind21stby/” comment= ”” scope=spfile
sql statement: alter system set control_files = ”/u01/app/oracle/oradata/ind21stby/standby1.ctl” comment= ”” scope=spfile
sql statement: alter system set log_archive_max_processes = 5 comment= ”” scope=spfile
sql statement: alter system set fal_client = ”ind21stby” comment= ”” scope=spfile
sql statement: alter system set fal_server = ”ind21” comment= ”” scope=spfile
sql statement: alter system set standby_file_management = ”AUTO” comment= ”” scope=spfile
sql statement: alter system set log_archive_config = ”dg_config=(ind21,ind21stby)” comment= ”” scope=spfile
sql statement: alter system set compatible = ”19.0.0.0.0” comment= ”” scope=spfile
sql statement: alter system set memory_target = 1500m comment= ”” scope=spfile
Oracle instance shut down
connected to auxiliary database (not started)
Oracle instance started
Total System Global Area 1577055360 bytes
Fixed Size 9135232 bytes
Variable Size 721420288 bytes
Database Buffers 838860800 bytes
Redo Buffers 7639040 bytes
allocated channel: s1
channel s1: SID=35 device type=DISK
contents of Memory Script:
{
backup as copy current controlfile for standby auxiliary format ‘/u01/app/oracle/oradata/ind21stby/standby1.ctl’;
}
executing Memory Script
Starting backup at 17-DEC-19
channel p1: starting datafile copy
copying standby control file
output file name=/u01/app/oracle/product/19.3.0/db_1/dbs/snapcf_ind21.f tag=TAG20191217T171107
channel p1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 17-DEC-19
contents of Memory Script:
{
sql clone ‘alter database mount standby database’;
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
“/u01/app/oracle/oradata/IND21/temp01.dbf”;
set newname for tempfile 2 to
“/u01/app/oracle/oradata/IND21/pdbseed/temp012019-12-16_18-23-32-248-PM.dbf”;
set newname for tempfile 3 to
“/u01/app/oracle/oradata/IND21/pdb/temp01.dbf”;
switch clone tempfile all;
set newname for datafile 1 to
“/u01/app/oracle/oradata/IND21/system01.dbf”;
set newname for datafile 3 to
“/u01/app/oracle/oradata/IND21/sysaux01.dbf”;
set newname for datafile 4 to
“/u01/app/oracle/oradata/IND21/undotbs01.dbf”;
set newname for datafile 5 to
“/u01/app/oracle/oradata/IND21/pdbseed/system01.dbf”;
set newname for datafile 6 to
“/u01/app/oracle/oradata/IND21/pdbseed/sysaux01.dbf”;
set newname for datafile 7 to
“/u01/app/oracle/oradata/IND21/users01.dbf”;
set newname for datafile 8 to
“/u01/app/oracle/oradata/IND21/pdbseed/undotbs01.dbf”;
set newname for datafile 9 to
“/u01/app/oracle/oradata/IND21/pdb/system01.dbf”;
set newname for datafile 10 to
“/u01/app/oracle/oradata/IND21/pdb/sysaux01.dbf”;
set newname for datafile 11 to
“/u01/app/oracle/oradata/IND21/pdb/undotbs01.dbf”;
set newname for datafile 12 to
“/u01/app/oracle/oradata/IND21/pdb/users01.dbf”;
backup as copy reuse
datafile 1 auxiliary format
“/u01/app/oracle/oradata/IND21/system01.dbf” datafile
3 auxiliary format
“/u01/app/oracle/oradata/IND21/sysaux01.dbf” datafile
4 auxiliary format
“/u01/app/oracle/oradata/IND21/undotbs01.dbf” datafile
5 auxiliary format
“/u01/app/oracle/oradata/IND21/pdbseed/system01.dbf” datafile
6 auxiliary format
“/u01/app/oracle/oradata/IND21/pdbseed/sysaux01.dbf” datafile
7 auxiliary format
“/u01/app/oracle/oradata/IND21/users01.dbf” datafile
8 auxiliary format
“/u01/app/oracle/oradata/IND21/pdbseed/undotbs01.dbf” datafile
9 auxiliary format
“/u01/app/oracle/oradata/IND21/pdb/system01.dbf” datafile
10 auxiliary format
“/u01/app/oracle/oradata/IND21/pdb/sysaux01.dbf” datafile
11 auxiliary format
“/u01/app/oracle/oradata/IND21/pdb/undotbs01.dbf” datafile
12 auxiliary format
“/u01/app/oracle/oradata/IND21/pdb/users01.dbf” ;
sql ‘alter system archive log current’;
}
executing Memory Script
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/IND21/temp01.dbf in control file
renamed tempfile 2 to /u01/app/oracle/oradata/IND21/pdbseed/temp012019-12-16_18-23-32-248-PM.dbf in control file
renamed tempfile 3 to /u01/app/oracle/oradata/IND21/pdb/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting backup at 17-DEC-19
channel p1: starting datafile copy
input datafile file number=00001 name=/u01/app/oracle/oradata/IND21/system01.dbf
channel p2: starting datafile copy
input datafile file number=00003 name=/u01/app/oracle/oradata/IND21/sysaux01.dbf
channel p3: starting datafile copy
input datafile file number=00010 name=/u01/app/oracle/oradata/IND21/pdb/sysaux01.dbf
channel p4: starting datafile copy
input datafile file number=00006 name=/u01/app/oracle/oradata/IND21/pdbseed/sysaux01.dbf
output file name=/u01/app/oracle/oradata/IND21/pdb/sysaux01.dbf tag=TAG20191217T171114
channel p3: datafile copy complete, elapsed time: 00:00:37
channel p3: starting datafile copy
input datafile file number=00004 name=/u01/app/oracle/oradata/IND21/undotbs01.dbf
output file name=/u01/app/oracle/oradata/IND21/pdbseed/sysaux01.dbf tag=TAG20191217T171114
channel p4: datafile copy complete, elapsed time: 00:00:38
channel p4: starting datafile copy
input datafile file number=00005 name=/u01/app/oracle/oradata/IND21/pdbseed/system01.dbf
output file name=/u01/app/oracle/oradata/IND21/sysaux01.dbf tag=TAG20191217T171114
channel p2: datafile copy complete, elapsed time: 00:00:45
channel p2: starting datafile copy
input datafile file number=00009 name=/u01/app/oracle/oradata/IND21/pdb/system01.dbf
output file name=/u01/app/oracle/oradata/IND21/system01.dbf tag=TAG20191217T171114
channel p1: datafile copy complete, elapsed time: 00:01:01
channel p1: starting datafile copy
input datafile file number=00008 name=/u01/app/oracle/oradata/IND21/pdbseed/undotbs01.dbf
output file name=/u01/app/oracle/oradata/IND21/pdb/system01.dbf tag=TAG20191217T171114
channel p2: datafile copy complete, elapsed time: 00:00:24
channel p2: starting datafile copy
input datafile file number=00011 name=/u01/app/oracle/oradata/IND21/pdb/undotbs01.dbf
output file name=/u01/app/oracle/oradata/IND21/pdbseed/system01.dbf tag=TAG20191217T171114
channel p4: datafile copy complete, elapsed time: 00:00:33
channel p4: starting datafile copy
input datafile file number=00007 name=/u01/app/oracle/oradata/IND21/users01.dbf
output file name=/u01/app/oracle/oradata/IND21/pdbseed/undotbs01.dbf tag=TAG20191217T171114
channel p1: datafile copy complete, elapsed time: 00:00:14
channel p1: starting datafile copy
input datafile file number=00012 name=/u01/app/oracle/oradata/IND21/pdb/users01.dbf
output file name=/u01/app/oracle/oradata/IND21/undotbs01.dbf tag=TAG20191217T171114
channel p3: datafile copy complete, elapsed time: 00:00:39
output file name=/u01/app/oracle/oradata/IND21/users01.dbf tag=TAG20191217T171114
channel p4: datafile copy complete, elapsed time: 00:00:05
output file name=/u01/app/oracle/oradata/IND21/pdb/users01.dbf tag=TAG20191217T171114
channel p1: datafile copy complete, elapsed time: 00:00:00
output file name=/u01/app/oracle/oradata/IND21/pdb/undotbs01.dbf tag=TAG20191217T171114
channel p2: datafile copy complete, elapsed time: 00:00:06
Finished backup at 17-DEC-19
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=4 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=5 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=6 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=7 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdbseed/system01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=8 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdbseed/sysaux01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=9 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/users01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=10 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdbseed/undotbs01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=11 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdb/system01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=12 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdb/sysaux01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=13 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdb/undotbs01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=14 STAMP=1027271552 file name=/u01/app/oracle/oradata/IND21/pdb/users01.dbf
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Oracle error from auxiliary database: ORA-01275: Operation RENAME is not allowed if standby file management is automatic.
RMAN-05535: warning: All redo log files were not defined properly.
Finished Duplicate Db at 17-DEC-19
released channel: p1
released channel: p2
released channel: p3
released channel: p4
released channel: s1
Pluggable database successfully created
[oracle@dev19c ind21stby]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Tue Dec 17 17:14:42 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> alter database open;
Database altered.
SQL> alter database recover managed standby database disconnect nodelay;
Database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB MOUNTED
QUERY to check the difference
SQL> SELECT ARCH.THREAD# “Thread”, ARCH.SEQUENCE# “Last Sequence Received”, APPL.SEQUENCE# “Last Sequence Applied”, (ARCH.SEQUENCE# – APPL.SEQUENCE#) “Difference”
FROM (SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE ARCH.THREAD# = APPL.THREAD#
ORDER BY 1; 2 3 4 5 6 7
Thread Last Sequence Received Last Sequence Applied Difference
———- ———————- – ——————– ———-
1 11 11 0
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr