sync
Vijayganesh Sivaprakasam
Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
3 min read
Loading data...
dbvcli sync {-d|--name} CONFIGURATION_NAME [--OPTIONS]Synchronize databases using incremental backups
Option | Type | Description |
|---|
Option | Type | Description |
|---|---|---|
| Y or N | synchronize lag |
| Y or N | synchronize no-logging operations |
| Y or N | use transportable media for the database backup |
| Y or N | resume a prior sync operation |
| string | directory for database backup on source host |
| string | directory for database backup on standby host |
[oracle@nzoel19c2 bin]$ ./dbvcli -d orclcdb sync
Connecting to the Control Center at localhost:4433 ✓
Checking available actions for this configuration ✓
Configuration orclcdb (nzoel19c2.oraclekiwi.co.nz -> nzoel19c1.oraclekiwi.co.nz)
┌───────────────┐┌───────────────┐
│ ││ │
│ Primary ││ Standby │
│ ││ │
│ ONLINE ││ RECOVERING │
│ ││ │
└───────────────┘└───────────────┘
Gathering information required for sync ✓
Resume Operation Prompt Skipped (Using Resume In-Progress Operation: N)
Synchronize Lag
Select whether to re-synchronize the standby database using incremental backups.
Synchronize Lag:
(•) Yes
( ) No
Synchronize No-logging Prompt Skipped (Using Synchronize No-logging: N)
Transportable Media
Select whether to use transportable media to transport the database backup from
the source host to the destination host.
The source backup directory is assumed to be media that can be physically
transported to the standby host and mounted at the standby backup directory.
The process will pause after creating the database backup. After transporting
the backup and mounting it at the standby backup directory, you will need to
resume the process by running the sync command again.
Use Transportable Media:
( ) Yes
(•) No
Backup Locations 1/2
Enter the directory to use to temporarily store the incremental database backup
and other files on the source host. Please ensure there is sufficient disk space
in these locations on source to hold a full backup of your primary database.
Even though incremental backups are used, depending on the amount of changes to
be backed up the backup could be the same size as a full database backup.
Source Backup Directory:
> /home/oracle/temp
Backup Locations 2/2
Enter the directory to use to temporarily store the incremental database backup
and other files on the standby host. Please ensure there is sufficient disk
space in these locations on source to hold a full backup of your primary
database. Even though incremental backups are used, depending on the amount of
changes to be backed up the backup could be the same size as a full database
backup.
Standby Backup Directory:
> /home/oracle/temp
Confirmation
Select Yes to proceed with synchronizing the primary and standby databases, or
No to cancel the operation.
Confirm Sync:
(•) Yes
( ) No
2024-11-14 13:30:02
2024-11-14 13:30:02 Preparing to synchronize standby database
2024-11-14 13:30:02 Disabling Observer
2024-11-14 13:30:02 done
2024-11-14 13:30:02 Disabling Automated Standby Update
2024-11-14 13:30:02 done
2024-11-14 13:30:02 -------------------------------------------------------------------------------
2024-11-14 13:30:02 Use RMAN incremental backups to synchronise a physical standby database
2024-11-14 13:30:02 with the primary database. RMAN incremental backup of the primary
2024-11-14 13:30:02 database will be created, starting at the current SCN of the standby,
2024-11-14 13:30:02 which in turn will then be used to roll the standby database forward in time.
2024-11-14 13:30:02
2024-11-14 13:30:02 RMAN incremental backups can be useful in case the physical standby database:
2024-11-14 13:30:02
2024-11-14 13:30:02 Is lagging far behind the primary database.
2024-11-14 13:30:02 Has widespread nologging changes.
2024-11-14 13:30:02 Has nologging changes on a subset of datafiles.
2024-11-14 13:30:02
2024-11-14 13:30:02 -------------------------------------------------------------------------------
2024-11-14 13:30:03 Synchronising Standby Database
2024-11-14 13:30:03 -------------------------------------------------------------------------------
2024-11-14 13:30:03 Deleting previous incremental backup...
2024-11-14 13:30:07 done
2024-11-14 13:30:07 Creating incremental backup of primary database...
2024-11-14 13:30:20 done
2024-11-14 13:30:20 Creating standby control file...
2024-11-14 13:30:30 done
2024-11-14 13:30:30 Transferring backup to standby server...
2024-11-14 13:30:30 done
2024-11-14 13:30:30 Restoring standby control file...
2024-11-14 13:31:29 done
2024-11-14 13:31:29 Cataloguing incremental backup in RMAN catalogue...
2024-11-14 13:31:36 done
2024-11-14 13:31:36 Applying incremental backup to the standby database...
2024-11-14 13:31:42 done
2024-11-14 13:31:42 Performing checkpoint and archiving logs...
2024-11-14 13:31:45 done
2024-11-14 13:31:45 Synchronising standby...
2024-11-14 13:31:51 done
2024-11-14 13:31:51 Obtaining sync summary...
2024-11-14 13:31:52 done
2024-11-14 13:31:52 Finishing synchronize
2024-11-14 13:31:52 Applying Automated Standby Update settings
2024-11-14 13:31:52 done
2024-11-14 13:31:52 Enabling Automated Standby Update
2024-11-14 13:31:52 done
2024-11-14 13:31:52 Enabling Observer
2024-11-14 13:31:52 done
2024-11-14 13:31:52
Task succeeded