create-standby, csd
- Vijayganesh Sivaprakasam
dbvcli create-standby {-d|--name} CONFIGURATION_NAME [--OPTIONS]
dbvcli csd {-d|--name} CONFIGURATION_NAME [--OPTIONS]
Set up disaster recovery
Option | Type | Description |
---|
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