Stage-1 How to Create a Physical Standby Database using Backup Pieces
High Level Steps
Goal : How to Create Physical Standby Database using RMAN Backup With Duplicate Command
SQL> startup
ORACLE instance started.
Total System Global Area 2432696320 bytes
Fixed Size 8623592 bytes
Variable Size 654314008 bytes
Database Buffers 1761607680 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
SQL> alter database force logging;
SQL> alter database flashback on;
Shutdown immediate
Startup mount
Alter database archivelog;
Shut immediate
startup
SQL> col FORCE_LOGGING for a20
SQL> select name,force_logging,flashback_on,log_mode from v$database;
NAME FORCE_LOGGING FLASHBACK_ON LOG_MODE
——— ——————– —————— ————
DBWRPRD YES YES ARCHIVELOG
3.Configure a Standby Redo Log on Primary
— Since we have 3 online redo log file groups, we need to create 4(3+1) Standby redo log file groups
— Standy Redo logs files come into picture only when protection mode is Maximum Availability and Maximum Protection.
SQL> set lines 180
col MEMBER for a60
select b.thread#, a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;SQL> SQL>
THREAD# GROUP# MEMBER BYTES
———- ———- ———————————————————— ———-
1 3 /u01/app/oracle/oradata/dbwrprd/redo03.log 209715200
1 2 /u01/app/oracle/oradata/dbwrprd/redo02.log 209715200
1 1 /u01/app/oracle/oradata/dbwrprd/redo01.log 209715200
ALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (‘/u01/app/oracle/oradata/dbwrprd/redo04.log’) SIZE 200M;
Database altered.
ALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (‘/u01/app/oracle/oradata/dbwrprd/redo05.log’) SIZE 200M;
Database altered.
ALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (‘/u01/app/oracle/oradata/dbwrprd/redo06.log’) SIZE 200M;
Database altered.
ALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (‘/u01/app/oracle/oradata/dbwrprd/redo07.log’) SIZE 200M;
Database altered.
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_ CON_ID 3 ONLINE /u01/app/oracle/oradata/dbwrprd/redo03.log NO 0
2 ONLINE /u01/app/oracle/oradata/dbwrprd/redo02.log NO 0
1 ONLINE /u01/app/oracle/oradata/dbwrprd/redo01.log NO 0
4 STANDBY /u01/app/oracle/oradata/dbwrprd/redo04.log NO 0
5 STANDBY /u01/app/oracle/oradata/dbwrprd/redo05.log NO 0
6 STANDBY /u01/app/oracle/oradata/dbwrprd/redo06.log NO 0
7 STANDBY /u01/app/oracle/oradata/dbwrprd/redo07.log NO 0SQL> select a.group#, a.member, b.bytes FROM v$logfile a, v$standby_log b WHERE a.group# = b.group#;
GROUP# MEMBER BYTES———- ———————————————————— – ———
4 /u01/app/oracle/oradata/dbwrprd/redo04.log 209715200
5 /u01/app/oracle/oradata/dbwrprd/redo05.log 209715200
6 /u01/app/oracle/oradata/dbwrprd/redo06.log 209715200
7 /u01/app/oracle/oradata/dbwrprd/redo07.log 209715200
4.Configure TNS and listener for Primary and Standby (both the server)
[oracle@Prod21 ~]$ tnsping dbwrprd
TNS Ping Utility for Linux: Version 12.2.0.1.0 – Production on 15-MAY-2020 02:01:46
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.24)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = dbwrprd)))
OK (210 msec)
[oracle@Prod21 ~]$ tnsping dbwrstd
TNS Ping Utility for Linux: Version 12.2.0.1.0 – Production on 15-MAY-2020 02:01:51
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.25)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = dbwrstd)))
OK (2630 msec)
[oracle@Prod21 ~]$
[oracle@Prod21 ~]$ lsnrctl status
LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 15-MAY-2020 02:02:08
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.24)(PORT=1521)))
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 15-MAY-2020 00:43:34
Uptime 0 days 1 hr. 18 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/Prod21/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.24)(PORT=1521)))
Services Summary…
Service “dbwrprd” has 2 instance(s).
Instance “dbwrprd”, status UNKNOWN, has 1 handler(s) for this service…
Instance “dbwrprd”, status READY, has 1 handler(s) for this service…
Service “dbwrprdXDB” has 1 instance(s).
Instance “dbwrprd”, status READY, has 1 handler(s) for this service…
Service “dbwrstd” has 1 instance(s).
Instance “dbwrstd”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
Login to Standby server and perform the same
5.Set Primary Database Initialization Parameters
ALTER SYSTEM SET db_file_name_convert=’/u01/app/oracle/oradata/dbwrstd/’,’/u01/app/oracle/oradata/dbwrprd/’ SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert=’/u01/app/oracle/oradata/dbwrstd/’,’/u01/app/oracle/oradata/dbwrprd/’ SCOPE=SPFILE;
ALTER SYSTEM SET standby_file_management=’AUTO’ SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_config=’dg_config=(dbwrprd,dbwrstd)’ SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_1=’location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=dbwrprd’ SCOPE=SPFILE;
ALTER SYSTEM SET log_archive_dest_2=’service=dbwrstd async valid_for=(online_logfiles,primary_role) db_unique_name=dbwrstd’ SCOPE=SPFILE;
ALTER SYSTEM SET fal_server=’dbwrstd’ SCOPE=SPFILE;
ALTER SYSTEM SET fal_client=’dbwrprd’ SCOPE=SPFILE;
ALTER SYSTEM SET db_file_name_convert=’/u01/app/oracle/oradata/dbwrstd/’,’/u01/app/oracle/oradata/dbwrprd/’ SCOPE=SPFILE;
ALTER SYSTEM SET log_file_name_convert=’/u01/app/oracle/oradata/dbwrstd/’,’/u01/app/oracle/oradata/dbwrprd/’ SCOPE=SPFILE;
6.Bounce the Primary Database
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
[oracle@Prod21 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 21:48:21 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 2432696320 bytes
Fixed Size 8623592 bytes
Variable Size 654314008 bytes
Database Buffers 1761607680 bytes
Redo Buffers 8151040 bytes
Database mounted.
Database opened.
7.Backup the Primary Database
Script Location /u01/backup
mkdir –p /u01/backup
run
{
ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT ‘/u01/backup/%d_D_%T_%u_s%s_p%p’
DATABASE
CURRENT CONTROLFILE for standby
FORMAT ‘/u01/backup/%d_C_%T_%u’
SPFILE
FORMAT ‘/u01/backup/%d_S_%T_%u’
PLUS ARCHIVELOG
FORMAT ‘/u01/backup/%d_A_%T_%u_s%s_p%p’;
RELEASE CHANNEL ch11;
}
[oracle@Prod21 ~]$ mkdir -p /u01/backup/
[oracle@Prod21 ~]$ export ORACLE_SID=dbwrprd
[oracle@Prod21 ~]$ rman target /
Recovery Manager: Release 12.2.0.1.0 – Production on Fri May 15 20:06:20 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: DBWRPRD (DBID=612730647)
RMAN> run
{
ALLOCATE CHANNEL ch11 TYPE DISK MAXPIECESIZE 10G;
BACKUP
FORMAT ‘/u01/backup/%d_D_%T_%u_s%s_p%p’
DATABASE
CURRENT CONTROLFILE for standby
FORMAT ‘/u01/backup/%d_C_%T_%u’
SPFILE
FORMAT ‘/u01/backup/%d_S_%T_%u’
PLUS ARCHIVELOG
FORMAT ‘/u01/backup/%d_A_%T_%u_s%s_p%p’;
RELEASE CHANNEL ch11;
}2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14>
using target database control file instead of recovery catalog
allocated channel: ch11
channel ch11: SID=53 device type=DISK
Starting backup at 15-MAY-20
current log archived
channel ch11: starting archived log backup set
channel ch11: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=1 STAMP=1040434867
input archived log thread=1 sequence=2 RECID=2 STAMP=1040501250
channel ch11: starting piece 1 at 15-MAY-20
channel ch11: finished piece 1 at 15-MAY-20
piece handle=/u01/backup/DBWRPRD_A_20200515_03v09ig4_s3_p1 tag=TAG20200515T200731 comment=NONE
channel ch11: backup set complete, elapsed time: 00:01:36
Finished backup at 15-MAY-20
Starting backup at 15-MAY-20
channel ch11: starting full datafile backup set
channel ch11: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/dbwrprd/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/dbwrprd/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/dbwrprd/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/dbwrprd/users01.dbf
channel ch11: starting piece 1 at 15-MAY-20
channel ch11: finished piece 1 at 15-MAY-20
piece handle=/u01/backup/DBWRPRD_D_20200515_04v09ij7_s4_p1 tag=TAG20200515T200910 comment=NONE
channel ch11: backup set complete, elapsed time: 00:02:27
channel ch11: starting full datafile backup set
channel ch11: specifying datafile(s) in backup set
including standby control file in backup set
channel ch11: starting piece 1 at 15-MAY-20
channel ch11: finished piece 1 at 15-MAY-20
piece handle=/u01/backup/DBWRPRD_C_20200515_05v09inq tag=TAG20200515T200910 comment=NONE
channel ch11: backup set complete, elapsed time: 00:00:01
channel ch11: starting full datafile backup set
channel ch11: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch11: starting piece 1 at 15-MAY-20
channel ch11: finished piece 1 at 15-MAY-20
piece handle=/u01/backup/DBWRPRD_S_20200515_06v09inu tag=TAG20200515T200910 comment=NONE
channel ch11: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAY-20
Starting backup at 15-MAY-20
current log archived
channel ch11: starting archived log backup set
channel ch11: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=3 STAMP=1040501503
channel ch11: starting piece 1 at 15-MAY-20
channel ch11: finished piece 1 at 15-MAY-20
piece handle=/u01/backup/DBWRPRD_A_20200515_07v09io0_s7_p1 tag=TAG20200515T201144 comment=NONE
channel ch11: backup set complete, elapsed time: 00:00:01
Finished backup at 15-MAY-20
Starting Control File and SPFILE Autobackup at 15-MAY-20
piece handle=/u01/app/oracle/fast_recovery_area/dbwrprd/DBWRPRD/autobackup/2020_05_15/o1_mf_s_1040501505_hcxbk9bn_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 15-MAY-20
released channel: ch11
RMAN>
8.Check backup location
[oracle@Prod21 ~]$ cd /u01/backup/
[oracle@Prod21 backup]$ ll
total 1407660
-rw-r—–. 1 oracle oinstall 322836992 May 15 20:08 DBWRPRD_A_20200515_03v09ig4_s3_p1
-rw-r—–. 1 oracle oinstall 89600 May 15 20:11 DBWRPRD_A_20200515_07v09io0_s7_p1
-rw-r—–. 1 oracle oinstall 10665984 May 15 20:11 DBWRPRD_C_20200515_05v09inq
-rw-r—–. 1 oracle oinstall 1107730432 May 15 20:11 DBWRPRD_D_20200515_04v09ij7_s4_p1
-rw-r—–. 1 oracle oinstall 114688 May 15 20:11 DBWRPRD_S_20200515_06v09inu
9.Create pfile for standby database and edit the parameters
[oracle@Prod21 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 20:14:11 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
SQL> CREATE PFILE=’/u01/backup/initdbwrstd.ora’ from spfile;
Login into /u01/location and edit the parameters
In the PFILE making the entries relevant for the standby database. Change the following parameters.
*.audit_file_dest=’/u01/app/oracle/admin/dbwrstd/adump’
*.audit_trail=’db’
*.compatible=’12.2.0′
*.control_files=’/u01/app/oracle/oradata/dbwrstd/control01.ctl’,’/u01/app/oracle/fast_recovery_area/dbwrstd/control02.ctl’
*.db_block_size=8192
*.db_file_name_convert=’/u01/app/oracle/oradata/dbwrprd/’,’/u01/app/oracle/oradata/dbwrstd/’
*.db_name=’dbwrprd’
*.db_unique_name=’dbwrstd’ -> we need to add
*.db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area/dbwrstd’
*.db_recovery_file_dest_size=8016m
*.diagnostic_dest=’/u01/app/oracle’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=dbwrstdXDB)’
*.fal_client=’dbwrstd’
*.fal_server=’dbwrprd’
*.local_listener=’LISTENER_DBWRPRD’
*.log_archive_config=’dg_config=(dbwrprd,dbwrstd)’
*.log_archive_dest_1=’location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=dbwrstd’
*.log_archive_dest_2=’service=dbwrprd async valid_for=(online_logfiles,primary_role) db_unique_name=dbwrprd’
*.log_archive_format=’%t_%s_%r.dbf’
*.log_file_name_convert=’/u01/app/oracle/oradata/dbwrprd/’,’/u01/app/oracle/oradata/dbwrstd/’
*.nls_language=’AMERICAN’
*.nls_territory=’AMERICA’
*.open_cursors=300
*.pga_aggregate_target=771m
*.processes=300
*.remote_login_passwordfile=’EXCLUSIVE’
*.sga_target=2312m
*.standby_file_management=’AUTO’
*.undo_tablespace=’UNDOTBS1′
Standby Server Setup (Manual)
1.Create the necessary directories on the standby server.
mkdir -p /u01/app/oracle/oradata/dbwrstd
mkdir -p /u01/app/oracle/fast_recovery_area/dbwrstd
mkdir -p /u01/app/oracle/admin/dbwrstd/adump
mkdir -p /u01/backup/
2.Copy the files from the primary to the standby server.( Login in to primary server and start copy)
[oracle@Prod21 ~]$ cd /u01/backup/
[oracle@Prod21 backup]$ ll
total 1407660
-rw-r—–. 1 oracle oinstall 322836992 May 15 20:08 DBWRPRD_A_20200515_03v09ig4_s3_p1
-rw-r—–. 1 oracle oinstall 89600 May 15 20:11 DBWRPRD_A_20200515_07v09io0_s7_p1
-rw-r—–. 1 oracle oinstall 10665984 May 15 20:11 DBWRPRD_C_20200515_05v09inq
-rw-r—–. 1 oracle oinstall 1107730432 May 15 20:11 DBWRPRD_D_20200515_04v09ij7_s4_p1
-rw-r—–. 1 oracle oinstall 114688 May 15 20:11 DBWRPRD_S_20200515_06v09inu
-rw-r–r–. 1 oracle oinstall 1728 May 15 20:14 initdbwrstd.ora
[oracle@Prod21 backup]$ scp DBWR oracle@192.168.1.25:/u01/backup
oracle@192.168.1.25’s password:
DBWRPRD_A_20200515_03v09ig4_s3_p1 100% 308MB 3.5MB/s 01:29
DBWRPRD_A_20200515_07v09io0_s7_p1 100% 88KB 87.5KB/s 00:00
DBWRPRD_C_20200515_05v09inq 100% 10MB 5.1MB/s 00:02
DBWRPRD_D_20200515_04v09ij7_s4_p1 100% 1056MB 6.2MB/s 02:50
DBWRPRD_S_20200515_06v09inu 100% 112KB 112.0KB/s 00:00
$ # Parameter file.
cd /u01/backup
[oracle@Prod21 backup]$ scp initdbwrstd.ora oracle@192.168.1.25:$ORACLE_HOME/dbs
oracle@192.168.1.25’s password:
initdbwrstd.ora 100% 1728 1.7KB/s 00:00
$ # Passwordfile.
cd $ORACLE_HOME/dbs
[oracle@Prod21 dbs]$ scp orapwdbwrprd oracle@192.168.1.25:$ORACLE_HOME/dbs
oracle@192.168.1.25’s password:
orapwdbwrprd 100% 3584 3.5KB/s 00:00
3.Start standby database in nomount
[oracle@Prod22 ~]$export ORACLE_SID=dbwrstd
[oracle@Prod22 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 20:58:12 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2432696320 bytes
Fixed Size 8623592 bytes
Variable Size 654314008 bytes
Database Buffers 1761607680 bytes
Redo Buffers 8151040 bytes
SQL>exit
[oracle@Prod22 admin]$export ORACLE_SID=dbwrstd
[oracle@Prod22 admin]$ rman target sys/oracle@dbwrprd auxiliary sys/oracle@dbwrstd
Recovery Manager: Release 12.2.0.1.0 – Production on Fri May 15 21:03:13 2020
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: DBWRPRD (DBID=612730647)
connected to auxiliary database: DBWRPRD (not mounted)
RMAN> run {
allocate channel disk1 device type disk;
allocate auxiliary channel disk2 device type disk;
duplicate target database for standby nofilenamecheck;
release channel disk1;
release channel disk2;
}2> 3> 4> 5> 6> 7>
using target database control file instead of recovery catalog
allocated channel: disk1
channel disk1: SID=84 device type=DISK
allocated channel: disk2
channel disk2: SID=36 device type=DISK
Starting Duplicate Db at 15-MAY-20
contents of Memory Script:
{
restore clone standby controlfile;
}
executing Memory Script
Starting restore at 15-MAY-20
channel disk2: starting datafile backup set restore
channel disk2: restoring control file
channel disk2: reading from backup piece /u01/app/oracle/fast_recovery_area/dbwrprd/DBWRPRD/autobackup/2020_05_15/o1_mf_s_1040501505_hcxbk9bn_.bkp
channel disk2: ORA-19870: error while restoring backup piece /u01/app/oracle/fast_recovery_area/dbwrprd/DBWRPRD/autobackup/2020_05_15/o1_mf_s_1040501505_hcxbk9bn_.bkp
ORA-19505: failed to identify file “/u01/app/oracle/fast_recovery_area/dbwrprd/DBWRPRD/autobackup/2020_05_15/o1_mf_s_1040501505_hcxbk9bn_.bkp”
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
failover to previous backup
channel disk2: starting datafile backup set restore
channel disk2: restoring control file
channel disk2: reading from backup piece /u01/backup/DBWRPRD_C_20200515_05v09inq
channel disk2: piece handle=/u01/backup/DBWRPRD_C_20200515_05v09inq tag=TAG20200515T200910
channel disk2: restored backup piece 1
channel disk2: restore complete, elapsed time: 00:02:26
output file name=/u01/app/oracle/oradata/dbwrstd/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/dbwrstd/control02.ctl
Finished restore at 15-MAY-20
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/dbwrstd/temp01.dbf”;
switch clone tempfile all;
set newname for datafile 1 to
“/u01/app/oracle/oradata/dbwrstd/system01.dbf”;
set newname for datafile 3 to
“/u01/app/oracle/oradata/dbwrstd/sysaux01.dbf”;
set newname for datafile 4 to
“/u01/app/oracle/oradata/dbwrstd/undotbs01.dbf”;
set newname for datafile 7 to
“/u01/app/oracle/oradata/dbwrstd/users01.dbf”;
restore
clone database
;
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/dbwrstd/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-MAY-20
channel disk2: starting datafile backup set restore
channel disk2: specifying datafile(s) to restore from backup set
channel disk2: restoring datafile 00001 to /u01/app/oracle/oradata/dbwrstd/system01.dbf
channel disk2: restoring datafile 00003 to /u01/app/oracle/oradata/dbwrstd/sysaux01.dbf
channel disk2: restoring datafile 00004 to /u01/app/oracle/oradata/dbwrstd/undotbs01.dbf
channel disk2: restoring datafile 00007 to /u01/app/oracle/oradata/dbwrstd/users01.dbf
channel disk2: reading from backup piece /u01/backup/DBWRPRD_D_20200515_04v09ij7_s4_p1
channel disk2: piece handle=/u01/backup/DBWRPRD_D_20200515_04v09ij7_s4_p1 tag=TAG20200515T200910
channel disk2: restored backup piece 1
channel disk2: restore complete, elapsed time: 00:06:06
Finished restore at 15-MAY-20
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1040505408 file name=/u01/app/oracle/oradata/dbwrstd/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1040505408 file name=/u01/app/oracle/oradata/dbwrstd/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1040505408 file name=/u01/app/oracle/oradata/dbwrstd/undotbs01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1040505408 file name=/u01/app/oracle/oradata/dbwrstd/users01.dbf
Finished Duplicate Db at 15-MAY-20
released channel: disk1
released channel: disk2
RMAN>
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
[oracle@Prod22 trace]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Fri May 15 22:41:54 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production
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;
Thread Last Sequence Received Last Sequence Applied Difference 1 8 8 0