dbvcli create-standby {-d|--name} CONFIGURATION_NAME [--OPTIONS]
dbvcli csd {-d|--name} CONFIGURATION_NAME [--OPTIONS]
Set up disaster recovery
Option | Type | Description |
|---|---|---|
| Y or N | use default values from a saved template |
| Y or N | save entered values for later use; does not perform the action |
| Y or N | enable automated standby update |
| string | interval for automated standby update in seconds |
| Y or N | register standby database with Oracle Restart or Clusterware |
| Y or N | ship archive logs from the source database while creating the standby database |
| Y or N | enable observer |
| Y or N | perform backup, transfer and restore operations in parallel when possible |
| Y or N | assume source-backup-dir and standby-backup-dir are on a shared file system; skip transferring the backup |
| Y or N | use transportable media for the database backup |
| Y or N | resume a prior create-standby operation |
| string | directory for database backup on source host |
| string | directory for database backup on standby host |
| Y or N | use existing spfile on standby host |
| key=val | set an Oracle database parameter for the standby database; can be specified multiple times |
| string | delete an Oracle database parameter for the standby database (its default value will be used); can be specified multiple times |
| string | user name to use when creating the Windows service |
| string | password to use when creating the Windows service |
[oracle@nzoel19c2 bin]$ ./dbvcli -d orclcdb csd Connecting to the Control Center at localhost:4433 ✓ Checking available actions for this configuration ✓ Collecting information about your database and hosts ✓ Resume Operation Prompt Skipped (Using Resume Transportable Media Create Standby Operation: N) Use Template 1/2 Prompt Skipped (Using Use Template: N) Register Standby Database Select whether to register a newly created standby database with Oracle Restart or Clusterware using srvctl. Register With Oracle Restart or Clusterware: (•) Yes ( ) No 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 create-standby command again. Use Transportable Media: ( ) Yes (•) No Process Options 1/3 Select whether to ship archived logs from the primary database while creating the standby database. Ship Logs While Creating Standby Database: (•) Yes ( ) No Process Options 2/3 Select whether to perform backup, transfer and restore operations in parallel when possible. Parallel Operations: (•) Yes ( ) No Process Options 3/3 Select whether to use shared space to store the database backup. Shared space is a location accessible on both the source and standby hosts. The backup will not be transferred from the source host to the standby host. Use Shared Space: ( ) Yes (•) No Backup Locations 1/2 Enter the directory to use to temporarily store the full database backup and other files on the source host. This directory must have enough free space to accommodate a full database backup of the source database. Source Backup Directory: > /home/oracle/temp Backup Locations 2/2 Enter the directory to use to temporarily store the full database backup and other files on the standby host. This directory must have enough free space to accommodate a full database backup of the source database. Standby Backup Directory: > /home/oracle/temp Standby Database Parameters Prompt Skipped (Using Use Existing Spfile: N) Standby Database Parameters The following oracle database parameters will be set in the standby database pfile or spfile. You can edit their values, or remove them to use the default value. New parameters can be added as needed. Standby Database Parameters: ParameterValue audit_file_dest /u01/app/oracle/admin/orclcdb/adump compatible 19.0.0 db_block_size 8192 db_create_file_dest +DATA db_domain oraclekiwi.co.nz db_name orclcdb db_recovery_file_dest +FRA db_recovery_file_dest_size 13350469632 db_unique_name orclcdb diagnostic_dest /u01/app/oracle dispatchers (PROTOCOL=TCP) (SERVICE=orclcdbXDB) enable_pluggable_database true instance_mode READ-WRITE open_cursors 300 pga_aggregate_target 804257792 processes 325 remote_login_passwordfile EXCLUSIVE sga_target 2412773376 spfile +DATA undo_tablespace UNDOTBS1 Windows Service 1/2 Prompt Skipped (Using Service User: ) Windows Service 2/2 Prompt Skipped (Using Service Password: ***) Save Template Select whether to proceed to create the standby database or to save the entered values as a template. If you save a template, the standby database will not be created, but the entered values will be available for use when you run this command again. Save Template or Proceed: (•) Proceed ( ) Save Template (do not create standby database) Validating settings ✓ Automated Standby Update 1/2 Select whether to enable Automated Standby Update. This will keep the standby database up to date using log backups taken at a set interval. Enable Automated Standby Update: (•) Yes ( ) No Automated Standby Update 2/2 Enter the Automated Standby Update interval in seconds. Automated Standby Update Interval: > 300 Observer Select whether to enable the Observer. The Observer will watch your Configuration, and notify you on the Dashboard in case any problems are detected with your Disaster Recovery Configuration. Enable Observer: (•) Yes ( ) No Confirmation A full backup of the source database will be created, transferred to the standby host, and used to create the standby database. Select Yes to proceed with creating the standby database, or No to cancel the operation. Create Standby Database: (•) Yes ( ) No 2024-11-14 13:20:01 2024-11-14 13:20:01 Preparing to create standby database 2024-11-14 13:20:03 We will now run a pre-flight check before standby database creation. An attempt will be made to create a standby (s)pfile using Oracle standby database parameters, followed by trying to start the standby instance. If this step fails, then please double-check the following items before re-running dbvctl again: 2024-11-14 13:20:03 1) Review the standby database parameters you have supplied and provide valid values unless a template is used. 2024-11-14 13:20:03 2) Recreate the template to provide valid values for standby database parameters if a template is used. 2024-11-14 13:20:03 Running pre-flight check for standby creation, please wait... 2024-11-14 13:20:19 done 2024-11-14 13:20:19 Creating standby control file... 2024-11-14 13:20:46 done 2024-11-14 13:20:47 ====================================================== 2024-11-14 13:20:47 WARNING: FORCE_LOGGING is disabled in the primary database! 2024-11-14 13:20:47 ====================================================== 2024-11-14 13:20:47 Total database size for orclcdb is 4.74GB 2024-11-14 13:20:48 Started logship process (pid 10997) 2024-11-14 13:20:52 Backing up primary database... 2024-11-14 13:20:52 Backing up datafile 1... 2024-11-14 13:21:31 done 2024-11-14 13:21:31 Backing up datafile 3... 2024-11-14 13:21:51 done 2024-11-14 13:21:51 Backing up datafile 4... 2024-11-14 13:21:56 done 2024-11-14 13:21:56 Backing up datafile 5... 2024-11-14 13:22:24 done 2024-11-14 13:22:24 Backing up datafile 6... 2024-11-14 13:22:35 done 2024-11-14 13:22:35 Backing up datafile 7... 2024-11-14 13:22:40 done 2024-11-14 13:22:40 Backing up datafile 8... 2024-11-14 13:22:51 done 2024-11-14 13:22:51 Backing up datafile 9... 2024-11-14 13:23:20 done 2024-11-14 13:23:20 Backing up datafile 10... 2024-11-14 13:23:30 done 2024-11-14 13:23:30 Backing up datafile 11... 2024-11-14 13:23:35 done 2024-11-14 13:23:35 Backing up datafile 12... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring backup from nzoel19c2.oraclekiwi.co.nz to nzoel19c1.oraclekiwi.co.nz... 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_1_633a421l_195_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_3_653a422s_197_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_4_673a423f_199_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_5_693a423k_201_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_6_6b3a424h_203_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_7_6d3a424s_205_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_8_6f3a4251_207_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_9_6h3a425b_209_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_10_6j3a4268_211_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:40 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_11_6l3a426j_213_1_1.RMAN... 2024-11-14 13:23:40 done 2024-11-14 13:23:43 Transferring /home/oracle/temp/DBV_ORCLCDB_CSD_DBF_12_6n3a426n_215_1_1.RMAN... 2024-11-14 13:23:43 done 2024-11-14 13:23:45 Starting standby database orclcdb on nzoel19c1.oraclekiwi.co.nz mount... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafiles on nzoel19c1.oraclekiwi.co.nz... 2024-11-14 13:23:45 Restoring datafile 1... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 3... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 4... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 5... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 6... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 7... 2024-11-14 13:23:45 done 2024-11-14 13:23:45 Restoring datafile 8... 2024-11-14 13:23:54 done 2024-11-14 13:23:54 Restoring datafile 9... 2024-11-14 13:24:13 done 2024-11-14 13:24:13 Restoring datafile 10... 2024-11-14 13:24:33 done 2024-11-14 13:24:33 Restoring datafile 11... 2024-11-14 13:24:53 done 2024-11-14 13:24:53 Restoring datafile 12... 2024-11-14 13:24:59 done 2024-11-14 13:25:00 Renaming standby redo logs and tempfiles on nzoel19c1.oraclekiwi.co.nz... 2024-11-14 13:25:02 done 2024-11-14 13:25:03 Completing standby database creation... 2024-11-14 13:25:29 done 2024-11-14 13:25:29 Standby database created. 2024-11-14 13:25:29 Performing checkpoint and archiving logs... 2024-11-14 13:25:35 done 2024-11-14 13:25:35 Synchronising standby... 2024-11-14 13:25:41 done 2024-11-14 13:25:42 Applying DR configuration 2024-11-14 13:25:42 Applying Automated Standby Update settings 2024-11-14 13:25:42 done 2024-11-14 13:25:42 Automated Standby Update enabled. 2024-11-14 13:25:42 Applying Observer settings 2024-11-14 13:25:42 Observer enabled. 2024-11-14 13:25:42 Task succeeded
Comments