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
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
[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
For the Cloud Storage Only destination, enter:
# The bkup.cfg file will hold all the config info for BKUP
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
#### 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