Tuesday, 10 July 2018

Updating Cloud backup tool by Using the dbpatchm Subcommand:




Check latest available update:
[root@tahalufdbcs opc]# dbaascli dbpatchm --run -list_tools
DBAAS CLI version 1.0.0
Executing command dbpatchm --run -list_tools -cli
/var/opt/oracle/patch/dbpatchm -list_tools -cli
Use of uninitialized value $cplat in pattern match (m//) at /var/opt/oracle/patch/dbpatchm line 6106.
Use of uninitialized value $service in pattern match (m//) at /var/opt/oracle/patch/dbpatchm line 3993.
Starting DBPATCHM
Logfile is /var/opt/oracle/log/dbpatchm/dbpatchm_2018-07-10_08:28:45.log
Config file is /var/opt/oracle/patch/dbpatchm.cfg

INFO: cdb is set to : yes
INFO: dbversion detected : 12102
INFO: patching type : psu


Patchid : 18.1.2.1.0_180228.1052

Patchid : 18.1.2.1.0_180301.0107

Patchid : 18.1.2.1.0_180309.0517

Patchid : 18.1.4.1.0_180309.0546

Patchid : 18.1.4.1.0_180312.1800

Patchid : 18.1.2.1.0_180327.0219

Patchid : 18.1.4.1.0_180406.2023

Patchid : 18.1.2.1.0_180407.0948

Patchid : 18.1.4.1.0DBCS_180412.0105

Patchid : 18.1.2.1.0_180418.0606

Patchid : 18.1.4.1.0DBCS_180418.0614

Patchid : 18.1.4.1.0_180420.0000

Patchid : 18.1.4.1.0_180425.0000

Patchid : 18.2.3.1.0_180505.1604

Patchid : 18.2.3.1.0_180516.0000

Patchid : 18.1.4.1.0_180509.0000

Patchid : 18.1.2.1.0_180511.0801

Patchid : 18.2.3.1.0_180523.0000

Patchid : 18.1.4.1.0_180523.0000

Patchid : 18.1.4.1.0_180525.0000

Patchid : 18.1.4.1.0_180530.0000

Patchid : 18.2.3.1.0_180530.0000

Patchid : 18.1.4.1.0_180606.0000

Patchid : 18.2.3.1.0_180606.0000

Patchid : 18.1.4.1.0_180613.0000

Patchid : 18.2.3.1.0_180613.0000

Patchid : 18.1.2.1.0_180613.0000

Patchid : 18.2.3.1.0_180620.0000

Patchid : 18.1.4.1.0_180620.0000

Patchid : 18.1.4.1.0_180627.0000

Patchid : 18.2.3.1.0_180627.0000

Patchid : 18.1.4.1.0_180704.0000

Patchid : 18.2.3.1.0_180704.0000
dbpatchm Execution completed


Compare with current version:

[root@tahalufdbcs opc]# rpm -qa|grep -i dbaastools
dbaastools-1.0-1+18.1.2.1.0_180215.0915.x86_64


If update in higher version like my case, apply latest update:
[root@tahalufdbcs opc]# dbaascli dbpatchm --run -toolsinst -rpmversion=18.2.3.1.0_180704.0000
DBAAS CLI version 1.0.0
Executing command dbpatchm --run -toolsinst -rpmversion=18.2.3.1.0_180704.0000 -cli
/var/opt/oracle/patch/dbpatchm -toolsinst -rpmversion=18.2.3.1.0_180704.0000 -cli
Use of uninitialized value $cplat in pattern match (m//) at /var/opt/oracle/patch/dbpatchm line 6106.
Use of uninitialized value $service in pattern match (m//) at /var/opt/oracle/patch/dbpatchm line 3993.
Starting DBPATCHM
Logfile is /var/opt/oracle/log/dbpatchm/dbpatchm_2018-07-10_09:31:31.log

WARN : Parameter toolsinst passed via cmdline is not a valid parameter. Please check the usage.
Config file is /var/opt/oracle/patch/dbpatchm.cfg

INFO: cdb is set to : yes
INFO: dbversion detected : 12102
INFO: patching type : psu

INFO: existing dbaastools version - dbaastools-1.0-1+18.1.2.1.0_180215.0915.x86_64

INFO: updated dbaastools rpm to - dbaastools-1.0-1+18.2.3.1.0_180704.0000.x86_64
dbpatchm Execution completed


Reset the backup configuration:
[root@tahalufdbcs opc]# /var/opt/oracle/ocde/assistants/bkup/bkup
Starting BKUP
Logfile is /var/opt/oracle/log/bkup/bkup_2018-07-10_10:07:15.log
Config file is /var/opt/oracle/ocde/assistants/bkup/bkup.cfg
dbname: ORCL
Dataguard configuration
Enabled: 0
Mode: PRIMARY
Looking for previous configuration:
Directory : /home/oracle/bkup/ORCL
  -> dbcfg.spec
  -> oscfg.spec
  -> obkup
 -> Found: 3 files
 -> Moving previous configuration to /home/oracle/bkup/ORCL_20180710100726
DB edition: standard
OSS channels: 1
INFO: OSS connection using supplied creds passed.
INFO : Cfg files recovery window set to 30
No initial bkup of PFILE needed.
Configuring Backup to OSS
Preparing OPC library.
INFO : OPC opc install
Running OPC installer...
INFO : libopc found at /u01/app/oracle/product/12.1.0/dbhome_1/lib. Move to /tmp directory.
Installing OPC installer local copy.
Running OPC installer.....
using file : /var/opt/oracle/log/ORCL/bkup/temp.sh
Oracle Database Cloud Backup Module Install Tool, build 12.2.0.1.0DBBKPCSBP_2018-06-12
Oracle Database Cloud Backup Module credentials are valid.
Oracle Database Cloud Backup Module wallet created in directory /u01/app/oracle/admin/ORCL/opc_wallet.
Oracle Database Cloud Backup Module initialization file /u01/app/oracle/product/12.1.0/dbhome_1/dbs/opcORCL.ora created.
Skipping library download because option -libDir is not specified.
OPC installer completed successfully.
OSS specific RMAN config for libopc
Common RMAN Config
Instantiating obkup
Instantiating dbcfg.spec
Configuring backup of Config File
Updating Control File Record Keep Time
Enabling block change tracking
Updating RMAN defaults
Adding entry to crontab
INFO: Archivelog management enabled.
Adding entry to crontab
Accessing to your Database ID ..
The DBaaS instance database id is: 1484881322
#### Completed Execution.

No comments:

Post a Comment

Number of Visitors