Monday , May 27 2019
Home / Databases

Databases

Oracle backup fail with Unknown message (code 314) received

You can face issue with Data Protector backup for Oracle RAC. Detail error: [Major] From: BSM@cellmanager.local “RAC_node01_VIP” Time: 4/12/2016 9:56:24 AM [61:3001] Unknown message (code 314) received from OB2BAR Backup DA@oraclenode1.local. RMAN-08522: input datafile file number=00002 name=+DPRAC01/racdb/datafile/sysaux.257.908907085 RMAN-08038: channel dev_1: starting piece 1 at 12-APR-16 RMAN-08048: channel dev_2: starting incremental …

Read More »

Easy steps to build your own Oracle Linux RAC 11g R2

LAB requirements Setup /etc/hosts file on both RAC nodes #Public network 190.168.10.161 oralxnode01dr.testlab.local oralxnode01dr 190.168.10.162 oralxnode02dr.testlab.local oralxnode02dr ##Private network 10.10.100.161 oralxnode01dr-priv.testlab.local oralxnode01dr-priv 10.10.100.162 oralxnode02dr-priv.testlab.local oralxnode02dr-priv ###Virtual IP network 190.168.10.165 oralxnode01dr-vip.testlab.local oralxnode01dr-vip 190.168.10.166 oralxnode02dr-vip.testlab.local oralxnode02dr-vip ###Scan IP 190.168.10.167 oralx-scan02.testlab.local oralx-scan02 ###ASM disk 190.168.10.100 dcpr01.testlab.local dcpr0 2. Setup iSCSI microsoft target server …

Read More »

Fail to restore of Data Protector managed control file backup

When you plan to restore Oracle database, in both standalone or RAC environment, you might face issue with restore of Data Protector managed control file backup. Detail error code: [Major] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM Failed to restore file ‘/var/opt/omni/tmp/ctrl_racdb_4793.dbf’. [Normal] From: OB2BAR_DMA@oralxnode01.testlab.local “racdb” Time: 4/7/2016 8:30:51 AM …

Read More »

Back up failed Virtual Device Interface reported error

Back up MSSQL failed Virtual Device Interface reported error Detail: [Normal] From: OB2BAR_Main@SQL-server.hostname “(DEFAULT)”  Time: 5/15/2015 7:35:16 PM Starting backup of database DATABASE_NAME. Required backup type is ??. [Normal] From: OB2BAR_Main@SQL-server.hostname “(DEFAULT)”  Time: 5/15/2015 7:35:16 PM SQL statement: BACKUP DATABASE (DATABASE_NAME) TO VIRTUAL_DEVICE = ‘Data Protector_(DEFAULT)_DATABASE_NAME_113027685_0’ WITH NAME = ‘Data …

Read More »

ORA-19602 cannot backup or copy active file in NOARCHIVELOG mode

ORA-19602 cannot backup or copy active file in NOARCHIVELOG mode Enabling Archivelog Mode : SQL> connect sys/<password> as sysdba SQL> shutdown immediate; SQL> startup mount: SQL> alter database archivelog; SQL> alter database open;SQL> select log_mode from v$database; LOG_MODE ————————————————– ARCHIVELOG SQL> archive log list; 10g introduce new feature called FRA …

Read More »