{"id":13258,"date":"2020-01-16T16:23:18","date_gmt":"2020-01-16T15:23:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/"},"modified":"2023-06-15T16:41:03","modified_gmt":"2023-06-15T14:41:03","slug":"dbvisit-standby-9-do-you-know-the-new-snapshot-feature","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/","title":{"rendered":"Dbvisit Standby 9 : Do you know the new snapshot feature?"},"content":{"rendered":"

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

Dbvisit snapshot option is a new feature available starting from version 9.0.06<\/strong>. I have tested this option and in this blog I am describing the tasks I have done.
\nThe configuration I am using is following
\ndbvist1 : primary server
\ndbvist 2 : standby server
\norcl : oracle 19c database
\nWe suppose that the dbvisit environment is already set and the replication is going fine. See previous blog <\/a>for setting up dbvisit standby
\nFirst there are two options
\n-Snapshot Groups
\n-Single Snapshots<\/p>\n

Snapshot Groups<\/strong>
\nThis option is ideal for companies that are using Oracle Standard Edition (SE,SE1,SE2) where they would like to have a “database that is read-only, but also being kept up to date” . It allows to create 2 or more read-only snapshots of the standby at a time interval. The snapshot will be opened in a read-only mode after its creation. A new service which will point to the latest snapshot is created and will be automatically managed by the listener.
\nThe use of the feature is very easy. As it required managing filesystems like mount and umount, the user which will create the snapshot need some admin privileges.
\nIn our case we have configured the user with full sudo privileges, but you can find all required privileges in the documentation <\/a>.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] <\/code>sudo<\/code> grep<\/code> oracle <\/code>\/etc\/sudoers<\/code><\/div>\n
oracle ALL=(ALL) NOPASSWD:ALL<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The use of the option can be done by command line or using the graphical dbvserver console. But It is highly recommended to use the graphical tool.
\nWhen the option snapshot is available with your license, you will see following tab in the dbvserver console
\n\"\"<\/a>
\nTo create a snapshot groups we just have to choose the option NEW SNAPSHOT GROUP
\n\"\"<\/a>
\nAnd then fill the required information. In this example
\n-We will create a service named snap_service
\n-We will generate a snapshot every 15 minutes (900 secondes)
\nThere will be a maximum of 2 snapshots. When the limit is reached, the oldest snapshop is deleted. Just note that the latest snapshot will be deleted only when the new snapshot is successfully created. That\u2019s why we can have sometimes 3 snapshots
\n-The snapshots will be prefixed by MySna
\n\"\"<\/a>
\nAfter the snapshots are created without errors, we have to start the snapshots generation by clicking on the green button
\n\"\"<\/a>
\nAnd then we can see the status
\n\"\"<\/a>
\nOn OS level we can verify that the first snapshot is created and that the corresponding instance started<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] <\/code>ps<\/code> -ef | <\/code>grep<\/code> pmon<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 2300\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 09:05 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_orcl<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 6765\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 09:57 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_MySna001<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 7794\u00a0 1892\u00a0 0 10:00 pts<\/code>\/0<\/code>\u00a0\u00a0\u00a0 00:00:00 <\/code>grep<\/code> --color=auto pmon<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can also verify that the service snap_service is registered in the listener. This service will be automatically pointed to the latest snapshot of the group.<\/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<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] lsnrctl status<\/code><\/div>\n
<\/div>\n
LSNRCTL <\/code>for<\/code> Linux: Version 19.0.0.0.0 - Production on 16-JAN-2020 10:01:49<\/code><\/div>\n
<\/div>\n
Copyright (c) 1991, 2019, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbvisit2)(PORT=1521)))<\/code><\/div>\n
STATUS of the LISTENER<\/code><\/div>\n
------------------------<\/code><\/div>\n
Alias\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LISTENER<\/code><\/div>\n
Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TNSLSNR <\/code>for<\/code> Linux: Version 19.0.0.0.0 - Production<\/code><\/div>\n
Start Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16-JAN-2020 09:05:07<\/code><\/div>\n
Uptime\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 days 0 hr. 56 min. 42 sec<\/code><\/div>\n
Trace Level\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 off<\/code><\/div>\n
Security\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ON: Local OS Authentication<\/code><\/div>\n
SNMP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OFF<\/code><\/div>\n
Listener Parameter File\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/network\/admin\/listener<\/code>.ora<\/code><\/div>\n
Listener Log File\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/code>\/u01\/app\/oracle\/diag\/tnslsnr\/dbvisit2\/listener\/alert\/log<\/code>.xml<\/code><\/div>\n
Listening Endpoints Summary...<\/code><\/div>\n
\u00a0\u00a0<\/code>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbvisit2)(PORT=1521)))<\/code><\/div>\n
\u00a0\u00a0<\/code>(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))<\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
Service <\/code>\"snap_service\"<\/code> has 1 instance(s).<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"MySna001\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
The <\/code>command<\/code> completed successfully<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To connect to this service, we just have to create an alias like<\/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<\/td>\n
\n
\n
snapgroup =<\/code><\/div>\n
\u00a0\u00a0<\/code>(DESCRIPTION =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(ADDRESS = (PROTOCOL = TCP)(HOST = dbvisit2)(PORT = 1521))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(CONNECT_DATA =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(SERVER = DEDICATED)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(SERVICE_NAME = snap_service)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>)<\/code><\/div>\n
\u00a0\u00a0<\/code>)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

15 minutes later we can see that a new snapshot was generated<\/p>\n

\"\"<\/a><\/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<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] <\/code>ps<\/code> -ef | <\/code>grep<\/code> pmon<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 2300\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 09:05 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_orcl<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 6765\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 09:57 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_MySna001<\/code><\/div>\n
oracle\u00a0\u00a0 11355\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 10:11 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_MySna002<\/code><\/div>\n
oracle\u00a0\u00a0 11866\u00a0 1892\u00a0 0 10:13 pts<\/code>\/0<\/code>\u00a0\u00a0\u00a0 00:00:00 <\/code>grep<\/code> --color=auto pmon<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Note that we can only open the snapshot in a read only mode<\/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
oracle@dbvisit1:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] sqlplus sys\/*****@snapgroup as sysdba<\/code><\/div>\n
<\/div>\n
SQL> show pdbs<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>CON_ID CON_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN MODE\u00a0 RESTRICTED<\/code><\/div>\n
---------- ------------------------------ ---------- ----------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 PDB$SEED\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ ONLY\u00a0 NO<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 PDB1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>4 PDB2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MOUNTED<\/code><\/div>\n
SQL> alter pluggable database all <\/code>open<\/code>;<\/code><\/div>\n
alter pluggable database all <\/code>open<\/code><\/div>\n
*<\/code><\/div>\n
ERROR at line 1:<\/code><\/div>\n
ORA-65054: Cannot <\/code>open<\/code> a pluggable database <\/code>in<\/code> the desired mode.<\/code><\/div>\n
<\/div>\n
<\/div>\n
SQL>\u00a0 alter pluggable database all <\/code>open<\/code> read<\/code> only;<\/code><\/div>\n
<\/div>\n
Pluggable database altered.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Of course you have probably seen that you can stop, start, pause and remove snapshots from the GUI.<\/p>\n

Single Snapshot<\/strong>
\nThis option allows to create read-only as well read-write snapshots for the database.
\nTo create a single snapshot , we just have to choose the NEW SINGLE SNAPSHOT
\nIn the following example the snapshot will be opened in a read write mode
\n\"\"<\/a>
\nAt this end of the creation we can see the status
\n\"\"<\/a><\/p>\n

\"\"<\/a><\/p>\n

We can verify that a service SingleSn was also created<\/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<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] lsnrctl status | <\/code>grep<\/code> Singl<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
Service <\/code>\"SingleSn\"<\/code> has 1 instance(s).<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service...<\/code><\/div>\n
\u00a0\u00a0<\/code>Instance <\/code>\"SingleSn\"<\/code>, status READY, has 1 handler(s) <\/code>for<\/code> this service<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And that the instance SinglSn is started<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)] <\/code>ps<\/code> -ef | <\/code>grep<\/code> pmon<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 3294\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 16:04 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_SingleSn<\/code><\/div>\n
oracle\u00a0\u00a0\u00a0 3966\u00a0 1748\u00a0 0 16:08 pts<\/code>\/0<\/code>\u00a0\u00a0\u00a0 00:00:00 <\/code>grep<\/code> --color=auto pmon<\/code><\/div>\n
oracle\u00a0\u00a0 14349\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 13:57 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:00 ora_pmon_orcl<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [orcl (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can also remark that at OS level, a filesystem is mounted for the snap. So there must be enough free space at the LVM that host the database.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [MySna004 (CDB$ROOT)] <\/code>df<\/code> -h | <\/code>grep<\/code> snap<\/code><\/div>\n
\/dev\/mapper\/ora_data-SingleSn<\/code>\u00a0\u00a0 25G\u00a0\u00a0 18G\u00a0 6.3G\u00a0 74% <\/code>\/u01\/app\/dbvisit\/standby\/snap\/orcl\/SingleSn<\/code><\/div>\n
oracle@dbvisit2:<\/code>\/home\/oracle\/<\/code> [MySna004 (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Using the alias<\/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<\/td>\n
\n
\n
singlesnap =<\/code><\/div>\n
\u00a0\u00a0<\/code>(DESCRIPTION =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(ADDRESS = (PROTOCOL = TCP)(HOST = dbvisit2)(PORT = 1521))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(CONNECT_DATA =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(SERVER = DEDICATED)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(SERVICE_NAME = SingleSn)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>)<\/code><\/div>\n
\u00a0\u00a0<\/code>)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see that new snapshot is opened in read write mode<\/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<\/td>\n
\n
\n
SQL> <\/code>select<\/code> name,open_mode from <\/code>v<\/code>$database;<\/code><\/div>\n
<\/div>\n
NAME\u00a0\u00a0\u00a0\u00a0\u00a0 OPEN_MODE<\/code><\/div>\n
--------- --------------------<\/code><\/div>\n
SINGLESN\u00a0 READ WRITE<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

What we will retain is that a snapshot groups is a group of snapshots taken at a regular time interval. These kinds of snapshots can only be opened in a read only mode.
\nThe single snapshot can be created in a read only or read write mode. When opened in read write mode, it can be compared maybe to Oracle snapshot standby.
\nThe option dbvisit snapshot required a license and is only supported on linux.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose […]<\/p>\n","protected":false},"author":27,"featured_media":13259,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[221,1795,1171],"type_dbi":[],"class_list":["post-13258","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-data-guard","tag-dbvisit-9-standby","tag-oracle-19c"],"acf":[],"yoast_head":"\nDbvisit Standby 9 : Do you know the new snapshot feature? - dbi Blog<\/title>\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\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dbvisit Standby 9 : Do you know the new snapshot feature?\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-16T15:23:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:41:03+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"258\" \/>\n\t<meta property=\"og:image:height\" content=\"277\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"8 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\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Dbvisit Standby 9 : Do you know the new snapshot feature?\",\"datePublished\":\"2020-01-16T15:23:18+00:00\",\"dateModified\":\"2023-06-15T14:41:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/\"},\"wordCount\":673,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pict1.jpg\",\"keywords\":[\"Data Guard\",\"dbvisit 9 standby\",\"Oracle 19c\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/\",\"name\":\"Dbvisit Standby 9 : Do you know the new snapshot feature? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pict1.jpg\",\"datePublished\":\"2020-01-16T15:23:18+00:00\",\"dateModified\":\"2023-06-15T14:41:03+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pict1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/pict1.jpg\",\"width\":258,\"height\":277},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Dbvisit Standby 9 : Do you know the new snapshot feature?\"}]},{\"@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":"Dbvisit Standby 9 : Do you know the new snapshot feature? - dbi Blog","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\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/","og_locale":"en_US","og_type":"article","og_title":"Dbvisit Standby 9 : Do you know the new snapshot feature?","og_description":"By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose […]","og_url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/","og_site_name":"dbi Blog","article_published_time":"2020-01-16T15:23:18+00:00","article_modified_time":"2023-06-15T14:41:03+00:00","og_image":[{"width":258,"height":277,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Dbvisit Standby 9 : Do you know the new snapshot feature?","datePublished":"2020-01-16T15:23:18+00:00","dateModified":"2023-06-15T14:41:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/"},"wordCount":673,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg","keywords":["Data Guard","dbvisit 9 standby","Oracle 19c"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/","url":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/","name":"Dbvisit Standby 9 : Do you know the new snapshot feature? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg","datePublished":"2020-01-16T15:23:18+00:00","dateModified":"2023-06-15T14:41:03+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pict1.jpg","width":258,"height":277},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/dbvisit-standby-9-do-you-know-the-new-snapshot-feature\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Dbvisit Standby 9 : Do you know the new snapshot feature?"}]},{"@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\/13258","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=13258"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13258\/revisions"}],"predecessor-version":[{"id":25958,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13258\/revisions\/25958"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13259"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13258"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}