DBA Maestro - Helpful DBA tips

I imported newly built OEL 7.7 VM from Oracle VirtualBox to an ODA (Oracle Database Appliance). Upon starting up the VM, the network was showing as being up for device "eth0" however the /etc/sysconfig/network-scripts/ifcfg-eth0 was existent at the moment. I restarted the network service but received the "Failed to start LSB: Bring up/down networking" error. I followed the below steps to resolve this error. 1.  Stop and disable the NetworkManager service.      # systemctl stop NetworkManager.service      # systemctl disable NetworkManager.service 2.  Enable the network service.      # systemctl enable network.service 3.  Create the ifcfg-eth0  and populate with the appropriate information.      # vi /etc/sysconfig/network-scripts/ifcfg-eth0 contents: TYPE=Ethernet BOOTPROTO=static NAME=eth0 DEVICE=eth0 ONBOOT=yes IPADDR=<IP_ADDRESS> NETMASK=<SUBNET_MASK> GATEWAY=<DEFAULT_GATEWAY> 4.  Restart the network.      # ser

I was trying to create an Oracle Data Guard environment (physical standby) from an Oracle database running version 12.1.0.2. The database was running an older PSU version ("Database Patch Set Update : 12.1.0.2.161018 (24006101)") to be specific. Upon trying to build the standby by using RMAN DUPLICATE with ACTIVE DATABASE, I ran into the below error: executing Memory Script Starting backup at 16-JUL-18 RMAN-03009: failure of backup command on prm1 channel at 07/16/2018 13:51:46 ORA-17629: Cannot connect to the remote database server ORA-17630: Mismatch in the remote file protocol version client 2 server 3 continuing other job steps, job failed will not be re-run released channel: prm1 released channel: prm2 released channel: prm3 released channel: prm4 released channel: prm5 released channel: stb1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ====================

There wasn't any helpful blog entries out there for migrating a virtualized ODA VM that contains vdisks to another virtualized ODA.  Below is what I used in order to migrate the VMs over.  I'm using ACFS snapshots in order to successfully migrate my VMs. Always remember to test, test, and test before using this on a production ODA/VM. 1.  Execute the "oakcli show vm <vm_name>" in order to see the files that make-up the VM. [root@oda1dom0] # oakcli show vm TESTVM The Resource is : TESTVM         AutoStart       :       never         CPUPriority     :       100         Disks           :       |file:/OVS/Repositories/demorepo/.A                                 CFS/snaps/TESTVM/VirtualMachine                                 s/TESTVM/612aeba3b38f4527a4500e                                 c202a08e3f.img,xvda,w|         Domain          :       XEN_PVM         DriverDomain    :       False         ExpectedState   :       online         FailOver        :

If this error is coming in Oracle database, then take downtime and do the following:  Drop the queue table - exec dbms_aqadm.drop_queue_table( queue_table=>'SYS.SYS$SERVICE_METRICS_TAB', force => TRUE) select object_name, object_type from dba_objects where object_name like '%SYS$SERVICE_%'; ----> no rows should be returned. Follow the below steps to recreate the queue table. SQL>STARTUP SQL>alter system enable restricted session; SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql SQL>alter system disable restricted session;

I was attempting to restore a backup via RMAN but received the following errors: RMAN-06023: no backup or copy of datafile 11 found to restore RMAN-06023: no backup or copy of datafile 10 found to restore RMAN-06023: no backup or copy of datafile 9 found to restore RMAN-06023: no backup or copy of datafile 8 found to restore RMAN-06023: no backup or copy of datafile 7 found to restore RMAN-06023: no backup or copy of datafile 6 found to restore RMAN-06023: no backup or copy of datafile 5 found to restore RMAN-06023: no backup or copy of datafile 4 found to restore RMAN-06023: no backup or copy of datafile 3 found to restore RMAN-06023: no backup or copy of datafile 2 found to restore RMAN-06023: no backup or copy of datafile 1 found to restore The issue was with the FRA (Fast Recovery Area). RMAN will catalog any objects in the Flash Recovery Area that will not be registered in the controlfile and if any of this files belongs to an incarnation different from CURR

A client that I was supporting asked me to complete a dry run of a database restore on their newly built ODA.  Below are the steps that I performed to complete the database restore. Prerequisites: I built the RAC database using OAKCLI. I backed up the database with RMAN incremental level 0 + cumulative level 1. I dropped the database using SQLPLUS commands vs. OAKCLI as to not remove the ACFS directories for the database. 1. Startup the database instance in NOMOUNT. RMAN> startup nomount force; startup failed: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '/u02/app/oracle/oradata/datastore/.ACFS/snaps/labtest/labtest/spfilelabtest.ora' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 starting Oracle instance without parameter file for retrieval of spfile Oracle instance started Total System Global Area    1073741824 bytes Fixed Size                     293263