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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:
Oracle Cloud Infrastructure 2018 Certified Architect Associate.
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.
Oracle Database Cloud Administrator Certified Professional.
Oracle Database Cloud Service Operations Certified Associate.

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
##################################################

1 comment:

Gopi Krishna Anabham said...

Hi,

I got some errors while executing oracle dbaas backup command,

can you please give me suggestions for below error

/var/opt/oracle/bkup_api/bkup_api bkup_start
Traceback (most recent call last):
File "/var/opt/oracle/bkup_api/bkup_api", line 110, in
from lib.exacloud import ExaCloud, ExaCloudException
File "/var/opt/oracle/bkup_api/lib/exacloud.py", line 62, in
from apiv1 import BkupAPIV1
File "/var/opt/oracle/bkup_api/lib/apiv1.py", line 88, in
from misc import Creg, shell, Prt, is_running_pid, StreamReader, EndofStream
File "/var/opt/oracle/bkup_api/lib/misc.py", line 68, in
from registry import BackupApiDB
File "/var/opt/oracle/bkup_api/lib/registry.py", line 1, in
import sqlite3
File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in
from dbapi2 import *
File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 27, in
from _sqlite3 import *
ImportError: No module named _sqlite3




Thanks
Gopi