Oracle DBaaS 1z0-160 part 28:- Backup and recovery in RAC in oracle cloud

Backup and Recovery from DB Console You may face problem in taking backup to oracle container for oracle cloud RAC. Please follow below link to troubleshoot. Once you have resolved the issue,You can proceed with backup Please proceed to take backup Backup log location You can find backup of RMAN log for oracle cloud in following location:- [oracle@pocracdemo1 ~]$ […]

Oracle DBaaS 1z0-160 part 26 :- Install RAC from console in oracle database cloud

Please select create instance after selecting “Database” option Please select one of following options(I choose custom) Please select the option to create RAC Please provide SSH public key or create new key SSH key will be generated now Please provide other relevant information The instance will be now creating and will take 2-3 hours After installation you will get following […]

Oracle DBaaS 1z0-160 part 25 :- Recover database in oracle database cloud

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: 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 […]

Oracle DBaaS 1z0-160 part 24 :- Backup in single instance oracle cloud

Backup types When you create a database deployment, you choose one of the following backup destinations: Both Cloud Storage and Local Storage. Backups are configured to be created automatically and stored both on local compute node storage and on an Oracle Storage Cloud Service container. Cloud Storage Only. Backups are configured to be created automatically and stored on an Oracle […]

Oracle DBaaS 1z0-160 part 23 :- Dataguard Administration in oracle cloud

1.Please check status on primary dbaascli dataguard status –details yes 2.Please check status of dataguard in standby dbaascli dataguard status –details yes 3.Perform Switchover from primary to standby from console 4.Please note primary is standby and standby is now primary 5.Perform switchover from command line to switchover to primary again Use the password option to supply the SYS user password […]

Oracle DBaaS 1z0-160 part 22 :- OS Patching in oracle cloud

login as: opc Authenticating with public key “rsa-key-20180316” [opc@ORCL ~]$ sudo su – [root@ORCL ~]# /var/opt/oracle/patch/dbpatchmsm -list_ospatches INFO: non async case INFO: cmd is: /var/opt/oracle/patch/dbpatchm -list_ospatches Starting DBPATCHM Logfile is /var/opt/oracle/log/dbpatchm/dbpatchm_2018-03-28_11:49:32.log Config file is /var/opt/oracle/patch/dbpatchm.cfg <json begin>{“available_ospatch”:”yes”,”severity_ospatch”:”Critical”,”packages_list”:””}<json end> [root@ORCL ~]#  /var/opt/oracle/patch/dbpatchmsm -apply_ospatch_async INFO: async case INFO: patch number given is : <start txn>4<end txn> INFO: system cmd is: “nohup /var/opt/oracle/patch/dbpatchm […]

Oracle DBaaS 1z0-160 part 21 :- Patching in dataguard oracle cloud

Please check pre-requisites first You need to run the following command to check latest available patch dbaascli dbpatchm –run -list patches You may patch to be applied from dataguard side as well Please go to database console and check the Administration section Please run the prereq now for checking all pre-requisites already applied and check log as in screenshot Precheck […]

Oracle DBaaS 1z0-160 part 20 :- Dataguard Setup for Single Instance in oracle cloud

Please select the “Single Instance with Data Guard Standby” as Database Type in drop down. –> High Availability—The standby database is placed in a different availability domain from the primary database, thus providing isolation at the infrastructure level. –> Disaster Recovery—The standby database is placed in a different data center from the primary database, thus providing isolation at the infrastructure level .   Please […]