General issues

[SAMIR SHAH_1]

Hi freinds,

1. If in Oracle my database is in Archivelog mode, how I can setup in such a way that all the ARCH files are directly copied on to the DAT/DLT media instead of hard disk.

2. How to take the printing on to the local printer connected with Desktop PC in Unix.

3. How can I assign points in this forum to you people. I do not get any such button on my screen.

Thanks.

Samir.

[Steven Sim Kok Leong]

Hi,

You can run a script in the background to perform a background tar-ing of any new archive files to tape.

You can refine this script further to tailor to your needs such as grep'ing for the last archived number from the $BACKUPLOG each time you run the script so that the next archive log in line is backed up.

archbackup.sh
=============================================
#!/sbin/sh
index=1 # replace it with the starting number
BACKUPLOG=/var/adm/sa/logs/archivebackups.log

touch $BACKUPLOG
cd /$oraclesid/arch #replace it with your archive directory path

while :;
do
if [ -e ${oraclesid}_${index}.dbf ]
then
tar uvf /dev/rmt/0m $oraclesid_$index.dbf
if [ "$?" == "0" ]
then
echo "Backup of $oraclesid_$index.dbf archive log successful at `date +%Y%m%d` `date +%H%M`" >> $BACKUPLOG
else
echo "Backup of $oraclesid_$index.dbf archive log NOT successful at `date +%Y%m%d` `date +%H%M`" >> $BACKUPLOG
fi
index=`expr $index + 1`
fi
done
=============================================

Hope this helps. Regards.

Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com

[Andreas D. Skjervold]

Hi Samir
Management of your archived redologs can be done using Recovery Manager (RMAN) supplied with Oracle.
RMAN can be set up to backup data to a local tape using Legato Storage Manager (also supplied with Oracle)
RMAN will then backup the archived redologs to the tape and then delete the original file, freeing up space on the archive disk (ensuring that the database don't stop).

Here is a sample script:
(backing up to another disk)
RMAN>run {
allocate channel c1 type disk
format '/backup/al_%d_%s_%p';
backup (archivelog all delete input);
release channel c1;
}

(backing up to tape)
RMAN>run {
allocate channel c1 type 'SBT_TAPE';
backup (archivelog all delete input);
release channel c1;
}


Andreas

[James R. Ferguson]

Hi:

To assign points to responses, you must login to see the appropriate buttons. There is a bug that is probably not yet resolved. Shayne, the Forum's administrator, notes (on 02/12/2001 in:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x6bb2854994d9d4118fef0090279cd0f9,00.html

/Begin_Quote/

If you login from the Forums home page (forums.itrc.hp.com), the page will display correctly (with header and left navigation bar) and you will be able to assign points to questions.

If you login from a family page (i.e. HP-UX), you will not see the assign button and the page will not display correctly.

/End_Quote/

This should answer the "points" question you raised. BTW, thank you for being so attentive to this. Points are the bread crumbs that point the travelers to the best information later.

Regards!

...JRF...

[Rita C Workman]

Doesn't look like anybody touched on the printing question...so I'm gonna take a try at this.
From what you describe..you have a printer simply connected via the lpt port on the PC. That is a problem.
If this were a network printer, it would be simple. Just add the network printer via SAM or JetAdmin on HPUX side and you could route printing to it. But since I believe this is not a network printer...you may need to set up a means to map from your PC to UNIX for what you want. Now I understand SAMBA works well for doing this....and since you connecting from the PC side to UNIX, I '..believe...' your default printer would be the one you want.
You can get SAMBA (free) from the HPUX Porting Site:
http://hpux.cs.utah.edu/ or www.samba.org

/rcw

....oooh!!! thought of another way too..If this printer is not something you could add a JetDirect card to, there was something I used once called Lantronix. It worked similar to HP's jetdirect external, but you could attach it to just about any printer, then plug them into a network and make them network printers. So now you have options... http://www.lantronix.com/products/

[Ajay Sishodia]

IF you have a X11 server runing on your PC, like eXceed or someting than you can start the lpd deamon on your pc and than configure a print queue on the HP machine using SAM. just remember to name the queue as unix_printername and click on the BSD printer option.

happy printing!
Ajay