tag:blogger.com,1999:blog-64532980717819424352024-03-09T04:42:58.265+07:00j5dj5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-6453298071781942435.post-86838731457392840602008-02-26T16:11:00.006+07:002015-03-17T15:05:03.738+07:00ORA-01034: ORACLE not available / ORA-27101: shared memory realm does not exist<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">Database is "UP" but Veritas Netbackup detect that the oracle db is down and cannot create template from Netbackup Java Console.</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">Because of this error, than I try to configure the Hot Backup Oracle using RMAN script provided by Netbackup on <span style="color: #000099; font-weight: bold;">"/usr/openv/netbackup/ext/db_ext/oracle/samples/rman". </span>Using this script, I also found the same error.</span></span><br />
<div class="fullpost">
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<br />
<blockquote>
<blockquote class="tr_bq">
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">RMAN-00571:=============================================</span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">RMAN-00569:======== ERROR MESSAGE STACK FOLLOWS =========</span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">RMAN-00571:=============================================</span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">RMAN-03002: failure of allocate command at 02/25/2008 15:12:29</span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">RMAN-06403: could not obtain a fully authorized session</span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-weight: bold;">ORA-01034: ORACLE not available</span></span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;"><span style="font-weight: bold;">ORA-27101: shared memory realm does not exist</span></span></span></span><br />
<span style="background-color: white;"><span style="font-size: x-small;"><span style="font-family: "Courier New",Courier,monospace;">SVR4 Error: 2: No such file or directory</span></span></span></blockquote>
</blockquote>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">We can connect locally to RMAN, and test the link to Veritas Netbackup with successfully.</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<br />
<blockquote>
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">bash-2.05$ pwd</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">/rdbms/oracle9</span></span></blockquote>
<blockquote>
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">bash-2.05$ rman target veritas/veritas</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">Recovery Manager: Release 9.2.0.6.0 - 64bit Production</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">connected to target database: ODONG2 (DBID=1263713746)</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">RMAN> RUN {</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">3> RELEASE CHANNEL ch00;</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">4> }</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">using target database controlfile instead of recovery catalog</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">allocated channel: ch00</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">channel ch00: sid=38 devtype=SBT_TAPE</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;"><span style="font-weight: bold;">channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2003103006)</span></span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">released channel: ch00</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">RMAN> quit</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">Recovery Manager complete.</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="background-color: white; font-size: x-small;">bash-2.05$</span></span></blockquote>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">But using the netbackup Java Console & Netbackup Script still the same error. After discuss with the DBA, refer to <a href="http://seer.entsupport.symantec.com/docs/252863.htm" style="color: #cc0000; font-weight: bold;">documentation support from Veritas Netbackup</a>, and some tries, we found that, the problem is on environtment variables :</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">Here is our environtment variables on this server :</span></span><br />
<blockquote>
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">bash-2.05$ env</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">PWD=/rdbms/oracle9</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">ORACLE_SID=test</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">HOSTNAME=odong2</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">LD_LIBRARY_PATH=/rdbms/oracle9/OraHome1/lib</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">MACHTYPE=sparc-sun-solaris2.9</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">MAIL=/var/mail/oracle9</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">EDITOR=vi</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">ORACLE_BASE=/rdbms/oracle9/</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">ORACLE_HOME=/rdbms/oracle9//OraHome1/</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">LOGNAME=oracle9</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">SHELL=/bin/bash</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">HOSTTYPE=sparc</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">OSTYPE=solaris2.9</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">HOME=/rdbms/oracle9</span></span></blockquote>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">And the problem is we cannot go directly to <span style="font-weight: bold;">ORACLE_HOME</span> using the script, but must be used <span style="font-weight: bold;">"ORACLE_HOME=$ORACLE_BASE/OraHome1/"</span> .</span></span><br />
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="color: #000099; font-size: x-small; font-weight: bold;">To SOLVE the problem, we <span style="color: red;">"add"</span> the ORACLE_BASE parameter to the</span><span style="font-size: x-small;"> <span style="color: #000099; font-weight: bold;">Script :</span></span></span><br />
<blockquote>
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"># ----------------------------------------------------------</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"># Replace /db/oracle81, below, with the Oracle home path.</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"># ----------------------------------------------------------</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"><br /></span></span>
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"><span style="color: red; font-weight: bold;">ORACLE_BASE=/rdbms/oracle9/</span></span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;"><span style="color: red; font-weight: bold;">export ORACLE_BASE</span></span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">ORACLE_HOME=$ORACLE_BASE/OraHome1/</span></span><br />
<span style="font-family: "Courier New",Courier,monospace;"><span style="font-size: x-small;">export ORACLE_HOME</span></span></blockquote>
<span style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: x-small;">After adding the ORACLE_BASE parameter, Hot Backup Online Oracle running <span style="font-weight: bold;">normal</span>.</span></span></div>
j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com1tag:blogger.com,1999:blog-6453298071781942435.post-1521819936618608922008-01-31T14:54:00.000+07:002008-01-31T15:05:34.380+07:00Hot Backup Oracle using Veritas Netbackup<span style="font-weight: bold; color: rgb(0, 0, 153);">Requirements :</span><br />Oracle DB Archivelog status = ON & Start <span style="font-weight: bold;">……..</span> <a href="http://j5d.blogspot.com/2008/01/enabling-oracle-archivelog-mode.html"><span style="font-size:130%;"><span style="font-weight: bold;">here</span></span></a><br />Controlfile Autobackup = ON<span style="font-weight: bold;">…….. <a href="http://j5d.blogspot.com/2008/01/turning-on-autobackup-oracle-rman.html"><span style="font-size:130%;">here</span></a></span><br />Default Autobackup device type = SBT_TAPE<br /><br /><span style="font-weight: bold; color: rgb(0, 0, 153);">Preparations : </span><br />Install Netbackup for Oracle Agent<br />Shutdown all of the Oracle instances (SIDs).<br />Login or su – from root to oracle user<br /><blockquote># sqlplus /nolog</blockquote><blockquote>SQL> connect / as sysdba<br />SQL> shutdown immediate<br />SQL> exit</blockquote><div class="fullpost"><br />Link Netbackup to Oracle :<br />Automatically link :<br /><blockquote>/install_path /netbackup/bin/oracle_link</blockquote>Manually Link :<br /><blockquote>ln -s /install_path /netbackup/bin/libobk.so.1 libobk.so (solaris)<br />ln -s /install_path /netbackup/bin/libobk.so64.1 libobk.so (solaris with 64-bit Oracle Software)<br />ln -s /install_path /netbackup/bin/libobk.a64 libobk.a (AIX)<br />ln -s /install_path /netbackup/bin/libobk.sl64 libobk.sl (HP-UX)<br />ln -s /install_path /netbackup/bin/libobk.so libobk.so (linux)</blockquote>Test Connectivity from Oracle RMAN to Veritas Netbackup :<br /><blockquote>RMAN> run{allocate channel ch00 type 'SBT_TAPE';<br />2> release channel ch00;<br />3> }</blockquote>Output :<br /><blockquote>using target database controlfile instead of recovery catalog<br />allocated channel: ch00<br />channel ch00: sid=14 devtype=SBT_TAPE<br />channel ch00: VERITAS NetBackup for Oracle - Release 5.0GA (2006030216)<br />released channel: ch00<br />RMAN> quit<br />Recovery Manager complete.</blockquote><br /><span style="font-weight: bold; color: rgb(0, 0, 153);">Hot Backup Oracle :</span><br /><br />Create Online Backup Shell Script for Full DB & archivelogs refer to sample RMAN script on <span style="font-weight: bold;">"/install_path/netbackup/ext/db_ext/oracle/samples/rman"</span> or using template from Veritas Netbackup GUI Wizard.<br /><br />Hot Backup Oracle SCRIPT<span style="font-weight: bold;">…….. <a href="http://j5d.blogspot.com/2008/01/hot-database-backup-sample-script.html"><span style="font-size:130%;">here</span></a></span><br />Hot Backup Oracle TEMPLATE<span style="font-weight: bold;">…….. <a href="http://support.veritas.com/docs/290216"><span style="font-size:130%;">here</span></a></span><br /><br />Create Policy for Full Online Backup & Archivelogs Backup.<br />Test Hot Backup Oracle using Veritas Netbackup.<br /></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-78909474311810002872008-01-31T14:37:00.000+07:002008-01-31T14:51:41.904+07:00Hot Database Backup Sample ScriptOnline Backup Shell Script for Full DB & archivelogs refer to sample RMAN script (/install_path/netbackup/ext/db_ext/oracle/samples/rman)<br /><br /><span style=";font-family:courier new;font-size:85%;" >#!/bin/sh<br /># $Header: hot_database_backup.sh,v 1.2 2002/08/06 23:51:42 $<br />#bcpyrght<br />#***************************************************************************<br />#$VRTScprght:Copyright 1993-2003 VERITAS Software Corporation,All Rights Reserved $<br />#***************************************************************************<br />#ecpyrght<br />#hot_database_backup.sh<br /># Determine the user which is executing this script.<br />CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`<br /># Put output in <this>.out. Change as desired.<br /># Note: output directory requires write permission.<br />RMAN_LOG_FILE=${0}.out<br /># You delete the output file so that backup information does not accumulate.<br /># If not, delete the following lines.<br /></this><div class="fullpost"><br />if [ -f "$RMAN_LOG_FILE" ]<br />then<br /> rm -f "$RMAN_LOG_FILE"<br />fi<br /># Initialize the log file.<br />echo >> $RMAN_LOG_FILE<br />chmod 666 $RMAN_LOG_FILE<br /># Log the start of this script.<br />echo Script $0 >> $RMAN_LOG_FILE<br />echo ==== started on `date` ==== >> $RMAN_LOG_FILE<br />echo >> $RMAN_LOG_FILE<br /><br /># Replace /db/oracle/product/ora81, below, with the Oracle home path.<br /><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >ORACLE_HOME=/db/oracle/product/ora81</span><span style="font-size:100%;"><br /></span><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >export ORACLE_HOME</span><br /># Replace ora81, below, with the Oracle SID of the target database.<br /><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >ORACLE_SID=ora81</span><span style="font-size:100%;"><br /></span><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >export ORACLE_SID</span><br /># Replace ora81, below, with the Oracle DBA user id (account).<br /><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >ORACLE_USER=ora81</span><br /># Set the target connect string. Replace "sys/manager", below, with the target connect string.<br /><span style="font-weight: bold; color: rgb(0, 0, 153);font-size:100%;" >TARGET_CONNECT_STR=sys/manager</span><br /># Set the Oracle Recovery Manager name.<br />RMAN=$ORACLE_HOME/bin/rman<br /># Print out the value of the variables set by this script.<br />echo >> $RMAN_LOG_FILE<br />echo "RMAN: $RMAN" >> $RMAN_LOG_FILE<br />echo "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE<br />echo "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE<br />echo "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE<br /># Print out the value of the variables set by bphdb.<br />echo >> $RMAN_LOG_FILE<br />echo "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE<br />echo "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE<br />echo "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE<br />echo "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE<br />echo "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE<br /># NOTE: This script assumes that the database is properly opened.<br /># If desired, this would be the place to verify that.<br />echo >> $RMAN_LOG_FILE<br />if [ "$NB_ORA_FULL" = "1" ]<br />then<br /> echo "Full backup requested" >> $RMAN_LOG_FILE<br /> BACKUP_TYPE="INCREMENTAL LEVEL=0"<br />elif [ "$NB_ORA_INCR" = "1" ]<br />then<br /> echo "Differential incremental backup requested" >> $RMAN_LOG_FILE<br /> BACKUP_TYPE="INCREMENTAL LEVEL=1"<br />elif [ "$NB_ORA_CINC" = "1" ]<br />then<br /> echo "Cumulative incremental backup requested" >> $RMAN_LOG_FILE<br /> BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"<br />elif [ "$BACKUP_TYPE" = "" ]<br />then<br /> echo "Default - Full backup requested" >> $RMAN_LOG_FILE<br /> BACKUP_TYPE="INCREMENTAL LEVEL=0"<br />fi<br /># Call Recovery Manager to initiate the backup. This example does not use a Recovery Catalog.<br /># If you choose to use one, replace the option 'nocatalog' from the rman command line below<br /># with the 'rcvcat <userid>/<passwd>@<tns>' statement.<br /># Backs up the whole database. This backup is part of the incremental strategy<br /># (this means it can have incremental backups of levels > 0 applied to it).<br />CMD_STR="<br />ORACLE_HOME=$ORACLE_HOME<br />export ORACLE_HOME<br />ORACLE_SID=$ORACLE_SID<br />export ORACLE_SID<br />$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append <<>> $RMAN_LOG_FILE<br /> RSTAT=$?<br />else<br /> /usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE<br /> RSTAT=$?<br />fi<br /># Log the completion of this script.<br />if [ "$RSTAT" = "0" ]<br />then<br /> LOGMSG="ended successfully"<br />else<br /> LOGMSG="ended in error"<br />fi<br />echo >> $RMAN_LOG_FILE<br />echo Script $0 >> $RMAN_LOG_FILE<br />echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE<br />echo >> $RMAN_LOG_FILE<br />exit $RSTAT<br /></tns></passwd></userid></div></span>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-14134443905061613882008-01-31T14:18:00.000+07:002008-01-31T14:29:43.079+07:00Enabling Oracle ARCHIVELOG Mode<span style="font-weight: bold; color: rgb(0, 0, 153);">Procedure 1</span><br /><br />Login as "ora<sid>" or su - from "root" at operating system<br /><blockquote># sqlplus /nolog</blockquote><blockquote>SQL > connect / as sysdba<br />SQL > shutdown immediate;<br />SQL > startup mount;</blockquote>Checking the current archive mode status.<br /><blockquote>SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;<br />LOG_MODE<br />------------<br />NOARCHIVELOG</blockquote><div class="fullpost"><br />Set archivelog destination and format :<br /><blockquote>SQL> alter system set log_archive_format=’ SIDarch%t_%s.dbf;<br />SQL> alter system set log_archive_dest=’/oracle/SID/archivelogs;</blockquote>Check archivelog destination and format<br /><blockquote>SQL> select name,value from v$parameter where name=’log_archive_format’;<br />SQL> select name,value from v$parameter where name=’log_archive_dest’;</blockquote>Backup or Copy original "initSID.ora" :<br /><blockquote># cp /oracle/SID/920_64/dbs/initSID.ora /oracle/SID/920_64/dbs/initSID.ora.orig</blockquote><blockquote>SQL> create pfile=’ /oracle/SID/920_64/dbs/initSID.ora’ from spfile;<br />SQL> alter database archivelog;<br />SQL> select log_mode from v$database;<br />LOG_MODE<br />------------<br />ARCHIVELOG<br />SQL> alter database open;<br />SQL> exit</blockquote><br /><span style="font-weight: bold; color: rgb(0, 0, 153);">PROCEDURE 2 [only do this procedure if procedure 1 above failed]</span><br /><br />This procedure update the pfile directly. The pfile should be in either $ORACLE_BASE/admin/SID/pfile or $ORACLE_HOME/admin/SID/pfile.<br /><br />Login as "ora<sid>" or su - from "root" at operating system.<br /><blockquote># sqlplus /nolog</blockquote><blockquote>SQL > connect / as sysdba</blockquote>Checking the current archive mode status, if status "NOARCHIVELOG" than shutdown database to run enable archivelog mode procedure.<br /><blockquote>SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;<br />LOG_MODE<br />------------<br />NOARCHIVELOG<br />SQL > shutdown immediate;<br />SQL > exit</blockquote><blockquote># vi $ORACLE_BASE/admin/SID/pfile</blockquote>Add the following lines to the end of the pfile : <blockquote># Archive Log Destinations #<br /> log_archive_dest_1='location=/oracle/SID/archivelogs'<br /> log_archive_start=TRUE</blockquote>Startup the database in mount mode and put it in archivelog mode.<br /><blockquote># sqlplus /nolog</blockquote><blockquote>SQL > connect / as sysdba<br />SQL > startup mount;<br />SQL> alter database archivelog;<br />SQL> alter database open;</blockquote>Check archivelog destination and status<br /><blockquote>SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;<br />LOG_MODE<br />------------<br />ARCHIVELOG<br />SQL> show parameter log_archive_dest_1<br />SQL> show parameter spfile;<br />SQL> show parameter log_archive_start;</blockquote>Test create archivelog<br /><blockquote>SQL> alter system switch logfile;<br />SQL> create pfile from spfile;<br />SQL> shutdown immediate;<br />SQL> startup<br />SQL> exit</blockquote></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-65250958078557005722008-01-31T14:06:00.000+07:002015-03-31T14:48:22.437+07:00Problem solving Error Status Code 6 [NBU - Oracle]Problem :
<br />
<span style="font-weight: bold;">STATUS CODE 6: "The backup failed to back up the requested files"</span>
<br />
The archive log file may have been deleted from the operating system and it does not exist at the specified location.
<br />
<br />
Reference :
<br />
<a href="http://seer.entsupport.symantec.com/docs/275089.htm"><span style="font-weight: bold;">http://seer.entsupport.symantec.com/docs/275089.htm</span></a><br />
<br />
Resolution :
<br />
<div style="background-color: #c2c2c2; border: 2px #006400 ridge; padding: 10px; text-align: left;">
RMAN> Change Archivelog All Validate;<br />
RMAN> Change Archivelog All Crosscheck;<br /></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-45725176742064373482008-01-21T13:43:00.000+07:002008-01-21T13:54:22.849+07:00HP-UX as SAN Media Server in Netbackup 5.XStep by step documentation configuring HP-UX as SAN Media server on Veritas Netbackup 5.X environtments.<br />Before configure the drives in netbackup, at first we must configure the drives at OS level and zoning the tape drives from HP-UX to Tape Library.<br /><br />List all HBA (Host Bus Adapter) in the HP-UX server to get the hardware path :<br /><blockquote>root@j5d # ioscan -funC fc</blockquote><blockquote>Class I H/W Path Driver S/W State H/W Type Description<br />=================================================================<br />fc 2 4/1/0 td CLAIMED INTERFACE HP Tachyon TL/TS Fibre Channel Mass Storage Adapter<br /> <span style="font-weight: bold;">/dev/td2</span><br />fc 0 1/1/0 td CLAIMED INTERFACE HP Tachyon TL/TS Fibre Channel Mass Storage Adapter<br /> /dev/td0<br />fc 1 1/2/0 td CLAIMED INTERFACE HP Tachyon TL/TS Fibre Channel Mass Storage Adapter<br /> /dev/td1</blockquote><div class="fullpost"><br />Check FC cable connectivity (driver state) and WWN for Zoning purpose on SAN Switch Level :<br /><blockquote>root@j5d # fcmsutil /dev/td2<br /></blockquote><div style="text-align: justify;"><blockquote> Vendor ID is = 0x00103c<br /> Device ID is = 0x001028<br /> TL Chip Revision No is = 2.3<br /> PCI Sub-system Vendor ID is = 0x00103c<br /> PCI Sub-system ID is = 0x000006<br /> Topology = PTTOPT_FABRIC<br /> Local N_Port_id is = 0x043900<br /> <span style="font-weight: bold;">N_Port Node World Wide Name = 0x50060b000006714f</span><br /><span style="font-weight: bold;"> N_Port Port World Wide Name = 0x50060b000006714e</span><br /> <span style="font-weight: bold;">Driver state = ONLINE</span><br /> <span style="font-weight: bold;">Hardware Path is = 4/1/0</span><br /> Number of Assisted IOs = -1906797105<br /> Number of Active Login Sessions = 1</blockquote>After get the wwn do zoning on SAN Switch, next step, check the tape drives on the hp-ux :<br /></div><blockquote>root@j5d # ioscan -funC tape</blockquote><blockquote>Class I H/W Path Driver S/W State H/W Type Description<br />===========================================================================<br />tape 20 0/1/1/1.6.0 stape CLAIMED DEVICE HP Ultrium 2-SCSI<br /> /dev/rmt/20m /dev/rmt/20mn /dev/rmt/c3t6d0BEST /dev/rmt/c3t6d0BESTn<br /> /dev/rmt/20mb /dev/rmt/20mnb /dev/rmt/c3t6d0BESTb /dev/rmt/c3t6d0BESTnb<br />tape 1 0/4/1/0.234.18.255.5.5.0 stape CLAIMED DEVICE IBM ULTRIUM-TD1</blockquote>Install the driver for this tape drives, when the OS has detected :<br /><blockquote>root@j5d # insf -e</blockquote><blockquote>insf: Installing special files for stape instance 1 address 0/4/1/0.234.18.255.5.5.0</blockquote>Check again to make sure all the tape drives and drivers for the tape drives has been detect and installed :<br /><blockquote>root@j5d # ioscan -funC tape</blockquote><blockquote>Class I H/W Path Driver S/W State H/W Type Description<br />===========================================================================<br />tape 1 0/4/1/0.234.18.255.5.5.0 stape CLAIMED DEVICE IBM ULTRIUM-TD1<br /> /dev/rmt/1m /dev/rmt/1mn /dev/rmt/c16t5d0BEST /dev/rmt/c16t5d0BESTn<br /> /dev/rmt/1mb /dev/rmt/1mnb /dev/rmt/c16t5d0BESTb /dev/rmt/c16t5d0BESTnb</blockquote>After above step successfully done, than we can continue to configure on netbackup level :<br />- Install Netbackup Master/Media agent.<br />- Do "scan" from netbackup to check the drives has been detect by netbackup :<br /><blockquote>root@j5d # /usr/openv/volmgr/bin/scan</blockquote>make sure all tape drives has been successfully detect.<br />If netbackup still cannot detect the tape drives, re-start the server ....<br /><br />- Set parameter Global Device :<br /><blockquote>root@j5d # /usr/openv/volmgr/bin/vmglob -set_gdbhost "master" -h "master" --> master = master backup hostname</blockquote>- Configure tape drives :<br /><blockquote>root@j5d # /usr/openv/volmgr/bin/tpautoconf -a --> automatic configure tape drives<br /></blockquote>- Stop all Netbackup process :<br /><blockquote>root@j5d # /usr/openv/netbackup/bin/goodies/netbackup stop "or" /usr/openv/netbackup/bin/goodies/netbackup/bp.kill_all</blockquote>- Start all Netbackup process :<br /><blockquote>root@j5d # /usr/openv/netbackup/bin/goodies/netbackup start</blockquote>- Check All Netbackup Process running well.<br /><blockquote>root@j5d # /usr/openv/netbackup/bin/bpps -a</blockquote>After completed the devices configuration, create the storage unit, volume pool, and backup policy. Afterward test Backup and Restore. Thanks.</div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-84446411208069825312008-01-16T14:15:00.000+07:002008-01-16T14:26:47.100+07:00Turning on "AUTOBACKUP" Oracle RMAN<span style="font-size: 10pt; font-family: "Arial","sans-serif";"><o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";">Steps:</span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br /></span><blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";"># rman target /</span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><o:p><br /></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";">RMAN><br /></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";">RMAN> show all;</span></blockquote><blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";"></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style=""></span><span style="color: red;">CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default</span></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style=""><br /></span><span style="color: red;">CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default</span></span><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: red;"><span style=""><br /></span>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default</span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style=""></span></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br /></span><blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";"></span></blockquote></blockquote><blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";">RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;<o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br />RMAN> SET CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';<o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br />RMAN> SET CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';<o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br />RMAN> show all;</span></blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style=""></span><b><span style="color: blue;"></span></b></span><blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style="color: blue;">CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE; # default<o:p></o:p></span></span><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;"><span style=""><br /></span>CONFIGURE CONTROLFILE AUTOBACKUP ON; # default<o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;"><span style=""><br /></span>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default</span><b><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: blue;"><o:p></o:p></span></b><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><span style=""><br /></span></span></blockquote><span style="font-size: 10pt; font-family: "Arial","sans-serif";">Test the control file backup to tape : <o:p></o:p></span><span style="font-size: 10pt; font-family: "Arial","sans-serif";"><br /><blockquote>RMAN> backup current controlfile;</blockquote><o:p></o:p></span>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-86363285080006349452008-01-11T01:44:00.000+07:002008-01-11T01:50:14.819+07:00Controlling services on RHEL 4 :List all services :<br /><blockquote># chkconfig --list</blockquote>Active/Deactive services<br /><blockquote># chkconfig "servicesname" on/off</blockquote>Set service active on specific run level<br /><blockquote># chkconfig --level 35 "servicesname" on/off</blockquote>Remove service<br /><blockquote># chkconfig --del "servicesname"</blockquote> Add Service<br /><div class="fullpost"><br /><blockquote># chkconfig --add "servicesname"</blockquote>Restart service<br /><blockquote># service "servicesname" restart</blockquote><br />or using GUI/System Utility :<br /><blockquote># system-config-services</blockquote> <blockquote># ntsysv</blockquote><br /><br /></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-53856582558478018572008-01-11T01:38:00.000+07:002008-01-11T01:44:01.062+07:00Fixing a corrupt GRUB MBR on RHEL 4Use grub-install to fix:<br /><blockquote># chroot /mnt/sysimage<br /># /sbin/grub-install /dev/hda<br /># quit</blockquote>or<br /><blockquote># /sbin/grub-install --directory="mountpoint" /dev/hda </blockquote>where "mountpoint" is boot partition<br /><br />If above steps fails try the following :<br />Launch a grub shell:<br /><div class="fullpost"><br /><blockquote># /sbin/grub</blockquote><blockquote>grub>root (hd0,0)<br />grub>setup (hd0)<br />grub>quit</blockquote><br />Create grub password :<br /><br /><blockquote># grub-md5-crypt<br />password : password<br />retype : password</blockquote>Copy encryption password to /boot/grub/grub.conf under hiddenmenu<br /><blockquote># vi /boot/grub/grub.conf</blockquote><blockquote>----------<br />hiddenmenu<br />password --md5 ialknda$SDLKANDADikaldnald9addasdad<br />----------</blockquote></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-39964875823175947272008-01-07T16:23:00.000+07:002008-01-07T16:54:40.961+07:00Additional step (troubleshooting) to Configure Solaris Tape drives for Netbackup .....This procedure must be successfully <span style="font-weight: bold; color: rgb(255, 0, 0);">"done"</span> to troubleshoot Un-Detect tape drives after netbackup sg.install installation.<br /><blockquote>root@j5d # ls -l /dev/rmt/*cbn<br /></blockquote><blockquote>root@j5d # /usr/openv/volmgr/bin/scan<br /></blockquote>Display PCI slot configuration information for tape drives<br /><br /><div class="fullpost"><blockquote>root@j5d # cfgadm –al<br /></blockquote><blockquote><span style="font-size:78%;">c0::dsk/c0t6d0 CD-ROM connected configured unknown<br />c1 fc-private connected configured unknown<br />c1::21xxxxxxxxxxxxx2 disk connected configured unknown<br />c5 fc-fabric connected configured unknown<br />c5::50xxxxxxxxxxxxx2 tape connected configured unknown<br />c5::50xxxxxxxxxxxxxe tape connected configured unknown<br />....<br />c6 fc connected unconfigured unknown</span></blockquote>Unconfigure tape devices<br /><blockquote>root@j5d # cfgadm -c unconfigure c5</blockquote>Clean-up device file<br /><blockquote>root@j5d # devfsadm –C</blockquote> Reconfigure tape device<br /><blockquote>root@j5d # cfgadm -c configure c5</blockquote><span style="color: rgb(255, 0, 0); font-weight: bold;"> if configure failed, try force update with command :</span><br /><blockquote>root@j5d # cfgadm –c configure –o force_update c5</blockquote>List PCI slot configuration information for tape drives<br /><blockquote>root@j5d # cfgadm –al</blockquote><blockquote>root@j5d # ls -l /dev/rmt/*cbn<br /></blockquote><blockquote><span style="font-size:78%;">lrwxrwxrwx 1 root root 71 Jan 7 15:39 /dev/rmt/0cbn -><br />../../devices//fp@0,0/st@xxxxxxxxxxxxxxxbe,0:cbn<br />.......<br />lrwxrwxrwx 1 root root 71 Jan 7 15:41 /dev/rmt/9cbn -><br />../../devices/fp@0,0/st@xxxxxxxxxxxxxxx82,0:cbn</span></blockquote><blockquote>root@j5d # /usr/sbin/rem_drv sg<br />root@j5d # /usr/bin/rm -f /kernel/drv/sg.conf<br />root@j5d # /usr/openv/volmgr/bin/driver/sg.install</blockquote><blockquote><br /><span style="font-size:78%;">Copied files to /kernel/drv and to /kernel/drv/sparcv9.<br />Doing add_drv of the sg driver<br />Removing old /dev/sg entries.<br />Editing /etc/devlink.tab...<br />Copying original /etc/devlink.tab to /etc/devlink.tab.01-07-08-15:44:06.<br />Added entry in /etc/devlink.tab file.<br />Made links in /dev/sg</span><br /></blockquote><blockquote>root@j5d # /usr/openv/volmgr/bin/scan</blockquote><blockquote><br /><span style="font-size:78%;">************************************************************<br />*********************** SDT_TAPE ************************<br />*********************** SDT_CHANGER ************************<br />*********************** SDT_OPTICAL ************************<br />************************************************************<br />------------------------------------------------------------<br />Device Name : "/dev/rmt/0cbn"<br />Passthru Name: "/dev/sg/c0txxxxxxxxxxxxxxxbel0"<br />Volume Header: ""<br />Port: -1; Bus: -1; Target: -1; LUN: -1<br />Inquiry : "IBM ULTRIUM-TD3 5BG2"<br />Vendor ID : "IBM "<br />Product ID : "ULTRIUM-TD3 "<br />Product Rev: "5BG2"<br />Serial Number: "XXXXXXXXXX"<br />WWN : "IBM ULTRIUM-TD3 XXXXXXXXXX"<br />WWN Id Type : 1<br />Device Identifier: "IBM ULTRIUM-TD3 XXXXXXXXXX"<br />Device Type : SDT_TAPE<br />NetBackup Drive Type: 16<br />Removable : Yes<br />Device Supports: SCSI-3<br />Flags : 0x0<br />Reason: 0x0<br />------------------------------------------------------------</span></blockquote></div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-7907479387332769102007-12-28T10:14:00.001+07:002008-01-21T14:07:51.618+07:00Logical Volume Manager [LVM] on RHEL 4<p><em>Logical Volume Manager (LVM) = Disk management to manage physical disks as logical volumes.</em></p><p><em>Volume = A device used for a filesystem, swap, or raw data. Without Logical Volume Manager, a volume would be either a disk partition or an entire disk drive.</em></p><p><em>Physical Volume (PV) = The standard partition that you add to the LVM.</em></p><p><em>Volume Group = a collection of logical volumes that are managed by Logical Volume Manager. </em></p><p><em>Logical Volume = Space that is defined within a volume group. A volume group is divided up into logical volumes. </em></p><p></p><p>Creating logical volumes on RHEL 4 :</p><p></p><div class="fullpost"><p></p><p>Add new hard drive or create X partitions if using single hard drive, and change partition type to linux lvm (8e) using <span style="color: rgb(255, 0, 0);">"fdisk"</span></p><p>Create physical volume</p><blockquote><p># pvcreate /dev/hda1</p><p># pvcreate /dev/hdb1</p></blockquote><p>Create volume group (vg)</p><blockquote># vgcreate vg0 /dev/hda1 /dev/hdb1 </blockquote><p>Check available volume group space </p><blockquote><p># vgdisplay -v</p></blockquote><p>Create logical volume (lv) on new VG (for example 200 MBytes)</p><blockquote><p># lvcreate -L 200M -n test vg0 </p></blockquote><p>Create file system for the new logical volume</p><blockquote># mkfs.ext3 /dev/vg0/test</blockquote><p>Create new directory to mount the logical volume</p><blockquote><p># mkdir /test</p></blockquote><p>Add new logical volume to <span style="color: rgb(255, 0, 0);">"/etc/fstab"</span> to make automaticly mount at system start and reboot the system or manually mount with :</p><blockquote># mount /dev/vg0/test /test</blockquote><p><br />Resizing Logical Volume on RHEL 4 :</p><p>Add new hard drive / partitionChange partition type to linux lvm (8e) using <span style="color: rgb(255, 0, 0);">"fdisk"</span></p><blockquote># vgextend vg0 /dev/hdc1</blockquote><p>Check available volume group space</p><blockquote><p># vgdisplay -v</p></blockquote><p>Add new free space to logical volume</p><blockquote><p># lvextend -L +50M /dev/vg0/test</p></blockquote><p>Resize filesystem (never used mkfs/mke2fs because it will be format all the logical volume)</p><blockquote># ext2online /dev/vg0/test</blockquote><p><br />Reducing logical volume on RHEL 4 :</p><p>Unmount any directories associated with the logical volume.</p><blockquote><p># umount /test</p></blockquote><p>Reduce the volume group</p><blockquote># resize2fs /dev/vg0/test 120M </blockquote><p>Reduce the logical volume</p><blockquote><p># lvreduce -L 120M /dev/vg0/test </p></blockquote><p>Mount again with the new size</p><blockquote># mount /dev/vg0/test /test </blockquote><p>Check status disk free.</p><blockquote># df -h<br /></blockquote><p></p><p>Removing Logical volumes on RHEL 4 :</p><p>Unmount any directories associated with the logical volume</p><blockquote># umount /dev/vg0/test</blockquote><p>Remove the logical volume with a command :</p><blockquote><p># lvremove /dev/vg0/test</p></blockquote></div><p></p>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-51980650031286404122007-12-11T10:50:00.000+07:002008-01-21T14:10:07.101+07:00IBM AIX as Netbackup 5.X SAN Media ServerInstalling NetBackup Media Server Agent for AIX.<br />Login as root. Mount the CD-ROM auto using the following methods:<br /><blockquote><span style="font-size:78%;"># smitty cdrfs "or" # smitty mountfs</span></blockquote>Mount the CD-ROM manually :<br /><blockquote># mkdir /cdrom<br /># mount -v cdrfs -r /dev/cd0 /cdrom<br /># cd /cdrom<br /># ./install</blockquote>Before start the configuration of Netbackup storage devices, make sure all the device tapes have been already recognized on the operating system level.<br /><blockquote># cfgmgr -v<br /># lsdev -Cc tape</blockquote>If the devices could not be found on the OS level do the following method :<div class="fullpost"><br />Check your installed version of Atape.driver<br /><blockquote># lslpp -l Atape.driver<br />Fileset Level State Description<br />----------------------------------------------------------------------------<br />Atape.driver 9.1.6.0 COMMITTED IBM AIX Enhanced Tape and Medium Changer Device Driver</blockquote>Un-install existing tape drive driver<br /><blockquote># installp -u Atape.driver</blockquote><blockquote>Installation Summary<br />--------------------<br />Name Level Part Event Result<br />-------------------------------------------------------------------------------<br />Atape.driver 9.1.6.0 USR DEINSTALL SUCCESS<br /></blockquote>Install new driver "atape" for AIX that compatible with your tape drives<br /><blockquote># installp -acXd /tmp/atape/Atape.10.3.5.0.bin Atape.driver<br />Installation Summary<br />--------------------<br />Name Level Part Event Result<br />-------------------------------------------------------------------------------<br />Atape.driver 10.3.5.0 USR APPLY SUCCESS# cfgmgr -v<br /># lsdev -Cc tape</blockquote>If netbackup still cannot detect the tape drives, re-start the server ....<br /><br />After all the device tapes have been already recognized on the operating system level :<br />Do "scan" from netbackup and make sure all tape drives has been successfully detect.<br /><blockquote># /usr/openv/volmgr/bin/scanSet media parameter Global Device :<br /># /usr/openv/volmgr/bin/vmglob -set_gdbhost "master" -h "master" --> master = master backup hostname</blockquote>Configure tape drives :<br /><blockquote># /usr/openv/volmgr/bin/tpautoconf -a --> automatic configure tape drives</blockquote>Stop all Netbackup process :<br /><blockquote># /usr/openv/netbackup/bin/goodies/netbackup stop "or" /usr/openv/netbackup/bin/goodies/netbackup/bp.kill_all</blockquote>Start all Netbackup process :<br /><blockquote># /usr/openv/netbackup/bin/goodies/netbackup start</blockquote>Check All Netbackup Process running well :<br /><blockquote># /usr/openv/netbackup/bin/bpps -a</blockquote>After completed the devices configuration, create the storage unit, volume pool, and backup policy.<br />Afterward test Backup and Restore.</div>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-89525385516924699702007-12-11T09:32:00.000+07:002007-12-14T12:15:55.096+07:00Troubleshooting Netbackup Error Status 57 on Solaris 10<span style=";font-family:arial;font-size:85%;" >Here is sample error from system log.<br /><blockquote style="font-family:courier new;"><span style="color: rgb(0, 0, 153);"># dmesg</span><br /><span style="color: rgb(0, 0, 0);">May 24 11:24:57 hostname inetd[467]: [ID 702911 daemon.warning] Configuration file /etc/inet/inetd.conf has been modified since inetconv was last run. "inetconv -i /etc/inet/inetd.conf" must be run to apply any changes to the SMF</span><br /><span style="color: rgb(0, 0, 0);">May 24 13:29:30 hostname last message repeated 1 time</span><br /></blockquote>Lists all Netbackup services currently installed, including their state and check services for netbackup.<br /><span style="color: rgb(0, 0, 153);font-family:courier new;" ><blockquote># svcs -a |grep bp</blockquote></span>Update /etc/inet/inetd.conf for Veritas Netbackup Services if do not exist.</span><span style="color: rgb(255, 0, 0);font-size:85%;" ><div class="fullpost"><span style=";font-family:arial;" ><blockquote style="font-family:courier new;"><span style="color: rgb(0, 0, 153);"># inetconv -i /etc/inet/inetd.conf </span><br /><span style="color: rgb(0, 0, 0);">inetconv: Notice: Service manifest for 100235/1 already generated as /var/svc/manifest/network/rpc/100235_1-rpc_ticotsord.xml, skipped</span><br /><span style="color: rgb(0, 0, 0);">bpcd -> /var/svc/manifest/network/bpcd-tcp.xml</span><br /><span style="color: rgb(0, 0, 0);">Importing bpcd-tcp.xml ...Done</span><br /><span style="color: rgb(0, 0, 0);">vnetd -> /var/svc/manifest/network/vnetd-tcp.xml</span><br /><span style="color: rgb(0, 0, 0);">Importing vnetd-tcp.xml ...Done</span><br /><span style="color: rgb(0, 0, 0);">vopied -> /var/svc/manifest/network/vopied-tcp.xml</span><br /><span style="color: rgb(0, 0, 0);">Importing vopied-tcp.xml ...Done</span><br /><span style="color: rgb(0, 0, 0);">bpjava-msvc -> /var/svc/manifest/network/bpjava-msvc-tcp.xml</span><br /><span style="color: rgb(0, 0, 0);">Importing bpjava-msvc-tcp.xml ...Done</span></blockquote></span><span style=";font-family:arial;" ><span style="color: rgb(0, 0, 0);">List again to make sure all Netbackup services currently installed, including their state.</span><br /><blockquote style="font-family:courier new;"><span style="color: rgb(0, 0, 153);"># svcs -a |grep bp</span><br /><span style="color: rgb(0, 0, 0);">online 13:36:01 svc:/network/bpcd/tcp:default</span><br /><span style="color: rgb(0, 0, 0);">online 13:36:11 svc:/network/bpjava-msvc/tcp:default</span></blockquote><span style="color: rgb(0, 0, 0);">Restart inetd daemon to re-read the configuration :</span><br /><blockquote style="font-family: courier new; color: rgb(0, 0, 153);"># /usr/bin/pkill -HUP inetd<span style="color: rgb(255, 0, 0);"></span></blockquote></span></div></span>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0tag:blogger.com,1999:blog-6453298071781942435.post-54597997228429851392007-12-10T14:41:00.000+07:002008-01-21T14:09:17.510+07:00Solaris as Netbackup 5.X SAN Media Server<span style="font-size:85%;"><span style="font-family:arial;">Install Netbackup Media Server Agent for Solaris<br />Before configure solaris as Netbackup SAN Media Server, make sure all the device tapes have been already recognized on the operating system level. </span><br /><span style="font-family:arial;">Check existing SCSI passthru drivers (sg driver) :</span><br /><blockquote style="font-family: courier new;"># /usr/sbin/modinfo | grep sg<br />92 78152ea7 16ea 97 1 sysmsg (System message redirection (fan)<br />124 78000000 1eb8 49 1 msgsys (System V message facility)<br />124 78000000 1eb8 49 1 msgsys (32-bit System V message facilit)<br /><span style="font-weight: bold; color: rgb(0, 0, 153);">147 102d7780 31cd 252 1 sg (SCSA Generic Revision: 3.5a)</span></blockquote><span style="font-family:arial;">Remove existing SCSI passthru drivers (sg driver) if available :</span><br /><blockquote><span style="font-family:courier new;"># /usr/sbin/rem_drv sg</span><br /><span style="font-family:courier new;"># /usr/sbin/modinfo | grep sg <span style="font-weight: bold; color: rgb(0, 0, 153);">--> make sure the driver has been unload</span></span><br /><span style="font-family:courier new;"> 92 78152ea7 16ea 97 1 sysmsg (System message redirection (fan)</span><br /><span style="font-family:courier new;">124 78000000 1eb8 49 1 msgsys (System V message facility)</span><br /><span style="font-family:courier new;">124 78000000 1eb8 49 1 msgsys (32-bit System V message facilit)</span></blockquote></span><span style="color: rgb(255, 0, 0);font-size:85%;" ><div class="fullpost"><span style="color: rgb(0, 0, 0);font-family:arial;" >Backup drive configuration before replace to the new one :</span><br /><blockquote style="font-family: courier new; color: rgb(0, 0, 0);"># cp /kernel/drv/sg.conf /kernel/drv/sg.conf_old<br /># /usr/bin/rm -f /kernel/drv/sg.conf<br /></blockquote><span style="color: rgb(0, 0, 0);font-family:arial;" >Install sg driver :</span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/volmgr/bin/driver/sg.install</blockquote></span><span style="color: rgb(0, 0, 0);font-family:arial;" >Reconfigure target and lun server to cover all backup hardware (tape drives).</span><br /><span style="font-weight: bold; color: rgb(0, 0, 0);font-family:arial;" >Note : This command must be run on directory "/usr/openv/volmgr/bin/driver"</span><br /><blockquote><span style="color: rgb(0, 0, 0);font-family:courier new;" ># cd /usr/openv/volmgr/bin/driver</span><br /><span style="font-family:courier new;"><span style="color: rgb(0, 0, 0);"># /usr/openv/volmgr/bin/sg.build all -mt 10 -ml 1</span> <span style="color: rgb(0, 0, 153);">--> for 10 target(drive) and 1 lun</span></span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;" >The file ./st.conf should be appended to /kernel/drv/st.conf.</span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;" >A reboot may be necessary to create any new device files.</span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;" >Created file ./sg.conf.</span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;" >Created file ./sg.links.</span><br /></blockquote><span style="color: rgb(0, 0, 0);font-family:arial;" >Remove existing content of <span style="font-weight: bold; color: rgb(255, 0, 0);">"/kernel/drv/st.conf"</span>, and replace with content <span style="font-weight: bold; color: rgb(255, 0, 0);">"/usr/openv/volmgr/bin/driver/st.conf"</span></span><br /><span style="color: rgb(0, 0, 0);font-family:arial;" >Make sure all directory and link for new tape drives has been automaticly created after the driver instalation (sg install).</span><br /><span style="color: rgb(0, 0, 0);font-family:arial;" ><blockquote style="font-family: courier new;"># ls -l /dev/rmt/*cbn</blockquote>Do "scan" from netbackup to check the drives has been detect by netbackup.</span><br /><span style="color: rgb(0, 0, 0);font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/volmgr/bin/scan</blockquote></span><span style="color: rgb(0, 0, 0);font-family:arial;" >If the tape drives has not detect by netbackup, remove sg driver and install again to re-read (refresh) the configuration.</span><span style="color: rgb(0, 0, 0);"><div class="fullpost"><blockquote style="font-family: courier new;"># /usr/sbin/rem_drv sg <br /># /usr/bin/rm -f /kernel/drv/sg.conf<br /># /usr/openv/volmgr/bin/driver/sg.install</blockquote><span style="font-family:arial;"> "scan" again and make sure all tape drives has been successfully detect.</span><br /><span style="font-family:arial;">If netbackup still cannot detect the tape drives, re-start the server ....</span><br /><span style="font-family:arial;">Set parameter Global Device :</span><br /><span style=";font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/volmgr/bin/vmglob -set_gdbhost "master" -h "master" <span style="color: rgb(0, 0, 153);">--> master = master backup</span> hostname</blockquote></span><span style="font-family:arial;">Configure tape drives</span> :<br /><span style="font-family:courier new;"><blockquote><span style="font-size:78%;"># /usr/openv/volmgr/bin/tpautoconf -a </span><span style="color: rgb(0, 0, 153);font-size:78%;" >--> automatic configure tape drives</span></blockquote><span style="color: rgb(0, 0, 153);"></span></span><span style="font-family:arial;">Stop all Netbackup process :</span><br /><span style=";font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/netbackup/bin/goodies/netbackup stop "or" #/usr/openv/netbackup/bin/goodies/netbackup/bp.kill_all</blockquote></span><span style="font-family:arial;">Start all Netbackup process</span><br /><span style=";font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/netbackup/bin/goodies/netbackup start</blockquote></span><span style="font-family:arial;">Check All Netbackup Process running well.</span><br /><span style=";font-family:courier new;font-size:78%;" ><blockquote># /usr/openv/netbackup/bin/bpps -a</blockquote></span><span style="font-family:arial;">After completed the devices configuration, create the storage unit, volume pool, and backup policy. Afterward test Backup and Restore.</span></div></span></div></span>j5dhttp://www.blogger.com/profile/02174688521396212586noreply@blogger.com0