topic Re: Scripting help reqd in Operating System - HP-UX

Scripting help reqd

ShivKumar_1 — Mon, 05 Apr 2004 16:24:18 GMT

Hi guys,
I have a set of files in a directory they are archieves from Oracle for eg;
*********************************************
/oracle/TRN/saparch
#ls -ltr
PRDarch1_32690.dbf
PRDarch1_32691.dbf
PRDarch1_32692.dbf
**********************************************
What I want to do is to rename the first 3 characters ie "PRD" to "TRN" and the rest of the things would remain the same so the out put would be

TRNarch1_32690.dbf
TRNarch1_32691.dbf
TRNarch1_32692.dbf

Is there a way to script it out?

Thnks
SK

Re: Scripting help reqd

Victor Fridyev — Mon, 05 Apr 2004 16:36:46 GMT

Hi,
Try the following:
#!/usr/bin/sh
cd DIRN
OLD=PRD
NEW=TRN

ls -1 ${OLD}*| while read FILENAME; do
NEWN=$(echo $FILENAME|sed "s/^$OLD/$NEW/")
mv $FILENAME $NEWN
done

Re: Scripting help reqd

A. Clay Stephenson — Mon, 05 Apr 2004 16:44:15 GMT

Of course there is a way to script this but I think it does you more harm than good to give you a full solution. This is really basic scripting that any admin should learn to do:

I'll get you started:

cd /oracle/TRN/saparch
ls PRDarch*.dbf | while read X
do
NEW=$(echo "${X}" | sed 's/^PRD/TRN/')
echo "${X} -> ${NEW}"
mv "${X}" "${NEW}"
done

I would probably add some testing to make sure that the new files does not already exist before doing the mv. The quotes are important because your filenames might contain whitespace.

Re: Scripting help reqd

Marvin Strong — Mon, 05 Apr 2004 16:47:09 GMT

something like this should do it.

for prd in `ls /oracle/TRN/saparch`
do
trn=`echo $prd | sed 's/PRD/TRN/'`
mv $prd $trn
done

Re: Scripting help reqd

ShivKumar_1 — Mon, 05 Apr 2004 16:48:08 GMT

Hi guys
Thnks for the quick response.

Pl close this form.

Re: Scripting help reqd

Bart Paulusse — Tue, 06 Apr 2004 04:02:27 GMT

Is this realy what you want to do?
These are oracle's offline redolog files.
Changeing their name will make them invisible for oracle in case you need to recover your database.
Also the SAP tool brarchive won't be able to back them up.
If you've renamed your database/SAP instance you should also adjust the naming of you offline redo logfiles in $ORACLE_HOME/dbs/init.ora :

log_archive_dest='/oracle/TRN/oraarch/TRNarch'

regards,

Bart

Re: Scripting help reqd

ShivKumar_1 — Tue, 06 Apr 2004 11:56:07 GMT

Hi bart,
Thnks for your suggestion. The thing is we are doing a rcp from our production server to another server. So , the names need to be different in another system.

Thnks
SK

Re: Scripting help reqd

Bart Paulusse — Wed, 07 Apr 2004 03:59:39 GMT

Hi,

if you've renamed your database after the rcp to oyou will have pen your database with the RESETLOGS option. This means that old offline redolog files are unuseable.

If this is the case you can delete the old offline redologfiles instead of renaming them.

regards,

Bart