Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Friday, December 1, 2017

Oracle Cloud 12c - How to manually backup the database using bkp_api



How to manually backup the database using bkp_api

as root :
Run /var/opt/oracle/bkup_api/bkup_api bkup_start

or
  • To create a long-term backup, enter the following bkup_api command:      /var/opt/oracle/bkup_api/bkup_api bkup_start -- keep

[root@erpdev1 etc]# /var/opt/oracle/bkup_api/bkup_api bkup_start
DBaaS Backup API V1.5 @2016 Multi-Oracle home
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> Action : bkup_start
-> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
UUID 7d06371a-d6b6-11e7-a905-c6b0ce5986ff for this backup
** process started with PID: 2314
** see log file for monitor progress
-------------------------------------
You have new mail in /var/spool/mail/root


Check the log:
[root@erpdev1 etc]# view /var/opt/oracle/bkup_api/log/bkup_api.log
Fri, 01 Dec 2017 16:41:32 DBaaS Backup API V1.5 @2016 Multi-Oracle home
Fri, 01 Dec 2017 16:41:32 DBaaS Backup API V1.5 @2015 Multi-Oracle home
Fri, 01 Dec 2017 16:41:32 -> Action : bkup_start
Fri, 01 Dec 2017 16:41:32 -> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
Fri, 01 Dec 2017 16:41:32 UUID 7d06371a-d6b6-11e7-a905-c6b0ce5986ff for this backup
Fri, 01 Dec 2017 16:41:36 API::2192:: Backup list synchronization in background.
Fri, 01 Dec 2017 16:41:44 API::2192:: Backup list synchronization completed.
Fri, 01 Dec 2017 16:41:44 ** process started with PID: 2314
Fri, 01 Dec 2017 16:41:44 ** see log file for monitor progress
Fri, 01 Dec 2017 16:41:44 -------------------------------------
Fri, 01 Dec 2017 16:41:44 7d06371a-d6b6-11e7-a905-c6b0ce5986ff -> Starting execution of backup log in background
Fri, 01 Dec 2017 16:41:44 7d06371a-d6b6-11e7-a905-c6b0ce5986ff STARTING BACKUP REQUEST
Fri, 01 Dec 2017 16:41:44 UUID 7d06371a-d6b6-11e7-a905-c6b0ce5986ff written with PID 2314
Fri, 01 Dec 2017 16:41:45 7d06371a-d6b6-11e7-a905-c6b0ce5986ff Checking if erpdev2 resource is available
Fri, 01 Dec 2017 16:41:45 7d06371a-d6b6-11e7-a905-c6b0ce5986ff has a lock erpdev2
Fri, 01 Dec 2017 16:41:45 7d06371a-d6b6-11e7-a905-c6b0ce5986ff The process is no longer running removing lock
Fri, 01 Dec 2017 16:41:45 7d06371a-d6b6-11e7-a905-c6b0ce5986ff registering request into the database
Fri, 01 Dec 2017 16:41:49 7d06371a-d6b6-11e7-a905-c6b0ce5986ff current backups 9
Fri, 01 Dec 2017 16:41:49 7d06371a-d6b6-11e7-a905-c6b0ce5986ff command /var/opt/oracle/ocde/assistants/bkup/obkup


Verify the status of the backup:
[root@erpdev1 etc]# /var/opt/oracle/bkup_api/bkup_api bkup_status
DBaaS Backup API V1.5 @2016 Multi-Oracle home
DBaaS Backup API V1.5 @2015 Multi-Oracle home
-> Action : bkup_status
-> logfile: /var/opt/oracle/bkup_api/log/bkup_api.log
 Warning: unable to get current configuration of: catalog
* Current backup settings:
* Last registered Bkup: 12-01 16:41 API::2314:: Starting dbaas backup process
* Bkup state: finished
**************************************************
* API History: API steps
  API:: NEW PROCESS 2314
  API:: Starting dbaas backup process
  API:: Your new dbaas backup tag is TAG20171201T164410
  API:: BKUP COMPLETE YOUR BKUP TAG TAG20171201T164410
*************************************************
* Backup steps
 -> API:: Oracle database state is up and running
 -> API:: DB instance: erpdev2
 -> API:: Determining if the filesystem is not full
 -> API:: ...... OK
 -> API:: Validating the backup repository ......
 -> API::      All backup pieces are ok
 -> API:: Performing backup to local storage (primary backup)
 -> API:: Executing rman instructions
 -> API:: ...... OK
 -> API:: Backup to local storage is completed
 -> API:: Clean MOTD.
 -> API:: Performing backup to cloud storage (secondary backup)
 -> API:: Executing rman instructions
 -> API:: ......OK
 -> API:: Backup to cloud storage is completed
 -> API:: Clean MOTD.
 -> API:: Starting backup of config files
 -> API:: Executing rman instructions
 -> API:: at time: 2017-12-01:16:45:17
 -> API:: Determining the oracle database id
 -> API::  DBID: 3253488032
 -> API:: Creating directories to store config files
 -> API:: Determining the oracle database id
 -> API::  DBID: 3253488032
 -> API:: Compressing config files into tar files
 -> API:: .... OK
 -> API:: Uploading config files to cloud storage
 -> API:: Completed at time: 2017-12-01:16:45:30
 -> API:: at time: 2017-12-01:16:45:30
 -> API:: Config files backup ended successfully
 -> API:: Clean MOTD.
 -> API:: All requested tasks are completed
*
* RETURN CODE:0
##################################################

No comments: