{"id":11573,"date":"2018-08-15T15:08:27","date_gmt":"2018-08-15T13:08:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/"},"modified":"2023-06-09T17:02:04","modified_gmt":"2023-06-09T15:02:04","slug":"oracle-18c-dataguard-rman-recover-standby-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/","title":{"rendered":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE.<\/p>\n

The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary database, and automatically renames data files, temp files, and online logs. It restores new data files that were added to the primary database and recovers the standby database up to the current time.
\nWhen you use the RECOVER STANDBY DATABASE command to refresh a standby database, you specify either a FROM SERVICE clause or a NOREDO clause. The FROM SERVICE clause specifies the name of a primary service. The NOREDO clause specifies that backups should be used for the refresh, which allows a standby to be rolled forward to a specific time or SCN.
\nThe MRP must be manually stopped on the standby before any attempt is made to sync with primary database.<\/p>\n

In this blog I am doing some tests of standby refresh using the Recover Standby Database command.<\/p>\n

From a fine Data Guard let\u2019s set the property StandbyFileManagement to MANUAL<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration;<\/code><\/div>\n
<\/div>\n
Configuration - CONT18C_DR<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>CONT18C_SITE\u00a0 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CONT18C_SITE1 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover: DISABLED<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 18 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n
<\/div>\n
DGMGRL> edit <\/code>database<\/code> 'CONT18C_SITE'<\/code> set<\/code> property StandbyFileManagement=MANUAL;<\/code><\/div>\n
Property <\/code>\"standbyfilemanagement\"<\/code> updated<\/code><\/div>\n
DGMGRL> edit <\/code>database<\/code> 'CONT18C_SITE1'<\/code> set<\/code> property StandbyFileManagement=MANUAL;<\/code><\/div>\n
Property <\/code>\"standbyfilemanagement\"<\/code> updated<\/code><\/div>\n
DGMGRL> show\u00a0 <\/code>database<\/code> 'CONT18C_SITE'<\/code> StandbyFileManagement;<\/code><\/div>\n
\u00a0\u00a0<\/code>StandbyFileManagement = <\/code>'manual'<\/code><\/div>\n
DGMGRL> show\u00a0 <\/code>database<\/code> 'CONT18C_SITE1'<\/code> StandbyFileManagement;<\/code><\/div>\n
\u00a0\u00a0<\/code>StandbyFileManagement = <\/code>'manual'<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And Then I create add new tablespace and new table in the primary<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>create<\/code> tablespace TBS_2 datafile <\/code>'\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_201.dbf'<\/code> size<\/code> 5M ;<\/code><\/div>\n
<\/div>\n
Tablespace created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>create<\/code> table<\/code> test (id number) tablespace TBS_2;<\/code><\/div>\n
<\/div>\n
Table<\/code> created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>insert<\/code> into<\/code> test <\/code>values<\/code> (1);<\/code><\/div>\n
<\/div>\n
1 row created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>insert<\/code> into<\/code> test <\/code>values<\/code> (2);<\/code><\/div>\n
<\/div>\n
1 row created.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>commit<\/code>;<\/code><\/div>\n
<\/div>\n
Commit<\/code> complete.<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As expected the changes are not being replicated as shown in the standby alert logfile and in the broker sonfiguration<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
(3):File <\/code>#14 added to control file as 'UNNAMED00014' because<\/code><\/div>\n
(3):the parameter STANDBY_FILE_MANAGEMENT is <\/code>set<\/code> to MANUAL<\/code><\/div>\n
(3):The <\/code>file<\/code> should be manually created to <\/code>continue<\/code>.<\/code><\/div>\n
MRP0 (PID:6307): MRP0: Background Media Recovery terminated with error 1274<\/code><\/div>\n
2018-08-15T13:31:08.343276+02:00<\/code><\/div>\n
Errors <\/code>in<\/code> file<\/code> \/u01\/app\/oracle\/diag\/rdbms\/cont18c_site1\/CONT18C\/trace\/CONT18C_mrp0_6307<\/code>.trc:<\/code><\/div>\n
ORA-01274: cannot add data <\/code>file<\/code> that was originally created as <\/code>'\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_201.dbf'<\/code><\/div>\n
MRP0 (PID:6307): Managed Standby Recovery not using Real Time Apply<\/code><\/div>\n
Recovery interrupted!<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Using the broker<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
DGMGRL> show <\/code>database<\/code> 'CONT18C_SITE1'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> - CONT18C_SITE1<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Role:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PHYSICAL STANDBY<\/code><\/div>\n
\u00a0\u00a0<\/code>Intended State:\u00a0\u00a0\u00a0\u00a0 APPLY-<\/code>ON<\/code><\/div>\n
\u00a0\u00a0<\/code>Transport Lag:\u00a0\u00a0\u00a0\u00a0\u00a0 0 seconds (computed 1 <\/code>second<\/code> ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Apply Lag:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4 minutes 33 seconds (computed 1 <\/code>second<\/code> ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Average Apply Rate: 3.00 KByte\/s<\/code><\/div>\n
\u00a0\u00a0<\/code>Real<\/code> Time<\/code> Query:\u00a0\u00a0\u00a0 <\/code>OFF<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CONT18C<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Database<\/code> Error(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ORA-16766: Redo Apply <\/code>is<\/code> stopped<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Database<\/code> Warning(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>ORA-16853: apply lag has exceeded specified threshold<\/code><\/div>\n
<\/div>\n
Database<\/code> Status:<\/code><\/div>\n
ERROR<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s try to sync the standby database using the RECOVER command. First let\u2019s stop the recovery process.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit <\/code>database<\/code> 'CONT18C_SITE1'<\/code> set<\/code> state =<\/code>'APPLY-OFF'<\/code>;<\/code><\/div>\n
Succeeded.<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> 'CONT18C_SITE1'<\/code>;<\/code><\/div>\n
<\/div>\n
Database<\/code> - CONT18C_SITE1<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Role:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PHYSICAL STANDBY<\/code><\/div>\n
\u00a0\u00a0<\/code>Intended State:\u00a0\u00a0\u00a0\u00a0 APPLY-<\/code>OFF<\/code><\/div>\n
\u00a0\u00a0<\/code>Transport Lag:\u00a0\u00a0\u00a0\u00a0\u00a0 0 seconds (computed 0 seconds ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Apply Lag:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 26 minutes 28 seconds (computed 0 seconds ago)<\/code><\/div>\n
\u00a0\u00a0<\/code>Average Apply Rate: (unknown)<\/code><\/div>\n
\u00a0\u00a0<\/code>Real<\/code> Time<\/code> Query:\u00a0\u00a0\u00a0 <\/code>OFF<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance(s):<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CONT18C<\/code><\/div>\n
<\/div>\n
Database<\/code> Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After let\u2019s connect with Rman as the target to the standby <\/strong>and let\u2019s run the command
\nIf we try to run the command while connecting to the primary as target we will get following error<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
RMAN> RECOVER STANDBY DATABASE FROM SERVICE CONT18c_SITE;<\/code><\/div>\n
<\/div>\n
Starting recover at 15-AUG-18<\/code><\/div>\n
RMAN-00571: ===========================================================<\/code><\/div>\n
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============<\/code><\/div>\n
RMAN-00571: ===========================================================<\/code><\/div>\n
RMAN-03002: failure of recover <\/code>command<\/code> at 08<\/code>\/15\/2018<\/code> 14:00:15<\/code><\/div>\n
RMAN-05146: must be connected to standby database to issue RECOVER STANDBY DATABASE<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

So from the standby as target. Note that outputs are truncated<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n
63<\/div>\n
64<\/div>\n
65<\/div>\n
66<\/div>\n
67<\/div>\n
68<\/div>\n
69<\/div>\n
70<\/div>\n
71<\/div>\n
72<\/div>\n
73<\/div>\n
74<\/div>\n
75<\/div>\n
76<\/div>\n
77<\/div>\n
78<\/div>\n
79<\/div>\n
80<\/div>\n
81<\/div>\n
82<\/div>\n
83<\/div>\n
84<\/div>\n
85<\/div>\n
86<\/div>\n
87<\/div>\n
88<\/div>\n
89<\/div>\n
90<\/div>\n
91<\/div>\n
92<\/div>\n
93<\/div>\n
94<\/div>\n
95<\/div>\n
96<\/div>\n
97<\/div>\n
98<\/div>\n
99<\/div>\n
100<\/div>\n
101<\/div>\n
102<\/div>\n
103<\/div>\n
104<\/div>\n
105<\/div>\n
106<\/div>\n
107<\/div>\n
108<\/div>\n
109<\/div>\n
110<\/div>\n
111<\/div>\n
112<\/div>\n
113<\/div>\n
114<\/div>\n
115<\/div>\n
116<\/div>\n
117<\/div>\n
118<\/div>\n<\/td>\n
\n
\n
[oracle@primaserver admin]$ rman target sys<\/code>\/root<\/code>@cont18c_site1<\/code><\/div>\n
<\/div>\n
Recovery Manager: Release 18.0.0.0.0 - Production on Wed Aug 15 14:03:55 2018<\/code><\/div>\n
Version 18.3.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2018, Oracle and<\/code>\/or<\/code> its affiliates.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
connected to target database: CONT18C (DBID=4292751651)<\/code><\/div>\n
<\/div>\n
RMAN>\u00a0 RECOVER STANDBY DATABASE FROM SERVICE CONT18c_SITE;<\/code><\/div>\n
<\/div>\n
Starting recover at 15-AUG-18<\/code><\/div>\n
using target database control <\/code>file<\/code> instead of recovery catalog<\/code><\/div>\n
Executing: alter database flashback off<\/code><\/div>\n
Oracle instance started<\/code><\/div>\n
<\/div>\n
Total System Global Area\u00a0\u00a0\u00a0\u00a0 956299440 bytes<\/code><\/div>\n
<\/div>\n
Fixed Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8902832 bytes<\/code><\/div>\n
Variable Size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 348127232 bytes<\/code><\/div>\n
Database Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 595591168 bytes<\/code><\/div>\n
Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3678208 bytes<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>restore standby controlfile from service\u00a0 <\/code>'CONT18c_SITE'<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>alter database <\/code>mount<\/code> standby database;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
Starting restore at 15-AUG-18<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=39 device <\/code>type<\/code>=DISK<\/code><\/div>\n
<\/div>\n
channel ORA_DISK_1: starting datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: using network backup <\/code>set<\/code> from service CONT18c_SITE<\/code><\/div>\n
channel ORA_DISK_1: restoring control <\/code>file<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:04<\/code><\/div>\n
output <\/code>file<\/code> name=<\/code>\/u01\/app\/oracle\/oradata\/CONT18C\/control01<\/code>.ctl<\/code><\/div>\n
output <\/code>file<\/code> name=<\/code>\/u01\/app\/oracle\/oradata\/CONT18C\/control02<\/code>.ctl<\/code><\/div>\n
Finished restore at 15-AUG-18<\/code><\/div>\n
<\/div>\n
released channel: ORA_DISK_1<\/code><\/div>\n
Statement processed<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
set<\/code> newname <\/code>for<\/code> datafile\u00a0 14 to<\/code><\/div>\n
\u00a0<\/code>\"\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_201.dbf\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>restore from service\u00a0 <\/code>'CONT18c_SITE'<\/code> datafile<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>14;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>catalog datafilecopy\u00a0 <\/code>\"\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_201.dbf\"<\/code>;<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>switch datafile all;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
executing <\/code>command<\/code>: SET NEWNAME<\/code><\/div>\n
<\/div>\n
Starting restore at 15-AUG-18<\/code><\/div>\n
Starting implicit crosscheck backup at 15-AUG-18<\/code><\/div>\n
allocated channel: ORA_DISK_1<\/code><\/div>\n
channel ORA_DISK_1: SID=51 device <\/code>type<\/code>=DISK<\/code><\/div>\n
Crosschecked 5 objects<\/code><\/div>\n
Finished implicit crosscheck backup at 15-AUG-18<\/code><\/div>\n
<\/div>\n
Starting implicit crosscheck copy at 15-AUG-18<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
Finished implicit crosscheck copy at 15-AUG-18<\/code><\/div>\n
<\/div>\n
searching <\/code>for<\/code> all files <\/code>in<\/code> the recovery area<\/code><\/div>\n
cataloging files...<\/code><\/div>\n
cataloging <\/code>done<\/code><\/div>\n
<\/div>\n
List of Cataloged Files<\/code><\/div>\n
=======================<\/code><\/div>\n
File Name: <\/code>\/u01\/app\/oracle\/fast_recovery_area\/CONT18C\/CONT18C_SITE1\/archivelog\/2018_08_15\/o1_mf_1_47_fq7q5ls5_<\/code>.arc<\/code><\/div>\n
File Name: <\/code>\/u01\/app\/oracle\/fast_recovery_area\/CONT18C\/CONT18C_SITE1\/archivelog\/2018_08_15\/o1_mf_1_48_fq7qn5s3_<\/code>.arc<\/code><\/div>\n
File Name: <\/code>\/u01\/app\/oracle\/fast_recovery_area\/CONT18C\/CONT18C_SITE1\/archivelog\/2018_08_15\/o1_mf_1_49_fq7r0715_<\/code>.arc<\/code><\/div>\n
File Name: <\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
<\/div>\n
contents of Memory Script:<\/code><\/div>\n
{<\/code><\/div>\n
\u00a0\u00a0<\/code>recover database from service\u00a0 <\/code>'CONT18c_SITE'<\/code>;<\/code><\/div>\n
}<\/code><\/div>\n
executing Memory Script<\/code><\/div>\n
<\/div>\n
Starting recover at 15-AUG-18<\/code><\/div>\n
using channel ORA_DISK_1<\/code><\/div>\n
skipping datafile 5; already restored to SCN 1550044<\/code><\/div>\n
skipping datafile 6; already restored to SCN 1550044<\/code><\/div>\n
skipping datafile 8; already restored to SCN 1550044<\/code><\/div>\n
skipping datafile 14; already restored to SCN 2112213<\/code><\/div>\n
channel ORA_DISK_1: starting incremental datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: using network backup <\/code>set<\/code> from service CONT18c_SITE<\/code><\/div>\n
destination <\/code>for<\/code> restore of datafile 00001: <\/code>\/u01\/app\/oracle\/oradata\/CONT18C\/system01<\/code>.dbf<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:35<\/code><\/div>\n
channel ORA_DISK_1: starting incremental datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: using network backup <\/code>set<\/code> from service CONT18c_SITE<\/code><\/div>\n
destination <\/code>for<\/code> restore of datafile 00003: <\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
destination <\/code>for<\/code> restore of datafile 00012: <\/code>\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/users01<\/code>.dbf<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
channel ORA_DISK_1: starting incremental datafile backup <\/code>set<\/code> restore<\/code><\/div>\n
channel ORA_DISK_1: using network backup <\/code>set<\/code> from service CONT18c_SITE<\/code><\/div>\n
destination <\/code>for<\/code> restore of datafile 00013: <\/code>\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_nolog01<\/code>.dbf<\/code><\/div>\n
channel ORA_DISK_1: restore complete, elapsed <\/code>time<\/code>: 00:00:01<\/code><\/div>\n
<\/div>\n
starting media recovery<\/code><\/div>\n
<\/div>\n
media recovery complete, elapsed <\/code>time<\/code>: 00:00:00<\/code><\/div>\n
Finished recover at 15-AUG-18<\/code><\/div>\n
flashback needs to be reenabled on standby <\/code>open<\/code><\/div>\n
Finished recover at 15-AUG-18<\/code><\/div>\n
<\/div>\n
RMAN><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And we can verify that the configuration is now sync<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit <\/code>database<\/code> 'CONT18C_SITE1'<\/code> set<\/code> state =<\/code>'APPLY-ON'<\/code>;<\/code><\/div>\n
Succeeded.<\/code><\/div>\n
DGMGRL> show configuration;<\/code><\/div>\n
<\/div>\n
Configuration - CONT18C_DR<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>CONT18C_SITE\u00a0 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CONT18C_SITE1 - Physical standby <\/code>database<\/code><\/div>\n
<\/div>\n
Fast-Start Failover: DISABLED<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 37 seconds ago)<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After opening the standby on read only mode we can verify that everything is now fine<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>alter<\/code> session <\/code>set<\/code> container=pdb1;<\/code><\/div>\n
<\/div>\n
Session altered.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name<\/code> from<\/code> v$tablespace;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
------------------------------<\/code><\/div>\n
SYSTEM<\/code><\/div>\n
SYSAUX<\/code><\/div>\n
UNDOTBS1<\/code><\/div>\n
TEMP<\/code><\/div>\n
USERS<\/code><\/div>\n
TBS_NOLOG<\/code><\/div>\n
TBS_2<\/code><\/div>\n
<\/div>\n
7 <\/code>rows<\/code> selected.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> name<\/code> from<\/code> v$datafile;<\/code><\/div>\n
<\/div>\n
NAME<\/code><\/div>\n
--------------------------------------------------------------------------------<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/system01.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/sysaux01.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/undotbs01.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/users01.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_nolog01.dbf<\/code><\/div>\n
\/u01\/app\/oracle\/oradata\/CONT18C\/PDB1\/tbs_201.dbf<\/code><\/div>\n
<\/div>\n
6 <\/code>rows<\/code> selected.<\/code><\/div>\n
<\/div>\n
SQL> <\/code>select<\/code> * <\/code>from<\/code> test;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>ID<\/code><\/div>\n
----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw With Oracle Database 18c, we can now refresh a standby database over the network using one RMAN command, RECOVER STANDBY DATABASE. The RECOVER STANDBY DATABASE command restarts the standby instance, refreshes the control file from the primary database, and automatically renames data files, temp files, and online logs. It restores new data […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[999,1431,1432,1184],"type_dbi":[],"class_list":["post-11573","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-dataguard","tag-dataguard-refresh","tag-dataguard-synchronization","tag-oracle-18c"],"acf":[],"yoast_head":"\nOracle 18c DataGuard : Rman RECOVER STANDBY DATABASE - dbi Blog<\/title>\n<meta name=\"description\" content=\"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE\" \/>\n<meta property=\"og:description\" content=\"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-15T13:08:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T15:02:04+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE\",\"datePublished\":\"2018-08-15T13:08:27+00:00\",\"dateModified\":\"2023-06-09T15:02:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/\"},\"wordCount\":320,\"commentCount\":2,\"keywords\":[\"DataGuard\",\"Dataguard refresh\",\"Dataguard synchronization\",\"Oracle 18c\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/\",\"name\":\"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2018-08-15T13:08:27+00:00\",\"dateModified\":\"2023-06-09T15:02:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-18c-dataguard-rman-recover-standby-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE - dbi Blog","description":"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE","og_description":"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/","og_site_name":"dbi Blog","article_published_time":"2018-08-15T13:08:27+00:00","article_modified_time":"2023-06-09T15:02:04+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE","datePublished":"2018-08-15T13:08:27+00:00","dateModified":"2023-06-09T15:02:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/"},"wordCount":320,"commentCount":2,"keywords":["DataGuard","Dataguard refresh","Dataguard synchronization","Oracle 18c"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/","name":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-08-15T13:08:27+00:00","dateModified":"2023-06-09T15:02:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"oracle 18c, DataGuard, Dataguard synchronization, Dataguard refresh","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-18c-dataguard-rman-recover-standby-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 18c DataGuard : Rman RECOVER STANDBY DATABASE"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11573"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11573\/revisions"}],"predecessor-version":[{"id":25778,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11573\/revisions\/25778"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11573"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11573"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11573"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}