Oracle Database CLI Reference

The Database CLI (dbcli) is a command line interface available for Base Database Service. After you connect to the DB system in the Base Database Service, you can use the dbcli to perform tasks such as creating Oracle database homes and databases.

Operational Notes

• The database CLI commands must be run as the root user.

• dbcli is in the /opt/oracle/dcs/bin/ directory.

  This directory is included in the path for the root user's environment.

• Oracle Database maintains logs of the dbcli command output in the dcscli.log and dcs-agent.log files in the /opt/oracle/dcs/log/ directory.

• The database CLI commands and most parameters are case sensitive and should be typed as shown. A few parameters are not case sensitive, as indicated in the parameter descriptions, and can be typed in uppercase or lowercase.

Syntax

The database CLI commands use the following syntax:

dbcli command [parameters]

where:

• command is a verb-object combination such as create-database.
• parameters include additional options for the command. Most parameter names are preceded with two dashes, for example, --help. Abbreviated parameter names are preceded with one dash, for example, -h.
• User-specified parameter values are shown in red text within angle brackets, for example, <db_home_id>. Omit the angle brackets when specifying these values.
• The help parameter is available with every command.

The remainder of this topic contains syntax and other details about the commands.

CLI Update Command

Occasionally, new commands are added to the database CLI and other commands are updated to support new features. You can use the following command to update the database CLI:

cliadm update-dbcli

Use the cliadm update-dbcli command to update the database CLI with the latest new and updated commands.

Note:

On RAC DB systems, execute the cliadm update-dbcli command on each node in the cluster.

Syntax

cliadm update-dbcli [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command updates the dbcli:

cliadm update-dbcli

Output:

{
  "jobId" : "dc9ce73d-ed71-4473-99cd-9663b9d79bfd",
  "status" : "Created",
  "message" : "Dcs cli will be updated",
  "reports" : [ ],
  "createTimestamp" : "January 18, 2017 10:19:34 AM PST",
  "resourceList" : [ ],
  "description" : "dbcli patching",
  "updatedTime" : "January 18, 2017 10:19:34 AM PST"
}

Agent Commands

The following command is available to manage agents: 

• dbcli ping-agent

dbcli ping-agent

Use the dbcli ping-agent command to test the reachability of an agent.

Syntax

dbcli ping-agent [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Autologcleanpolicy Commands

The following commands are available to manage policies for automatic cleaning (purging) of logs.

• dbcli create-autoLogCleanPolicy
• dbcli list-autoLogCleanPolicy

dbcli create-autoLogCleanPolicy

Use the dbcli create-autoLogCleanPolicy command to create policies for automatic cleaning (purging) of logs.

Syntax

dbcli create-autoLogCleanPolicy 
  [-c {gi|database|dcs}] 
  [-f <number>] 
  [-o <number>] 
  [-u {Day|Hour|Minute}] 
  [-uMB <number>] 
  [-uPer <number>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--components	(Optional) Components to purge. Possible values are gi, database, and dcs. Separate multiple values with commas. Example: gi,dcs
-f	--freeSpaceBelowPercentage	(Optional) Purges logs when the free disk space is below the specified percentage of the total partition size. Valid range: 20-50. Default: 20.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-o	--olderthan	(Optional) Quantity portion of time interval. Default: 30. Cleans logs older than the specified time interval (-o and -u).
-u	--olderThanUnit	(Optional) Unit portion of time interval. Possible values: Day, Hour, or Minute. Default: Day. Cleans logs older than the specified time interval (-o and -u).
-uMB	--usageOverMB	(Optional) Purges logs when log usage exceeds the specified number of MegaBytes (MB). Valid range: 10 to 50% of total partition size.
-uPer	--usageOverPercentage	(Optional) Purges logs when log usage exceeds the specified percentage of the total partition size. Valid range: 10-50.

dbcli list-autoLogCleanPolicy

Use the dbcli list-autoLogCleanPolicy command to list policies for automatic cleaning of logs.

Syntax

dbcli list-autoLogCleanPolicy 
  [-c {gi|database|dcs}] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--components	(Optional) Components. Possible values are gi, database, and dcs. Separate multiple values with commas. Example: gi,dcs
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Backup Commands

The following commands are available to back up databases: 

• dbcli create-backup
• dbcli getstatus-backup
• dbcli schedule-backup

Note:

Instead of using dbcli, you can use the Console or the API to manage backing up the databases your DB system to the Object Storage. However, if you switch from using dbcli to using managed backups, a new backup configuration is created and associated with your database, and backups you created by using dbcli will not be accessible from the managed backup interfaces. For information about managed backups, see Back Up and Recovery in Base Database Service.

Before you can back up a database by using the dbcli create-backup command, you'll need to:

1. Create a backup configuration by using the dbcli create-backupconfig command.
2. Associate the backup configuration with the database by using the dbcli update-database command.

After a database is associated with a backup configuration, you can use the dbcli create-backup command in a cron job to run backups automatically. You can use a cron utility such as CronMaker to help build expressions. For more information, see CronMaker.

dbcli create-backup

Use the dbcli create-backup command to create a backup of a database.

Syntax

dbcli create-backup 
  -in <db_name> 
  -i <db_id> 
  [-bt {Regular-L0|Regular-L1|Longterm|ArchiveLog}] 
  [-c {Database|TdeWallet}] 
  [-k <n>] 
  [-t <tag>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-bt	--backupType	(Optional) Backup type. Possible values are Regular-L0, Regular-L1, Longterm, and ArchiveLog. Regular-L0 and Regular L1 correspond to incremental L0 and L1 backups. Longterm corresponds to Full backup. ArchiveLog corresponds to archived redo logs backup. The default value is Regular-L1. Values are not case-sensitive. If omitted, the default value is used.
-c	--component	(Optional) Component. Possible values are Database and TdeWallet. The default value is Database. The value TdeWallet backs up TDE wallets. Values are not case-sensitive. If omitted, the default value is used. Note that the TDE wallets are automatically backed up in the following situations:  A database is created with an Object Storage backup configuration. A database that has an Object Storage backup configuration is updated. An Object Storage backup configuration is updated. A backup of the type Longterm is created. The TDE key for a database is rotated. A database is backed up and no TDE wallet backups exist yet.
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	The ID of the database to back up. Use the dbcli list-databases command to get the database's ID.
-in	--dbName	The name of the database to back up. Use the dbcli list-databases command to get the database's name.
-j	--json	(Optional) Displays JSON output.
-k	--keepDays	(Optional) Specifies the time until which the backup or copy must be kept. After this time the backup is obsolete, regardless of the backup retention policy settings. For Longterm backup type only.
-t	--tag	(Required for Longterm backup type) Specifies a user-specified tag name for a backup set and applies this tag to the output files generated by the command. This value is not case sensitive. Valid number of characters: 1 to 30. The characters are limited to the characters that are valid in file names on the target file system. For example, ASM does not support the use of the hyphen (-) character in the file names it uses internally, so weekly-incremental is not a valid tag name for backups in ASM disk groups. Environment variables are not valid in the TAG parameter.

Examples

The following command creates a backup of the specified database using the database ID.

dbcli create-backup -i 573cadb2-0cc2-4c1c-9c31-595ab8963d5b

The following command creates a backup of the specified database using the database name ("mydb").

dbcli create-backup -in mydb

dbcli getstatus-backup

Use the dbcli getstatus-backup command to display the status of a backup.

Syntax

dbcli getstatus-backup 
  -t <backup_type> 
  [i <id>] 
  [-in <name>] 
  [-l] [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbId	(Optional) Database Resource ID.
-in	--dbName	(Optional) Database Resource Name.
-j	--json	(Optional) Displays JSON output.
-l	--isLatestBackupReport	(Optional) Latest backup report. Default: true.
-t	--backupType	Backup type.

dbcli schedule-backup

Use the dbcli schedule-backup command to schedule a backup of a database.

Syntax

dbcli schedule-backup 
  -t <backup_type> 
  -f <number> 
  [i <id>] 
  [-in <name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-f	--frequency	Frequency in minutes.
-h	--help	(Optional) Displays help for using the command.
-i	--dbId	(Optional) Database Resource ID.
-in	--dbName	(Optional) Database Resource Name.
-j	--json	(Optional) Displays JSON output.
-t	--backupType	Backup type.

Backupconfig Commands

A backup configuration determines the backup destination and recovery window for database backups. You create the backup configuration and then associate it with a database by using the dbcli update-database command.

Note:

Backups that were configured using the Console may become unusable if you make changes using these commands. For backups configured using the Console, use these commands with support guidance only.

Note:

Instead of using dbcli, you can use the Console or the API to manage backing up the databases in your DB system to the Object Storage. For information about managed backups, see Back Up and Recovery in Base Database Service.

After a database is associated with a backup configuration, you can use the dbcli create-backup command in a cron job to run backups automatically. You can use a cron utility such as CronMaker to help build expressions. For more information, see CronMaker.

The following commands are available to manage backup configurations:

• dbcli create-backupconfig
• dbcli list-backupconfigs
• dbcli describe-backupconfig
• dbcli update-backupconfig
• dbcli delete-backupconfig

dbcli create-backupconfig

Use the dbcli create-backupconfig command to create a backup configuration that defines the backup destination and recovery windows.

Syntax

dbcli create-backupconfig 
  -d {DISK|OBJECTSTORE|NONE} 
  -c <bucket>  
  -o <object_store_swift_id> 
  -on <object_store_swift_name> 
  -w <n> 
  -n <name> 
  [-cr|-no-cr] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--container	The name of an existing bucket in the Oracle Cloud Infrastructure Object Storage service. You can use the Console or the Object Storage API to create the bucket. For more information, see Managing Buckets. You must also specify --backupdestination objectstore and the --objectstoreswiftId parameter.
-cr -no-cr	--crosscheck --no-crosscheck	(Optional) Indicates whether to enable the crosscheck operation. This operation determines if the files on the disk or in the media management catalog correspond to data in the RMAN repository. If omitted, the default setting is used (crosscheck is enabled by default).
-d	--backupdestination	The backup destination as one of the following (these values are not case sensitive): DISK - The local Fast Recovery Area. OBJECTSTORE - The Oracle Cloud Infrastructure Object Storage service. You must also specify the --container and --objectstoreswiftId parameters. NONE - Disables the backup.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-n	--name	The name of the backup configuration.
-o	--objectstoreswiftId	The ID of the object store that contains the endpoint and credentials for the Oracle Cloud Infrastructure Object Storage service. Use the dbcli list-objectstoreswifts command to get the object store ID. Use the dbcli create-objectstoreswift command to create an object store. You must also specify --backupdestination objectstore and the --container parameter.
-on	--objectstoreswiftName	The name of the object store that contains the endpoint and credentials for the Oracle Cloud Infrastructure Object Storage service. Use the dbcli list-objectstoreswifts command to get the object store ID. Use the dbcli create-objectstoreswift command to create an object store. You must also specify --backupdestination objectstore and the --container parameter.
-w	--recoverywindow	The number of days for which backups and archived redo logs are maintained. The interval always ends with the current time and extends back in time for the number of days specified. For a DISK backup destination, specify 1 to 14 days. For an OBJECTSTORE backup destination, specify 1 to 30 days.

Example

The following command creates a backup configuration named 'dbbkcfg1':

dbcli create-backupconfig -d Disk -w 7 -n dbbkcfg1

Output:

{
  "jobId" : "4e0e6011-db53-4142-82ef-eb561658a0a9",
  "status" : "Success",
  "message" : null,
  "reports" : [ {
    "taskId" : "TaskParallel_919",
    "taskName" : "persisting backup config metadata",
    "taskResult" : "Success",
    "startTime" : "November 18, 2016 20:21:25 PM UTC",
    "endTime" : "November 18, 2016 20:21:25 PM UTC",
    "status" : "Success",
    "taskDescription" : null,
    "parentTaskId" : "TaskSequential_915",
    "jobId" : "4e0e6011-db53-4142-82ef-eb561658a0a9",
    "tags" : [ ],
    "reportLevel" : "Info",
    "updatedTime" : "November 18, 2016 20:21:25 PM UTC"
  } ],
  "createTimestamp" : "November 18, 2016 20:21:25 PM UTC",
  "description" : "create backup config:dbbkcfg1",
  "updatedTime" : "November 18, 2016 20:21:25 PM UTC"
}

dbcli list-backupconfigs

Use the dbcli list-backupconfigs command to list all the backup configurations in the DB system.

Syntax

dbcli list-backupconfigs [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command lists a backup configuration:

dbcli list-backupconfigs

Output:

ID                                       Name                 RecoveryWindow     BackupDestination CreateTime
---------------------------------------- -------------------- ------------------ ----------------- -----------------------------
ccdd56fe-a40b-4e82-b38d-5f76c265282d     dbbkcfg1             7                  Disk              July 10, 2016 12:24:08 PM UTC

dbcli describe-backupconfig

Use the dbcli describe-backupconfig command to show details about a specific backup configuration.

Syntax

dbcli describe-backupconfig -i <id> -in <name> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--backupconfigid	The backup configuration ID. Use the dbcli list-backupconfigs command to get the ID.
-in	--backupconfigname	The backup configuration name. Use the dbcli list-backupconfigs command to get the name.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays details about a backup configuration:

dbcli describe-backupconfig -i ccdd56fe-a40b-4e82-b38d-5f76c265282d

Output:

Backup Config details
----------------------------------------------------------------
                     ID: ccdd56fe-a40b-4e82-b38d-5f76c265282d
                   Name: dbbkcfg1
         RecoveryWindow: 7
      BackupDestination: Disk
            CreatedTime: July 10, 2016 12:24:08 PM UTC
            UpdatedTime: July 10, 2016 12:24:08 PM UTC

dbcli update-backupconfig

Use the dbcli update-backupconfig command to update an existing backup configuration.

Syntax

dbcli update-backupconfig 
  -i <id> 
  -in <name> 
  -w <n> 
  -d {DISK|OBJECTSTORE|NONE} 
  -c <bucket> 
  -o <object_store_swift_id> 
  -on <object_store_swift_name> 
  [-cr|-no-cr] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--container	The name of an existing bucket in the Oracle Cloud Infrastructure Object Storage service. You can use the Console or the Object Storage API to create the bucket. For more information, see Managing Buckets. You must also specify --backupdestination objectstore and the --objectstoreswiftId parameter.
-cr -no-cr	--crosscheck --no-crosscheck	(Optional) Indicates whether to enable the crosscheck operation. This operation determines if the files on the disk on in the media management catalog correspond to data in the RMAN repository. If omitted, the default setting is used (crosscheck is enabled by default).
-h	--help	(Optional) Displays help for using the command.
-i	--backupconfigid	The ID of the backup configuration to update. Use the dbcli list-backupconfigs command to get the ID.
-in	--backupconfigname	The name of the backup configuration to update. Use the dbcli list-backupconfigs command to get the name.
-j	--json	(Optional) Displays JSON output.
-o	--objectstoreswiftId	The ID of the object store that contains the endpoint and credentials for the Oracle Cloud Infrastructure Object Storage service. Use the dbcli list-objectstoreswifts command to get the object store ID. Use the dbcli create-objectstoreswift command to create an object store. You must also specify --backupdestination objectstore and the --container parameter.
-on	--objectstoreswiftname	The name of the object store that contains the endpoint and credentials for the Oracle Cloud Infrastructure Object Storage service. Use the dbcli list-objectstoreswifts command to get the object store ID. Use the dbcli create-objectstoreswift command to create an object store. You must also specify --backupdestination objectstore and the --container parameter.
-w	--recoverywindow	The new disk recovery window. For a DISK backup destination, specify 1 to 14 days. For an OBJECTSTORE backup destination, specify 1 to 30 days.

Example

The following command updates the recovery window for a backup configuration:

dbcli update-backupconfig -i ccdd56fe-a40b-4e82-b38d-5f76c265282d -w 5

Output:

{
  "jobId" : "0e849291-e1e1-4c7a-8dd2-62b522b9b807",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : 1468153731699,
  "description" : "update backup config: dbbkcfg1",
  "updatedTime" : 1468153731700
}

dbcli delete-backupconfig

Use the dbcli delete-backupconfig command to delete a backup configuration.

Syntax

dbcli delete-backupconfig -i <id> -in <name> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--id	The backup configuration ID to delete. Use the dbcli list-backupconfigs command to get the ID.
-in	--backupconfigname	The name of the backup configuration to delete. Use the dbcli list-backupconfigs command to get the name.
-j	--json	(Optional) Displays JSON output.

Example

The following command deletes the specified backup configuration:

dbcli delete-backupconfig -i ccdd56fe-a40b-4e82-b38d-5f76c265282d

Component Command

dbcli describe-component

Your DB system might not include this newer command. If you have trouble running the command, use the CLI Update Command command to update the database CLI and then retry the command.

Note:

The dbcli describe-component command is not available on 2-node RAC DB systems. Patching 2-node systems from Object Storage is not supported.

Use the dbcli describe-component command to show the installed and available patch versions for the server, storage, and/or database home components in the DB system.

This command requires a valid Object Storage credentials configuration. If the configuration is missing or invalid, the command fails with the error: Failed to connect to the object store. Please provide valid details.

For more information about updating the CLI, creating the credentials configuration, and applying patches, see Update a DB System.

Syntax

dbcli describe-component 
  [-s <server_group>] 
  [-d <db_group>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-d	--dbhomes	(Optional) Lists the installed and available patch versions for only the database home components.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-s	--server	(Optional) Lists the installed and available patch versions for only the server components.

Example

The following command to show the current component versions and the available patch versions in the object store:

dbcli describe-component

Output:

System Version
---------------
12.1.2.10.0

Component                                Installed Version    Available Version
---------------------------------------- -------------------- --------------------
OAK                                      12.1.2.10.0          up-to-date
GI                                       12.1.0.2.161018      up-to-date
ORADB12102_HOME1                         12.1.0.2.161018      up-to-date  
ORADB12102_HOME2, ORADB12102_HOME3       12.1.0.2.160719      12.1.0.2.161018  

Database Commands

The following commands are available to manage databases:

• dbcli clone-database
• dbcli describe-database
• dbcli list-databases
• dbcli modify-database
• dbcli recover-database
• dbcli register-database
• dbcli update-database

dbcli clone-database

Use the dbcli clone-database command to clone a database.

Syntax

dbcli clone-database 
  -f <name> 
  -u <name> 
  -n <name> 
  [-s <shape>] 
  [-t <type>] 
  [m <sys_password>] 
  [-p <tde_password>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-f	--sourcedbname	Source database name.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-m	--syspassword	(Optional) Password for SYS.
-n	--dbname	Database name.
-p	--tdepassword	(Optional) Password for source TDE wallet.
-s	--dbshape	(Optional) Database shape. Examples: odb1, odb2.
-t	--dbtype	(Optional) Database Type: SI
-u	--databaseUniqueName	Database unique name.

dbcli describe-database

Use the dbcli describe-database command to display database details.

Syntax

dbcli describe-database 
  -i <db_id> 
  -in <db_name> 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	The ID of the database to display. Use the dbcli list-databases command to get the database ID.
-in	--dbName	The name of the database to display. Use the dbcli list-databases command to get the database name.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays information for a database named b727bf80-c99e-4846-ac1f-28a81a725df6:

dbcli describe-dbhome -i b727bf80-c99e-4846-ac1f-28a81a725df6

Output:

DB Home details
----------------------------------------------------------------
                      ID: b727bf80-c99e-4846-ac1f-28a81a725df6
                    Name: OraDB12102_home1
                 Version: 12.1.0.2
           Home Location: /u01/app/orauser/product/12.1.0.2/dbhome_1
                 Created: Jun 2, 2016 10:19:23 AM

dbcli list-databases

Use the dbcli list-databases command to list all databases on the DB system.

Syntax

dbcli  list-databases [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays a list of databases:

dbcli  list-databases

Output:

ID                                       DB Name    DB Version           CDB        Class    Shape    Storage    Status
---------------------------------------- ---------- -------------------- ---------- -------- -------- ---------- ----------
80ad855a-5145-4f8f-a08f-406c5e4684ff     dbst       12.1.0.2             true       OLTP     odb2     ACFS       Configured
6f4e36ae-120b-4436-b0bf-d0c4aef9f7c9     db11tsta   11.2.0.4             false      OLTP     odb1     ACFS       Configured
d8e31790-84e6-479c-beb0-ef97207091a2     db11tstb   11.2.0.4             false      OLTP     odb1     ACFS       Configured
cce096c7-737b-447a-baa1-f4c2a330c030     pdbtst     12.1.0.2             true       OLTP     odb1     ACFS       Configured

The following command displays the JSON output for a database:

dbcli list-databases -j

Output:

[ {
  "id" : "80ad855a-5145-4f8f-a08f-406c5e4684ff",
  "name" : "dbtst",
  "dbName" : "dbtst",
  "databaseUniqueName" : "dbtst_phx1cs",
  "dbVersion" : "12.1.0.2",
  "dbHomeId" : "2efe7af7-0b70-4e9b-ba8b-71f11c6fe287",
  "instanceOnly" : false,
  "registerOnly" : false,
  "dbId" : "167525515",
  "isCdb" : true,
  "pdBName" : "pdb1",
  "pdbAdminUserName" : "pdbuser",
  "enableTDE" : true,
  "dbType" : "SI",
  "dbTargetNodeNumber" : "0",
  "dbClass" : "OLTP",
  "dbShape" : "odb2",
  "dbStorage" : "ACFS",
  "dbCharacterSet" : {
    "characterSet" : "US7ASCII",
    "nlsCharacterset" : "AL16UTF16",
    "dbTerritory" : "AMERICA",
    "dbLanguage" : "AMERICAN"
  },
  "dbConsoleEnable" : false,
  "backupConfigId" : null,
  "backupDestination" : "NONE",
  "cloudStorageContainer" : null,
  "state" : {
    "status" : "CONFIGURED"
  },
  "createTime" : "November 09, 2016 17:23:05 PM UTC",
  "updatedTime" : "November 09, 2016 18:00:47 PM UTC"
}

dbcli modify-database

Use the dbcli modify-database command to modify a database.

Syntax

dbcli modify-database 
  -i <db_id> 
  -dh <destination_db_home_id> 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-dh	--destdbhomeid	Destination database home ID.
-h	--help	(Optional) Displays help for using the command.
-i	--databaseid	Database ID.
-j	--json	(Optional) Displays JSON output.

dbcli recover-database

Use the dbcli recover-database command to recover a database.

Syntax

dbcli recover-database 
  [-br <json>] 
  [-in <db_name>] 
  [-i <db_id>] 
  [-r <time>] 
  [-t {Latest|PITR|SCN}] 
  [-s] 
  [-l <location>] 
  [-tp <tde_password>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-br	--backupReport	(Optional) JSON input for backup report.
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	(Optional) Database resource ID.
-in	--dbName	(Optional) Database name.
-j	--json	(Optional) Displays JSON output.
-l	--tdeWalletLocation	(Optional) TDE wallet backup location. TDE wallet should be backed up in tar.gz format.
-r	--recoveryTimeStamp	(Required when recovery type is PITR) Recovery timestamp in the format mm/dd/yyyy hh:mi:ss. Default: [ ]
-s	--scn	(Required when recovery type is SCN) SCN.
-t	--recoverytype	(Required when backup report is provided) Recovery type. Possible values are Latest, PITR, and SCN.
-tp	--tdeWalletPassword	(Optional) TDE wallet password.

dbcli register-database

Use the dbcli register-database command to register a database that has been migrated to Oracle Cloud Infrastructure. The command registers the database to the dcs-agent so it can be managed by the dcs-agent stack.

Note:

The dbcli register-database command is not available on 2-node RAC DB systems.

Syntax

dbcli  register-database 
  -bi <bkup_config_id> 
  -c {OLTP|DSS|IMDB} 
  [-co|-no-co] 
  -s {odb1|odb2|...} 
  -t SI 
  [-o <db_host_name>] 
  [-tp <password>] 
  -sn <service_name> 
  -p 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-bi	--backupconfigid	Defines the backup configuration ID. Use the dbcli list-backupconfigs command to get the ID.
-c	--dbclass	Defines the database class. The options are OLTP, DSS, or IMDB. The default is OLTP. For Enterprise Editions, all three classes are supported. For Standard Edition, only OLTP is supported.
-co -no-co	--dbconsole --no-dbconsole	(Optional) Indicates whether the Database Console is enabled or not. If omitted, the console is not enabled.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-o	--hostname	(Optional) Defines the database host name. The default is Local host name.
-p	--syspassword	Defines a strong password for SYS. Specify -p with no password. You will be prompted for the password. If you must provide the password in the command, for example in a script, use -hp <password> instead of -p.
-s	--dbshape	Defines the database sizing template to use for the database. For example, odb1, odb2, and odb3.
-sn	--servicename	Defines the database service name used to build the EZCONNECT string for connecting to the database. The connect string format is hostname:port/servicename.
-t	--dbtype	(Optional) Defines the Database Type as single node (SI). The default value is SI.
-tp	--tdeWalletPassword	(Optional) Password for TDE wallet. Required if TDE is enabled on the migrated database.

Example

The following command registers the database with the specified database class, service name, and database sizing template.

dbcli register-database -c OLTP -s odb1 -sn crmdb.example.com -p

Output:

Password for SYS:
{
  "jobId" : "317b430f-ad5f-42ae-bb07-13f053d266e2",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "August 08, 2016 05:55:49 AM EDT",
  "description" : "Database service registration with db service name: crmdb.example.com",
  "updatedTime" : "August 08, 2016 05:55:49 AM EDT"
}

dbcli update-database

Use the dbcli update-database command to associate a backup configuration with a database.

Syntax

dbcli update-database 
  -i <db_id> 
  -bi <bkup_config_id> 
  -bin <bkup_config_name>;
  [-id <id>] 
  -in <name> 
  [-no-ab] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-bi	--backupconfigid	Defines the backup configuration ID. Use the dbcli list-backupconfigs command to get the ID.
-bin	--backupconfigname	Defines the backup configuration name for future use. Use the dbcli list-backupconfigs command to get the name.
-id	--databaseid	(Optional.) Specifies the DBID, which is a unique 32-bit identification number computed when the database is created. RMAN displays the DBID upon connection to the target database. You can obtain the DBID by querying the V$DATABASE view or the RC_DATABASE and RC_DATABASE_INCARNATION recovery catalog views.
-in	--dbName	Defines the database name to be updated. Use the dbcli list-databases command to get the database name.
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	Defines the database ID to be updated. Use the dbcli list-databases command to get the database ID.
-j	--json	(Optional) Displays JSON output.
-no-ab	--noautobackup	(Optional) Disables automatic backups for the specified database. Note that, once disabled, automatic backup cannot be re-enabled using the CLI. To re-enable automatic backup, use the Console.

Example

The following command associates a backup configuration file with a database:

dbcli update-database -bi 78a2a5f0-72b1-448f-bd86-cf41b30b64ee -i 71ec8335-113a-46e3-b81f-235f4d1b6fde

Output:

{
  "jobId" : "2b104028-a0a4-4855-b32a-b97a37f5f9c5",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : 1467775842977,
  "description" : "update database id:71ec8335-113a-46e3-b81f-235f4d1b6fde",
  "updatedTime" : 1467775842978
}

Dbhome Commands

The following commands are available to manage database homes:

• dbcli create-dbhome
• dbcli describe-dbhome
• dbcli delete-dbhome
• dbcli list-dbhomes
• dbcli update-dbhome

dbcli create-dbhome

Use the dbcli create-dbhome command to create an Oracle Database Home.

Syntax

dbcli create-dbhome -v <version> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-v	--version	Defines the Database Home version.

Example

The following command creates an Oracle Database Home version 12.1.0.2:

dbcli create-dbhome -v 12.1.0.2

dbcli describe-dbhome

Use the dbcli describe-dbhome command to display Oracle Database Home details.

Syntax

dbcli describe-dbhome -i <db_home_id> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbhomeid	Identifies the database home ID. Use the dbcli list-dbhomes command to get the ID.
-j	--json	(Optional) Displays JSON output.

Example

The following output is an example of using the display Oracle Database Home details command.

dbcli describe-dbhome -i 52850389-228d-4397-bbe6-102fda65922b

Output:

DB Home details
----------------------------------------------------------------
                     ID: 52850389-228d-4397-bbe6-102fda65922b
                   Name: OraDB12102_home1
                Version: 12.1.0.2
          Home Location: /u01/app/oracle/product/12.1.0.2/dbhome_1
                Created: June 29, 2016 4:36:31 AM UTC

dbcli delete-dbhome

Use the dbcli delete-dbhome command to delete a database home from the DB system.

Syntax

dbcli delete-dbhome -i <db_home_id> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbhomeid	Identifies the database home ID to be deleted. Use the dbcli list-dbhomes command to get the ID.
-j	--json	(Optional) Displays JSON output.

dbcli list-dbhomes

Use the dbcli list-dbhomes command to display a list of Oracle Home directories.

Syntax

dbcli list-dbhomes [-h] [-j]

Parameter

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays a list of Oracle Home directories.

dbcli  list-dbhomes

Output:

ID                                   Name               DB Version Home Location
------------------------------------ -----------------  ---------- ------------------------------------------
b727bf80-c99e-4846-ac1f-28a81a725df6 OraDB12102_home1	 12.1.0.2  /u01/app/orauser/product/12.1.0.2/dbhome_1 

dbcli update-dbhome

Note:

Your DB system might not include this newer command. If you have trouble running the command, use the CLI Update command to update the database CLI and then retry the command.

Use the dbcli update-dbhome command to apply the DBBP bundle patch to a database home. For more information about applying patches, see Update a DB System.

Syntax

dbcli update-dbhome 
  -i <db_home_id> 
  -n <node> 
  [--local] 
  [--precheck] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbhomeid	The ID of the database home. Use the dbcli list-dbhomes command to get the ID.
-j	--json	(Optional) Displays JSON output.
-n	--node	(Optional) Node number to be updated. Use the dbcli list-nodes command to get the node number.
-l	--local	(Optional) Performs the operation on the local node of a multi-node high availability (HA) system. This parameter is not needed to perform the operation on a single-node system.
-p	--precheck	(Optional) Runs precheck operations to check prerequisites.

Example

The following commands update the database home and show the output from the update job:

dbcli update-dbhome -i e1877dac-a69a-40a1-b65a-d5e190e671e6

Output:

{
  "jobId" : "493e703b-46ef-4a3f-909d-bbd123469bea",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "January 19, 2017 10:03:21 AM PST",
  "resourceList" : [ ],
  "description" : "DB Home Patching: Home Id is e1877dac-a69a-40a1-b65a-d5e190e671e6",
  "updatedTime" : "January 19, 2017 10:03:21 AM PST"
}

dbcli describe-job -i 493e703b-46ef-4a3f-909d-bbd123469bea

Output:

Job details
----------------------------------------------------------------
                     ID:  493e703b-46ef-4a3f-909d-bbd123469bea
            Description:  DB Home Patching: Home Id is e1877dac-a69a-40a1-b65a-d5e190e671e6
                 Status:  Running
                Created:  January 19, 2017 10:03:21 AM PST
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Create Patching Repository Directories   January 19, 2017 10:03:21 AM PST    January 19, 2017 10:03:21 AM PST    Success
Download latest patch metadata           January 19, 2017 10:03:21 AM PST    January 19, 2017 10:03:21 AM PST    Success
Update System version                    January 19, 2017 10:03:21 AM PST    January 19, 2017 10:03:21 AM PST    Success
Update Patching Repository               January 19, 2017 10:03:21 AM PST    January 19, 2017 10:03:31 AM PST    Success
Opatch updation                          January 19, 2017 10:03:31 AM PST    January 19, 2017 10:03:31 AM PST    Success
Patch conflict check                     January 19, 2017 10:03:31 AM PST    January 19, 2017 10:03:31 AM PST    Running   

Dbstorage Commands

The following commands are available to manage database storage:

• dbcli list-dbstorages
• dbcli describe-dbstorage

dbcli list-dbstorages

Use the dbcli list-dbstorages command to list the database storage in the DB system.

Syntax

dbcli list-dbstorages [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays details about database storage:

dbcli list-dbstorages

Output:

ID                                       Type   DBUnique Name        Status
---------------------------------------- ------ -------------------- ----------
afb4a1ce-d54d-4993-a149-0f28c9fb33a4     Acfs   db1_2e56b3a9b815     Configured
d81e8013-4551-4d10-880b-d1a796bca1bc     Acfs   db11xp               Configured

dbcli describe-dbstorage

Use the dbcli describe-dbstorage command to show detailed information about a specific database storage resource.

Syntax

dbcli describe-dbstorage -i <db_storage_id> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--id	Defines the database storage ID. Use the dbcli list-dbstorages command to get the database storage ID.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays the database storage details for 105a2db2-625a-45ba-8bdd-ee46da0fd83a:

dbcli describe-dbstorage -i 105a2db2-625a-45ba-8bdd-ee46da0fd83a

Output:

DBStorage details
----------------------------------------------------------------

                     ID: 105a2db2-625a-45ba-8bdd-ee46da0fd83a
                DB Name: db1
          DBUnique Name: db1
         DB Resource ID: 439e7bd7-f717-447a-8046-08b5f6493df0
           Storage Type:
          DATA Location: /u02/app/oracle/oradata/db1
          RECO Location: /u03/app/oracle/fast_recovery_area/
          REDO Location: /u03/app/oracle/redo/
                  State: ResourceState(status=Configured)
                Created: July 3, 2016 4:19:21 AM UTC
            UpdatedTime: July 3, 2016 4:41:29 AM UTC

Dgconfig Commands

dbcli list-dgconfigs

Use the dbcli list-dgconfigs command to list DG configurations.

Syntax

dbcli list-dgconfigs [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Job Commands

The following commands are available to manage jobs:

• dbcli describe-job
• dbcli list-jobs

dbcli describe-job

Use the dbcli describe-job command to display details about a specific job.

Syntax

dbcli describe-job -i <job_id> [-h] [-j] 

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--jobid	Identifies the job. Use the dbcli list-jobs command to get the jobid.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays details about the specified job ID:

dbcli describe-job -i 74731897-fb6b-4379-9a37-246912025c17

Output:

Job details
----------------------------------------------------------------
                     ID:  74731897-fb6b-4379-9a37-246912025c17
            Description:  Backup service creation with db name: dbtst
                 Status:  Success
                Created:  November 18, 2016 8:33:04 PM UTC
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Backup Validations                       November 18, 2016 8:33:04 PM UTC    November 18, 2016 8:33:13 PM UTC    Success
validate recovery window                 November 18, 2016 8:33:13 PM UTC    November 18, 2016 8:33:17 PM UTC    Success
Db cross check                           November 18, 2016 8:33:17 PM UTC    November 18, 2016 8:33:23 PM UTC    Success
Database Backup                          November 18, 2016 8:33:23 PM UTC    November 18, 2016 8:34:22 PM UTC    Success
Backup metadata                          November 18, 2016 8:34:22 PM UTC    November 18, 2016 8:34:22 PM UTC    Success

dbcli list-jobs

Use the dbcli list-jobs command to display a list of jobs, including the job IDs, status, and the job

created date and time stamp.

Syntax

dbcli list-jobs [-h] [-j] 

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays a list of jobs:

dbcli list-jobs

Output:

ID                                       Description                                                                 Created                             Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
0a362dac-0339-41b5-9c9c-4d229e363eaa     Database service creation with db name: db11                                November 10, 2016 11:37:54 AM UTC   Success
9157cc78-b487-4ee9-9f46-0159f10236e4     Database service creation with db name: jhfpdb                              November 17, 2016 7:19:59 PM UTC    Success
013c408d-37ca-4f58-a053-02d4efdc42d0     create backup config:myBackupConfig                                         November 18, 2016 8:28:14 PM UTC    Success
921a54e3-c359-4aea-9efc-6ae7346cb0c2     update database id:80ad855a-5145-4f8f-a08f-406c5e4684ff                     November 18, 2016 8:32:16 PM UTC    Success
74731897-fb6b-4379-9a37-246912025c17     Backup service creation with db name: dbtst                                 November 18, 2016 8:33:04 PM UTC    Success
40a227b1-8c47-46b9-a116-48cc1476fc12     Creating a report for database 80ad855a-5145-4f8f-a08f-406c5e4684ff         November 18, 2016 8:41:39 PM UTC    Success

Latestpatch Command

dbcli describe-latestpatch

Note:

• Your DB system might not include this newer command. If you have trouble running the command, use the CLI Update command to update the database CLI and then retry the command.
• The dbcli describe-latestpatch command is not available on 2-node RAC DB systems. Patching 2-node systems from Object Storage is not supported.

Use the dbcli describe-latestpatch command show the latest patches applicable to the DB system and available in Oracle Cloud Infrastructure Object Storage.

This command requires a valid Object Storage credentials configuration. If the configuration is missing or invalid, the command fails with the error: Failed to connect to the object store. Please provide valid details.

For more information about updating the CLI, creating the credentials configuration, and applying patches, see Update a DB System.

Syntax

dbcli describe-latestpatch [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays patches available in the object store:

dbcli describe-latestpatch

Output:

componentType   availableVersion
--------------- --------------------
gi              12.1.0.2.161018
db              11.2.0.4.161018
db              12.1.0.2.161018
oak             12.1.2.10.0 

Logcleanjob Commands

The following commands are available to manage log cleaning jobs: 

• dbcli create-logCleanJob
• dbcli describe-logCleanJob
• dbcli list-logCleanJobs

dbcli create-logCleanJob

Use the dbcli create-logCleanJob command to create a log cleaning job.

Syntax

dbcli create-logCleanJob 
  [-c {gi|database|dcs}] 
  [-o <number>] 
  [u {Day|Hour|Minute}] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--components	(Optional) Components. Possible values are gi, database, and dcs. Separate multiple values by commas.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-o	--olderThan	(Optional) Quantity portion of time interval. Default: 30. Cleans logs older than the specified time interval (-o and -u).
-u	--unit	(Optional) Unit portion of time interval. Possible values: Day, Hour, or Minute. Default: Day. Cleans logs older than the specified time interval (-o and -u).

dbcli describe-logCleanJob

Use the dbcli describe-logCleanJob command to display the summary for a log cleaning job.

Syntax

dbcli describe-logCleanJob 
  -i <job_id> 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--jobid	ID of log cleaning job for which to display the summary.
-j	--json	(Optional) Displays JSON output.

dbcli list-logCleanJobs

Use the dbcli list-logCleanJobs command to list log cleaning jobs.

Syntax

dbcli list-logCleanJobs [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Netsecurity Commands

The following commands are available to manage network encryption on the DB system:

• dbcli describe-netsecurity
• dbcli update-netsecurity

dbcli describe-netsecurity

Use the dbcli describe-netsecurity command to display the current network encryption setting for a database home.

Syntax

dbcli describe-netsecurity -H <db_home_id> [-h] [-j]

Parameters

Parameter	Full Name	Description
-H	--dbHomeId	Defines the database home ID. Use the dbcli list-dbhomes command to get the dbhomeid.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays the encryption setting for specified database home:

dbcli describe-netsecurity -H 16c96a9c-f579-4a4c-a645-8d4d22d6889d

Output:

NetSecurity Rules
----------------------------------------------------------------
         DatabaseHomeID: 16c96a9c-f579-4a4c-a645-8d4d22d6889d

                   Role: Server
   EncryptionAlgorithms: AES256 AES192 AES128
    IntegrityAlgorithms: SHA1
         ConnectionType: Required

                   Role: Client
   EncryptionAlgorithms: AES256 AES192 AES128
    IntegrityAlgorithms: SHA1
         ConnectionType: Required

dbcli update-netsecurity

Use the dbcli update-netsecurity command to update the Oracle Net security configuration on the DB system.

Syntax

dbcli update-netsecurity 
  {-c|-s} 
  -t {REJECTED|ACCEPTED|REQUESTED|REQUIRED} 
  -H <db_home_id> 
  -e {AES256|AES192|AES128} 
  -i {SHA1|SHA512|SHA384|SHA256} 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-c	--client	Indicates that the specified data encryption or data integrity configuration is for the client. (--client and --server are mutually exclusive.)
-e	-- encryptionAlgorithms	Defines the algorithm to be used for encryption. Specify either AES256, AES192, or AES128.
-H	--dbHomeId	Defines the database home ID. Use the dbcli list-dbhomes command to get the dbHomeId.
-h	--help	(Optional) Displays help for using the command.
-i	--integrityAlgorithms	Defines the algorithm to be used for integrity. Specify either SHA1, SHA512, SHA384, or SHA256. For Oracle Database 11g, the only accepted value is SHA1.
-j	--json	(Optional) Displays JSON output.
-s	--server	Indicates that the specified data encryption or data integrity configuration is for the server. (--client and --server are mutually exclusive.)
-t	--connectionType	Specifies how Oracle Net Services data encryption or data integrity is negotiated with clients. The following values are listed in the order of increasing security: REJECTED - Do not enable data encryption or data integrity, even if required by the client. ACCEPTED - Enable data encryption or data integrity if required or requested by the client. REQUESTED - Enable data encryption or data integrity if the client permits it. REQUIRED - Enable data encryption or data integrity or preclude the connection.

Example

The following command updates the connection type to ACCEPTED:

dbcli update-netsecurity -H a2ffbb07-c9c0-4467-a458-bce4d3b76cd5 -t ACCEPTED

Objectstoreswift Commands

You can back up a database to an existing bucket in the Oracle Cloud Infrastructure Object Storage service by using the dbcli create-backup command, but first you'll need to:

1. Create an object store on the DB system, which contains the endpoint and credentials to access Object Storage, by using the dbcli create-objectstoreswift command.
2. Create a backup configuration that refers to the object store ID and the bucket name by using the dbcli create-backupconfig command.
3. Associate the backup configuration with the database by using the dbcli update-database command.

The following commands are available to manage object stores.

• dbcli create-objectstoreswift
• dbcli describe-objectstoreswift
• dbcli list-objectstoreswifts

dbcli create-objectstoreswift

Use the dbcli create-objectstoreswift command to create an object store.

Syntax

dbcli create-objectstoreswift 
  -n <object_store_name> 
  -t <object_storage_namespace> 
  -u <user_name> 
  -e https://swiftobjectstorage.<region_name>.oraclecloud.com/v1 
  -p <password>
  [-h] [-j]

where <object_storage_namespace> is your tenancy's Object Storage namespace.

Parameters

Parameter	Full Name	Description
-e	--endpointurl	The following endpoint URL. https://swiftobjectstorage.<region_name>.oraclecloud.com/v1
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-n	--name	The name for the object store to be created.
-p	--swiftpassword	The auth token that you generated by using the Console or IAM API. For information about generating an auth token for use with Swift, see Managing User Credentials. This is not the password for the Oracle Cloud Infrastructure user. Specify -p (with no password) to be prompted. Specify -hp "<password> " in quotes to provide the password (auth token) in the command.
-t	--tenantname	The Object Storage namespace of your tenancy.
-u	--username	The user name for the Oracle Cloud Infrastructure user account, for example: -u [e-mail] This is the user name you use to sign in to the Console. The user name must have tenancy-level access to the Object Storage. An easy way to do this is to add the user name to the Administrators group. However, that allows access to all of the cloud services. Instead, an administrator can create a policy that allows tenancy-level access to just Object Storage. The following is an example of such a policy. Allow group DBAdmins to manage buckets in tenancy Allow group DBAdmins to manage objects in tenancy For more information about adding a user to a group, see Managing Groups. For more information about policies, see Getting Started with Policies.

Example

The following command creates an object store and prompts for the Swift password:

dbcli create-objectstoreswift -n r2swift -t MyObjectStorageNamespace -u [e-mail] -e https://swiftobjectstorage.<region_name>.oraclecloud.com/v1 -p

Output:

Password for Swift:
{
  "jobId" : "c565bb71-f67b-4fab-9d6f-a34eae36feb7",
  "status" : "Created",
  "message" : "Create object store swift",
  "reports" : [ ],
  "createTimestamp" : "January 19, 2017 11:11:33 AM PST",
  "resourceList" : [ {
    "resourceId" : "8a0fe039-f5d4-426a-8707-256c612b3a30",
    "resourceType" : "ObjectStoreSwift",
    "jobId" : "c565bb71-f67b-4fab-9d6f-a34eae36feb7",
    "updatedTime" : "January 19, 2017 11:11:33 AM PST"
  } ],
  "description" : "create object store:biyanr2swift",
  "updatedTime" : "January 19, 2017 11:11:33 AM PST"
}

dbcli describe-objectstoreswift

Use the dbcli describe-objectstoreswift command to display details about an object store.

Syntax

dbcli describe-objectstoreswift 
  -i <object_store_swift_id> 
  -in <object_store_swift_name> 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--objectstoreswiftid	The object store ID. Use the dbcli list-objectstoreswifts command to get the ID.
-in	--objectstoreswiftName	The object store name. Use the dbcli list-objectstoreswifts command to get the name.
-j	--json	(Optional) Displays JSON output.

Example

The following command displays details about an object store:

dbcli describe-objectstoreswift -i 910e9e2d-25b4-49b4-b88e-ff0332f7df87

Output:

Object Store details
----------------------------------------------------------------
                     ID: 910e9e2d-25b4-49b4-b88e-ff0332f7df87
                   Name: objstrswift15
               UserName: [e-mail]
             TenantName: CompanyABC
           endpoint URL: https://swiftobjectstorage.<region_name>.oraclecloud.com/v1
            CreatedTime: November 16, 2016 11:25:34 PM UTC
            UpdatedTime: November 16, 2016 11:25:34 PM UTC

dbcli list-objectstoreswifts

Use the dbcli list-objectstoreswifts command to list the object stores on a DB system.

Syntax

dbcli list-objectstoreswifts [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command lists the object stores on the DB system:

dbcli list-objectstoreswifts

Output:

ID                                       Name                 UserName              TenantName     Url                                                         createTime
---------------------------------------- -------------------- --------------------  -------------- ------ ---------------------------------------------------- -----------------------------------
2915bc6a-6866-436a-a38c-32302c7c4d8b     swiftobjstr1         [e-mail]    LargeComputers https://swiftobjectstorage.<region_name>.oraclecloud.com/v1 November 10, 2016 8:42:18 PM UTC
910e9e2d-25b4-49b4-b88e-ff0332f7df87     objstrswift15        [e-mail]    LargeComputers https://swiftobjectstorage.<region_name>.oraclecloud.com/v1 November 16, 2016 11:25:34 PM UTC

Pendingjob Command

dbcli list-pendingjobs

Use the dbcli list-pendingjobs command to display a list of pending jobs.

Syntax

dbcli list-pendingjobs [-h] [-j] 

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Rmanbackupreport Commands

The following commands are available to manage RMAN backup reports: 

• dbcli create-rmanbackupreport
• dbcli delete-rmanbackupreport
• dbcli describe-rmanbackupreport
• dbcli list-rmanbackupreports

dbcli create-rmanbackupreport

Use the dbcli create-rmanbackupreport command to create an RMAN backup report.

Syntax

dbcli create-rmanbackupreport 
  -w {summary|detailed} 
  -rn <name> 
  [-i <db_id>] 
  [-in <db_name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	(Optional) Database resource ID.
-in	--dbname	(Optional) Database resource name.
-j	--json	(Optional) Displays JSON output.
-rn	--rptname	RMAN backup report name. Maximum number of characters: 30. Wrap name in single quotes when special characters are used.
-w	--reporttype	RMAN backup report type. Possible values: summary or detailed.

dbcli delete-rmanbackupreport

Use the dbcli delete-rmanbackupreport command to delete an RMAN backup report.

Syntax

dbcli delete-rmanbackupreport 
  [-d <db_id>] 
  [-dn <db_name>] 
  [-n <number>] 
  [-i <rpt_id>] 
  [-in <rpt_name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-d	--dbid	(Optional) Database resource ID.
-dn	--dbname	(Optional) Database resource name.
-h	--help	(Optional) Displays help for using the command.
-i	--reportid	(Optional) RMAN backup report ID
-in	--rptname	(Optional) RMAN backup report name
-j	--json	(Optional) Displays JSON output.
-n	--numofday	(Optional) Number of days since created (provided with Database ID/Database Name)

dbcli describe-rmanbackupreport

Use the dbcli describe-rmanbackupreport command to

Syntax

dbcli describe-rmanbackupreport 
  [-i <rpt_id>] 
  [-in <rpt_name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--id	(Optional) RMAN backup report ID
-in	--name	(Optional) RMAN backup report name
-j	--json	(Optional) Displays JSON output.

dbcli list-rmanbackupreports

Use the dbcli list-rmanbackupreports command to

Syntax

dbcli list-rmanbackupreports 
  [-i <db_id>] 
  [-in <db_name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbid	(Optional) Database resource ID.
-in	--dbName	(Optional) Database resource name.
-j	--json	(Optional) Displays JSON output.

Schedule Commands

The following commands are available to manage schedules: 

• dbcli describe-schedule
• dbcli list-schedules
• dbcli update-schedule

dbcli describe-schedule

Use the dbcli describe-schedule command to describe a schedule.

Syntax

dbcli describe-schedule -i <id> [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--scheduleid	Schedule ID.
-j	--json	(Optional) Displays JSON output.

dbcli list-schedules

Use the dbcli list-schedules command to list schedules.

Syntax

dbcli list-schedules [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

dbcli update-schedule

Use the dbcli update-schedule command to update a schedule.

Syntax

dbcli update-schedule 
  -i <id> 
  [-x <expression>] 
  [-t <description>] 
  [-d] 
  [-e] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-d	--disable	(Optional) Disables the schedule.
-e	--enable	(Optional) Enables the schedule.
-h	--help	(Optional) Displays help for using the command.
-i	--scheduleid	Schedule ID.
-j	--json	(Optional) Displays JSON output.
-t	--description	(Optional) Description
-x	--cronExpression	(Optional) Cron expression. Use cronmaker.com to generate a valid cron expression.

Scheduledexecution Command

dbcli list-scheduledExecutions

Use the dbcli list-scheduledExecutions command to list scheduled executions.

Syntax

dbcli list-scheduledExecutions 
  [-e <execution_id>] 
  [-i <schedule_id>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-e	--executionid	(Optional) Execution ID.
-h	--help	(Optional) Displays help for using the command.
-i	--scheduleid	(Optional) Schedule ID.
-j	--json	(Optional) Displays JSON output.

Server Command

dbcli update-server

Note:

Your DB system might not include this newer command. If you have trouble running the command, use the CLI Update command to update the database CLI and then retry the command.

Use the dbcli update-server command to apply patches to the server components in the DB system. For more information about applying patches, see Update a DB System.

Syntax

dbcli update-server 
  [-n <number>] 
  [--local] 
  [--precheck] 
  [-v]
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.
-l	--local	(Optional) Performs the operation on the local node of a multi-node high availability (HA) system. This parameter is not needed to perform the operation on a single-node system.
-n	--node	(Optional) Node number to be updated. Use the dbcli list-nodes command to get the node number.
-p	--precheck	(Optional) Runs precheck operations to check prerequisites.
-v	--version	(Optional) Version to be updated.

Examples

The following commands update the server and show the output from the update job:

dbcli update-server

Output:

{
  "jobId" : "9a02d111-e902-4e94-bc6b-9b820ddf6ed8",
  "status" : "Created",
  "reports" : [ ],
  "createTimestamp" : "January 19, 2017 09:37:11 AM PST",
  "resourceList" : [ ],
  "description" : "Server Patching",
  "updatedTime" : "January 19, 2017 09:37:11 AM PST"
}

dbcli describe-job -i 9a02d111-e902-4e94-bc6b-9b820ddf6ed8

Output:

Job details
----------------------------------------------------------------
                     ID:  9a02d111-e902-4e94-bc6b-9b820ddf6ed8
            Description:  Server Patching
                 Status:  Running
                Created:  January 19, 2017 9:37:11 AM PST
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
Create Patching Repository Directories   January 19, 2017 9:37:11 AM PST     January 19, 2017 9:37:11 AM PST     Success
Download latest patch metadata           January 19, 2017 9:37:11 AM PST     January 19, 2017 9:37:11 AM PST     Success
Update System version                    January 19, 2017 9:37:11 AM PST     January 19, 2017 9:37:11 AM PST     Success
Update Patching Repository               January 19, 2017 9:37:11 AM PST     January 19, 2017 9:38:35 AM PST     Success
oda-hw-mgmt upgrade                      January 19, 2017 9:38:35 AM PST     January 19, 2017 9:38:58 AM PST     Success
Opatch updation                          January 19, 2017 9:38:58 AM PST     January 19, 2017 9:38:58 AM PST     Success
Patch conflict check                     January 19, 2017 9:38:58 AM PST     January 19, 2017 9:42:06 AM PST     Success
apply clusterware patch                  January 19, 2017 9:42:06 AM PST     January 19, 2017 10:02:32 AM PST    Success
Updating GiHome version                  January 19, 2017 10:02:32 AM PST    January 19, 2017 10:02:38 AM PST    Success    

The following command updates node 0 of the server only, with precheck: 

dbcli update-server -n 0 -p

Output:

{
  "jobId" : "3e2a1e3c-83d3-4101-86b8-4d525f3f8c18",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "April 26, 2019 06:07:27 AM UTC",
  "resourceList" : [ ],
  "description" : "Server Patching Prechecks",
  "updatedTime" : "April 26, 2019 06:07:27 AM UTC"
}

System Command

dbcli describe-system

Use the dbcli describe-system command to display details about the system. On a 2-node RAC DB system, the command provides information about the local node.

Syntax

dbcli describe-system [-b] [-d] [-h] [-j]

Parameters

Parameter	Full Name	Description
-b	--bom	(Optional) Displays BOM information.
-d	--details	(Optional) Displays additional information about the DB system, including dcs CLI and agent version information.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

TDE Commands

The following commands are available to manage TDE-related items (backup reports, keys, and wallets): 

• dbcli list-tdebackupreports
• dbcli update-tdekey
• dbcli recover-tdewallet

dbcli list-tdebackupreports

Use the dbcli list-tdebackupreports command to list backup reports for TDE wallets.

Syntax

dbcli  list-tdebackupreports 
  [-i <db_id>] 
  [-in <db_name>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-i	--dbResid	(Optional) Displays the TDE Wallet backup reports for the specified database resource ID. Use the dbcli list-databases command to get the database resource ID.
-in	--dbResname	(Optional) Displays the TDE Wallet backup reports for the specified database resource name. Use the dbcli list-databases command to get the database resource name.
-j	--json	(Optional) Displays JSON output.

Example

The following command lists the backup reports for TDE wallets:

dbcli list-tdebackupreports

Output:

DbResID 			            	OraDbId			BackupLocation
--------------------------------------- --------------------	----------------------------------------
538ca5b1-654d-4418-8ce1-f49b6c987a60	1257156075 		https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/dbaasimage/backuptest/host724007/tdewallet/Testdb5/1257156075/2017-08-17/TDEWALLET_BMC60_2017-08-17_10-58-17.0990.tar.gz
538ca5b1-9fb2-4245-b157-6e25d7c988c5 	704287483 		https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/dbaasimage/backuptest/host724007/tdewallet/Testdb1/704287483/2017-08-17/TDEWALLET_AUTO_2017-08-17_11-03-25.0953.tar.gz
538ca5b1-9fb2-4245-b157-6e25d7c988c5 	704287483 		https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/dbaasimage/backuptest/host724007/tdewallet/Testdb1/704287483/2017-08-17/TDEWALLET_BMC62_2017-08-17_11-04-41.0264.tar.gz
19714ffa-de1b-4433-9188-c0592887e609 	1157116855 		https://swiftobjectstorage.us-phoenix-1.oraclecloud.com/v1/dbaasimage/backuptest/host724007/tdewallet/Testdb7/1157116855/2017-08-17/TDEWALLET_AUTO_2017-08-17_11-57-47.0605.tar.gz

dbcli update-tdekey

Use the dbcli update-tdekey command to update the TDE encryption key inside the TDE wallet. You can update the encryption key for Pluggable Databases (if -pdbNames are specified), and/or the Container Database (if -rootDatabase is specified).

Syntax

dbcli update-tdekey 
  -i <db_id> 
  -p [-all] 
  -n <pdbname1,pdbname2> 
  [-r|-no-r] 
  -t <tag_name> 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-all	--allPdbNames	(Optional) Flag to rotate (update) all PDB names. To update all instead of specified PDB names, use this parameter instead of -n. Default: false.
-i	--databaseId	Defines the database ID for which to update the key.
-p	--password	Defines the TDE Admin wallet password. Specify -p with no password. You will be prompted for the password. If you must provide the password in the command, for example in a script, use -hp <password> instead of -p.
-n	--pdbNames	Defines the PDB names to be rotated (updated).
-r -no-r	--rootDatabase --no-rootDatabase	Indicates whether to rotate the key for the root database if it is a container database.
-t	-tagName	Defines the TagName used to backup the wallet. The default is OdaRotateKey.
-h	--help	(Optional) Displays help for using the command.
-j	--json	(Optional) Displays JSON output.

Example

The following command updates the key for pdb1 and pdb2 only:

dbcli update-tdekey -dbid ee3eaab6-a45b-4e61-a218-c4ba665503d9 -p -n pdb1,pdb2

Output:

TDE Admin wallet password:
{
  "jobId" : "08e5edb1-42e1-4d16-a47f-783c0afa4778",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : 1467876407035,
  "description" : "TDE update",
  "updatedTime" : 1467876407035
}

The following command updates pdb1, pdb2, and the container database:

dbcli update-tdekey -dbid ee3eaab6-a45b-4e61-a218-c4ba665503d9 -p -n pdb1,pdb2 -r

Output:

TDE Admin wallet password:
{
  "jobId" : "c72385f0-cd81-42df-a8e8-3a1e7cab1278",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : 1467876433783,
  "description" : "TDE update",
  "updatedTime" : 1467876433783
}

dbcli recover-tdewallet

Use the dbcli recover-tdewallet command to recover a TDE wallet.

Syntax

dbcli recover-tdewallet 
  -in <db_name> 
  -tp <password> 
  [-l <location>] 
  [-h] [-j]

Parameters

Parameter	Full Name	Description
-h	--help	(Optional) Displays help for using the command.
-in	--dbName	Database name.
-j	--json	(Optional) Displays JSON output.
-l	--tdeWalletBackuplocation	(Optional) TDE wallet backup location. TDE wallet should b ebacked up in tar.gz format.
-tp	--tdeWalletPassword	Defines the TDE Admin wallet password.

---

Title and Copyright Information

Oracle Database CLI Reference

Copyright © 2022, 2024, Oracle and/or its affiliates. 

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.