Wednesday 2 August 2017

Install and Configure DBvisit Standby on Oracle Database Appliance (ODA X6-2S) Part 4

In this part, we will create Database storage for Standby Database.



1. List dbstorage on standby ODA.

[root@ORCLODA2 ~]# odacli list-dbstorages
No db storage found

2. create  dbstorage on standby ODA.

[root@ORCLODA2 ~]# odacli create-dbstorage -n ORCL -r ACFS
{
  "jobId" : "6e000677-cbc9-4849-a123-730a5ae5785d",
  "status" : "Created",
  "message" : null,
  "reports" : [ ],
  "createTimestamp" : "June 21, 2017 15:35:07 PM PHT",
  "resourceList" : [ ],
  "description" : "Database storage service creation with db name: ORCL",
  "updatedTime" : "June 21, 2017 15:35:07 PM PHT"
}

3. Describe the job to check the status.

[root@ORCLODA2 ~]# odacli describe-job -i 6e000677-cbc9-4849-a123-730a5ae5785d

Job details
----------------------------------------------------------------
                     ID:  6e000677-cbc9-4849-a123-730a5ae5785d
            Description:  Database storage service creation with db name: ORCL
                 Status:  Success
                Created:  June 21, 2017 3:35:07 PM PHT
                Message:

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
validating the required disk space for data June 21, 2017 3:35:07 PM PHT        June 21, 2017 3:35:07 PM PHT        Success
Creating   volume datORCL                 June 21, 2017 3:35:07 PM PHT        June 21, 2017 3:35:18 PM PHT        Success
Creating ACFS filesystem for DATA        June 21, 2017 3:35:18 PM PHT        June 21, 2017 3:35:27 PM PHT        Success
createTDEAndAuditDirLocations            June 21, 2017 3:35:27 PM PHT        June 21, 2017 3:35:27 PM PHT        Success

4. Check if storage has created.

[root@ORCLODA2 ~]# odacli list-dbstorages

ID                                       Type   DBUnique Name        Status
---------------------------------------- ------ -------------------- ----------
cbfcbc7d-0c2c-4675-82a7-54e101db6946     Acfs   ORCL                  Configured



Tuesday 1 August 2017

Install and Configure DBvisit Standby on Oracle Database Appliance (ODA X6-2S) Part 3

In this part 3, we will create directories for archive logs on both machines,add the hosts and create initial configuration for the Data Guard.

1. Create dir for Archive logs on both Prod and DR.
mkdir -p  /u01/app/oracle/dbvisit_arch/MIC
chown -R oracle:oinstall /u01/app/oracle/dbvisit_arch/MIC
chmod -R 775 /u01/app/oracle/dbvisit_arch/MIC


2. connect to webconsole. And accept security certificate.

 3. Login as Admin.
 4. Click on Manage hosts to add the required hosts.
 5.Click on +NEW to add hosts.
 6. Enter hosts info and click on Create New Host.


 7. verify both hosts are online.
 8.Click on Manage configurations.
 9. Click on +NEW to add configuration.
 10. Select source host and accept license.
 11.Select source Database instance and verify archive log directory.
 12. Enter Standby host info and verify archive log directory, Dbvisit base directory, Database unique name and configuration name, enter license key. Then click on Submit.
 13. Verify configuration status.
 14. Now all the other taps are enabled.
For previous part, click on link below.
Install and Configure DBvisit Standby on Oracle Database Appliance (ODA X6-2S) Part 2