Posts

Revive RMAN: Mastering the Art of Resuming Failed Duplicate Operations

  Hey Oracle DBAs! It's been a while, Oracle community! But I'm back with a helpful post. :-) Today, I faced an issue while performing an RMAN duplicate to build out a standby database (Oracle version 19.25) on an ExaCS VM. The database is 110 TB in size. I was doing an active duplicate over the WAN for 2 days. Everything was going smoothly until it reached ~94% completion... and then it FAILED!! I didn't want to risk restarting the entire RMAN duplicate process again out of concern that the same issue would occur. Here's my error: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 04/10/2025 09:57:48 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script ORA-19875: multisection restore or copy not complete ...

Redhat Linux logical volume extension

I needed to extend a LV as it was small for what I needed to do. As you can see below, it was originally 20G in size. As root, I did the following steps: # df -h /u01 Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg00-lvU01 20G 9.1G 11G 46% /u01 1. First, I had to check for free size on the Volume Group. # vgdisplay --- Volume group --- VG Name vg00 System ID Format lvm2 Metadata Areas 1 Metadata Sequence No 8 VG Access read/write VG Status resizable MAX LV 0 Cur LV 7 Open LV 7 Max PV 0 Cur PV 1 Act PV 1 VG Size <222.02 GiB PE Size 4.00 MiB Total PE 56836 Alloc PE / Size 20480 / 80.00 GiB Free PE / Size 36356 / <142.02 GiB VG UUID poBYqN-t5P3-t6rE-UfeI-eaXj-OoMe-l1a39z 2. From above exam...

"Failed to start LSB: Bring up/down networking" after OEL 7 VM build

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_MAS...

ORA-17630: Mismatch in the remote file protocol version client 2 server 3

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: ====================...

Migrate ODA VM to another ODA (with vdisks)

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 ...

ORA-00600: error in Queue Table SYS.SYS$SERVICE_METRICS_TAB

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;

RMAN-06023: no backup or copy of datafile X found to restore

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...