Sponsored Content
Top Forums Shell Programming and Scripting moving files from a dir in one machine to a dir in another machines Post 302440508 by mathews on Tuesday 27th of July 2010 11:12:55 AM
Old 07-27-2010
Thanks.But that is not what I am looking for. I will be getting the list of READ WRITE files that need to be moved by -

#!/bin/ksh
sqlplus -s "/ as sysdba" <<EOF>W1KK_dbfiles.txt
set heading off feedback off verify off
SELECT name FROM v$datafile WHERE ENABLED='READ WRITE';
exit;
EOF

the database w1kk is on a machine, say m1 and the database w2kk is on another machine, say m2. The directory structures where the datafiles are located are almost the same. On machine m1 it is-
/u01/oradata/w1kk
/u02/oradata/w1kk
/u03/oradata/w1kk
..
..
..

and on machine m2, it is
/u01/oradata/w2kk
/u02/oradata/w2kk
/u03/oradata/w2kk
..
..
..


Once I identify the files that need to be scp-ed, I need to move the file
/u01/oradata/w1kk to /u01/oradata/w2kk
/u02/oradata/w1kk to /u02/oradata/w2kk
/u03/oradata/w1kk to /u03/oradata/w2kk

I tried to use sed to replace the w1kk to w2kk bu it didnt work. I just didn't know how to do it. This is what I tried with sed -

#!/bin/ksh
sqlplus -s "/ as sysdba" <<EOF>W1KK_dbfiles.txt
set heading off feedback off verify off
SELECT name FROM v$datafile WHERE ENABLED='READ WRITE';
exit;
EOF

for i in `cat W1KK_dbfiles.txt`
do
echo $i
echo `sed 's/W1KK/W2KK/g' $i `
done


This is wrong because - it tells me it doesn't identify $i as a file and second, it loops through the W1KK_dbfiles.txt for all the records, instead of using sed to act on each line of the file. I am just lost. Can someone please help?

Last edited by mathews; 07-27-2010 at 02:32 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Moving file(s) from dir to dir

Hi, I am fairly new to writing scripts. I am trying to write a script that moves either One or All of the files from one directory to another. I know how to make the actual command to do it, but i don't quite know how to add operators to it, ie -i or -a. I want -i to move one file from... (4 Replies)
Discussion started by: SirJoeh
4 Replies

2. Shell Programming and Scripting

need to move files of particular day from one dir to another dir

Hi, I have hundered's of files of the name CMP_PORT_IN_P200903271623042437_20090328122430_err.xml in error directory of todays date ie 20090328 and in the file name 5th field specifies date only now i want to move all files of 20090328 to another directory i.e reprocess directory. So... (3 Replies)
Discussion started by: ss_ss
3 Replies

3. Shell Programming and Scripting

moving dir subdir and files

I have created a directory structure and under the directory subdirectories and files are there.I need to move the entire thing to another path.How can i write a script to do that. currently the path of files is as below : /data1/serial/mcycle/archive : under this path differnt sub dir exist ... (6 Replies)
Discussion started by: dr46014
6 Replies

4. Shell Programming and Scripting

A script to find dir, delete files in, and then del dir?

Hello!! I have directories from 2008, with files in them. I want to create a script that will find the directoried from 2008 (example directory: drwxr-xr-x 2 isplan users 1024 Nov 21 2008 FILES_112108), delete the files within those directories and then delete the directories... (3 Replies)
Discussion started by: bigben1220
3 Replies

5. UNIX for Dummies Questions & Answers

get all files under specified dir and zip them, then transfer to another machine

Hi guys, now, I have the following requirement: 1. Get all files under specified directory 2. the files modify date should be specified date 3. zip these files 4. transfer these files to another machine, assume ip, user and password are given. could you pls provide good solution for... (1 Reply)
Discussion started by: crest.boy
1 Replies

6. UNIX for Dummies Questions & Answers

How to list all files in dir and sub-dir's recursively along with file size?

I am very new to unix as well as shell scripting. I have to write a script for the following requirement. In have to list all the files in directory and its sub directories along with file path and size of the file Please help me in this regard and many thanks in advance. (3 Replies)
Discussion started by: nmakkena
3 Replies

7. Shell Programming and Scripting

Need a script to move the files from one dir to other other dir

Need a script to move the files from one dir to other dir and at the same time it has to read the log in the source dir. Please help me ASAP. (4 Replies)
Discussion started by: viswanathkishor
4 Replies

8. Shell Programming and Scripting

Copy files and subdirs from dir to a new dir

Hello Comunity I am trying to make a bash shell script that it copies files and subdirs(with files) to a new dir. I would like the dest_dir to contain only subdirectories with files not other subdirs inside. it called : cpflatdir src_dir dest_dir Pleaze help me! Thank you in... (2 Replies)
Discussion started by: BTKBaaMMM
2 Replies

9. Shell Programming and Scripting

KSH - Find paths of multiple files in CC (dir and sub-dir))

Dear Members, I have a list of xml files like abc.xml.table prq.xml.table ... .. . in a txt file. Now I have to search the file(s) in all directories and sub-directories and print the full path of file in a output txt file. Please help me with the script or command to do so. ... (11 Replies)
Discussion started by: Yoodit
11 Replies

10. AIX

Assign read write permission to the user for specific dir and it's sub dir and files in AIX

I have searched this quite a long time but couldn't find the right method for me to use. I need to assign read write permission to the user for specific directories and it's sub directories and files. I do not want to use ACL. I do not want to assign user the same group of that directories too.... (0 Replies)
Discussion started by: blinkingdan
0 Replies
Permissions(4)						     Kernel Interfaces Manual						    Permissions(4)

NAME
Permissions - Contains information about the permissions that remote computers have with respect to login, file access, and command execu- tion SYNOPSIS
/usr/lib/uucp/Permissions DESCRIPTION
The /usr/lib/uucp/Permissions file contains information about the ways in which the remote computers listed in the Systems file are allowed to carry out uucico and uuxqt transactions with a local system. Be aware that entries in a Permissions file do not affect a remote system user with a valid login on the local computer. Note that you must have root user authority to edit the Permissions file, which is owned by the uucp login ID. The Permissions file has two types of entries: LOGNAME specifies the permissions that take effect when a remote system logs in. These entries begin with LOGNAME. MACHINE specifies permissions that take effect when your system calls a remote system. These entries begin with MACHINE. Both type of entries consist of option-value pairs. You can have as many of these option-value pairs as you want and can write entries for all or only some of the remote sites. Options Specifies whether the remote system can request to set up file transfers from your system. The default is not to allow such requests. This option can be used in either LOGNAME or MACHINE entries. Specifies whether your system can send the work queued for the remote system when the remote system initiates the call. The default is call; that is, the queued files are sent only when the local system calls the remote system. This option is used in LOGNAME entries. Spec- ifies from which directories uucico can read. The default is the /usr/spool/uucppublic directory. This option can be used in either LOGNAME or MACHINE entries. If multiple pathnames are specified, separate them with a colon (:). Specifies to which directories uucico can write. The default is the /usr/spool/uucpublic directory. This option can be used in either LOGNAME or MACHINE entries. If multiple pathnames are specified, separate them with a colon (:). Specify exceptions to the READ and WRITE options. These options can be used in either LOGNAME or MACHINE entries. If multiple pathnames are specified, separate them with a colon (:). Specifies the commands that a remote system can request to be executed on the local system. The default is rmail command. If multiple commands are specified, separate them with a colon(:). This option is used in MACHINE entries. Specifies whether any transactions can occur without the local system calling the remote system. The default is no, that is, the local system must initiate the call to the remote system before any transactions are allowed. If both the remote and local systems use CALLBACK, they will not be able to initiate any jobs. This option can be used in LOGNAME entries. Used to verify the calling system's identity. The values for this option should be the system name or the names of systems allowed to log in using the name specified by LOGNAME. If a system other than those specified in VALIDATE tries to use the name specified by LOGNAME, the connection will be refused. If multiple systems are specified, separate them with a colon (:). This option is used with the LOGNAME entries. Rules for Writing Permissions File Entries The following rules apply for writing Permissions file entries: Each option-value pair has the following format: option=value Blank spaces are not allowed before or after the equal sign. A blank space is used to separate option-value pairs. If an option has one or more values, the values are separated with a colon. Comment lines begin with a number sign (#) and end with a new line. The backslash () is used as a continuation character to continue a line on to the next line on the screen. Blank lines are ignored. All login IDs used by remote systems must appear in one and only one LOGNAME entry. If you do not want to grant permissions to each system by name, the entry MACHINE=OTHER will assign permissions to any system not mentioned by name. You can combine MACHINE and LOGNAME entries into a single entry if the options are the same. EXAMPLES
The following example allows remote system buck to log in with login ID Luucp1. The VALIDATE option means that the login ID uucp1 can only be used by remote system buck. The REQUEST option means that remote system buck can request files to be transferred from the local system. The SENDFILES option means that any requests queued on the local system for work on the remote system will be sent to the remote system during the current session if allowed by remote system buck. The READ and WRITE options mean that remote system can read and write from and to any directory that has proper permissions. LOGNAME=uucp1 REQUEST=yes SENDFILES=yes VALIDATE=buck READ=/ WRITE=/ MACHINE=buck REQUEST=yes COMMANDS=ALL READ=/ WRITE=/ The following example has all the default values of the options, which are as follows: REQUEST=no, SENDFILES=call READ and WRITE=/usr/spool/uucppublic COMMANDS=rmail CALLBACK=no The remote system cannot ask to receive any queued files containing work that users on the local system have requested to be exe- cuted on the remote system. The local system cannot send queued work to the remote system when that system has completed its current operations. Instead, the queued work can be sent only when the local system contacts the remote system. The remote system can send (write) files to and transfer (read) files from only the uucp public directory (/usr/spool/uucppublic/system_name) on the local sys- tem. Users on the remote system can execute only the default command (rmail) on the local system. LOGNAME=uucp2 MACHINE=buck:bigguy The following example is similar to the first. However, this entry allows the remote users of sys- tems waldo and buck to execute only the rmail and /usr/lbin/rnews commands: LOGNAME=uucp3 VALIDATE=waldo:buck REQUEST=yes SENDFILES=yes READ=/ WRITE=/ MACHINE=waldo:buck REQUEST=yes COM- MANDS=rmail:/usr/lbin/rnews READ=/ WRITE= The following example specifies that all remote systems using the uucp4 login ID that are not included in existing MACHINE entries can execute the rmail (mail) and /usr/bin/lint commands on the local system: LOGNAME=uucp4 MACHINE=OTHER COMMANDS=rmail:/usr/bin/lint The following example shows how the MACHINE and LOGNAME entry can be com- bined into one entry. The remote host is darla. The remote system darla should use the login ID xuucp to log in to local system. The rest of the options have the same meaning as explained in the first example. MACHINE=darla LOGNAME=xuucp READ=/ WRITE=/ REQUEST=yes SENDFILES=yes FILES
Contains all the configuration files for the UNIX-to-UNIX Copy Program (UUCP), including the Devices file. Describes accessible remote systems. RELATED INFORMATION
Files: Systems(4) delim off Permissions(4)
All times are GMT -4. The time now is 05:33 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy