ORA-01034: ORACLE not available / ORA-27101: shared memory realm does not exist

Database is "UP" but Veritas Netbackup detect that the oracle db is down and cannot create template from Netbackup Java Console. Because of this error, than I try to configure the Hot Backup Oracle using RMAN script provided by Netbackup on "/usr/openv/netbackup/ext/db_ext/oracle/samples/rman". Using this script, I also found the same error. RMAN-00571:============================================= RMAN-00569:======== ERROR MESSAGE STACK FOLLOWS ========= RMAN-00571:============================================= RMAN-03002: failure of allocate...

Read More

Hot Backup Oracle using Veritas Netbackup

Requirements :Oracle DB Archivelog status = ON & Start …….. hereControlfile Autobackup = ON…….. hereDefault Autobackup device type = SBT_TAPEPreparations : Install Netbackup for Oracle AgentShutdown all of the Oracle instances (SIDs).Login or su – from root to oracle user# sqlplus /nologSQL> connect / as sysdbaSQL> shutdown immediateSQL> exitLink Netbackup to Oracle :Automatically link :/install_path /netbackup/bin/oracle_linkManually Link :ln -s /install_path /netbackup/bin/libobk.so.1 libobk.so (solaris)ln -s /install_path /netbackup/bin/libobk.so64.1...

Read More

Hot Database Backup Sample Script

Online Backup Shell Script for Full DB & archivelogs refer to sample RMAN script (/install_path/netbackup/ext/db_ext/oracle/samples/rman)#!/bin/sh# $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $#bcpyrght#***************************************************************************#$VRTScprght:Copyright 1993-2003 VERITAS Software Corporation,All Rights Reserved $#***************************************************************************#ecpyrght#hot_database_backup.sh# Determine the user which is executing this script.CUSER=`id |cut...

Read More

Enabling Oracle ARCHIVELOG Mode

Procedure 1Login as "ora" or su - from "root" at operating system# sqlplus /nologSQL > connect / as sysdbaSQL > shutdown immediate;SQL > startup mount;Checking the current archive mode status.SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;LOG_MODE------------NOARCHIVELOGSet archivelog destination and format :SQL> alter system set log_archive_format=’ SIDarch%t_%s.dbf;SQL> alter system set log_archive_dest=’/oracle/SID/archivelogs;Check archivelog destination and formatSQL> select name,value from v$parameter where name=’log_archive_format’;SQL>...

Read More

Problem solving Error Status Code 6 [NBU - Oracle]

Problem : STATUS CODE 6: "The backup failed to back up the requested files" The archive log file may have been deleted from the operating system and it does not exist at the specified location. Reference : http://seer.entsupport.symantec.com/docs/275089.htm Resolution : RMAN> Change Archivelog All Validate; RMAN> Change Archivelog All Crossche...

Read More