1.Recover database from console

2.Please select among below options

3.Please check the recovery progress now

4.Point in time recovery using PITR

[root@MYTST ORCL]#  dbaascli orec –args -list

[root@MYTST ORCL]#  dbaascli orec –args -pitr TAG20180409T051640

DBAAS CLI version 1.0.0
Executing command orec –args -pitr TAG20180409T051640
–args : -pitr TAG20180409T051640
OREC version: 16.0.0.0
Starting OREC
Logfile is /var/opt/oracle/log/ORCL/orec/orec_2018-04-09_12:39:36.log
Config file is /var/opt/oracle/orec/orec.cfg
DB name: ORCL
OREC:: RUNNING IN NON DATAGUARD ENVIRONMENT
OREC:: Catalog mode:  Disabled
OREC:: Checking prerequirements before recovery process.
OREC:: DB Status : OPEN
OREC:: Changing instance to MOUNT stage.
OREC:: Shutting down the database… Completed.
OREC:: (RMAN) Startup MOUNT… Completed.
OREC:: PITR is within current incarnation 3
INFO : DB instance is up and running after recovery procedure.

OREC:: PITR Completed.

5.Point in time recovery using SCN

# dbaascli orec –args -scn SCN

where SCN is the system change number (SCN) for the end point of the recovery.

The restore and recover process performs these steps:

  • Shuts down the database
  • Extracts and restores configuration files
  • Prepares for recovery
  • Performs the recovery
  • Restarts the database instance after recovery.

6.In data guard configuration,you need to do following

1.Start a root-user command shell:

2.$ sudo -s
#

3.Run the duplicate option of orec.

4.# dbaascli orec –args -duplicate

5.Exit the root-user command shell and disconnect from the compute node:

6.# exit
$ exit

7.Switching backup from the None destination

8.Configuring TDE wallet and backup configuration file

[opc@MyCLONE ~]$ sudo su –

[root@MyCLONE ~]# /var/opt/oracle/dbaascli/dbaascli tde config –ks_login auto

DBAAS CLI version 1.0.0
Executing command tde config –ks_login auto

[root@MyCLONE ~]# cd /var/opt/oracle/ocde/assistants/bkup/

[root@MyCLONE bkup]# ls bkup*.cfg

bkup.cfg

[root@MyCLONE bkup]# mv bkup.cfg bkup_bak.cfg

[root@MyCLONE bkup]# vi bkup.cfg

9.Changing parameter of backup configuration file

# The bkup.cfg file will hold all the config info for BKUP.This configuration for both cloud storage and local disk

bkup_cfg_files=yes
bkup_disk=yes
bkup_disk_recovery_window=7
bkup_oss=yes
bkup_oss_url=https://surcloudworld.au.storage.oraclecloud.com/v1/Storage-surcloudworld/MYCLONE
bkup_oss_user=rsurajit@rediffmail.com
bkup_oss_passwd=Test#123
bkup_oss_recovery_window=30

For the Cloud Storage Only destination, enter:

# The bkup.cfg file will hold all the config info for BKUP

bkup_cfg_files=yes
bkup_disk=no
bkup_oss=yes
bkup_oss_url=https://surcloudworld.au.storage.oraclecloud.com/v1/Storage-surcloudworld/MYCLONE
bkup_oss_user=rsurajit@rediffmail.com
bkup_oss_passwd=Test#123
bkup_oss_recovery_window=oss-days

10.Run the backup assistant with the bkup.cfg file

[root@MyCLONE bkup]# chown root bkup.cfg

[root@MyCLONE bkup]# chmod 0600 bkup.cfg

[root@MyCLONE bkup]# ./bkup -cfg bkup.cfg

using file : /var/opt/oracle/log/ORCL/bkup/temp.sh
Configuring Backup to disk
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: 1500760727

#### Completed Execution.

11.Details about parameters used for backup configuration

1.disk-days is the number of days for which backups and archived redo logs are maintained on local storage. The interval always ends with the current time and extends back in time for the specified number of days.

2.oss-url is the REST endpoint of the cloud storage container.

3.username is the username for accessing the cloud storage container.

4.password is the password for accessing the cloud storage container.

5.oss-days is the number of days for which backups and archived redo logs are maintained on cloud storage. The interval always ends with the current time and extends back in time for the specified number of days.

 12.Create database from existing backup

Please select “create instance from existing backup”

Now you get confirmation screen and proceed further

 

Leave a Reply

Your email address will not be published. Required fields are marked *