Oracle Data BackUp with Help Of Perl Post: 302691285

Login or Register to Ask a Question and Join Our Community

Sponsored Content

Top Forums Shell Programming and Scripting Oracle Data BackUp with Help Of Perl Post 302691285 by parthmittal2007 on Friday 24th of August 2012 06:43:25 AM

Old

08-24-2012

Banned

Is there any function to export the table in Perl

parthmittal2007

View Public Profile for parthmittal2007

Find all posts by parthmittal2007

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help with oracle backup script

I have written a script to perfrom a cold backup on an oracle database. The script is failing everytime. Can anyone tell me what (stupid) error I am making. The output from the uname command follows Linux rayora 2.2.14-6.1.1smp #1 SMP Thu Apr 13 19:55:55 EDT 2000 i686 unknown The error...

2. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe...

3. Shell Programming and Scripting

How to incrementally backup data & use most recent data

Hey, dunno if the title really explains this well; basically my problem is (and this is on a router which is why the flash issue)... I have some data I want to store (it's really irelevant, i'm just counting the lines per file, basically a simple counter). I could store this data in flash but...

4. Shell Programming and Scripting

Get data from 3 differrnt oracle DB & then compare data

Hi All, I have a requirement to write a shell script for the following... we have 3 different database.... lets say A, B, C From these 3 DBs, i need to get data.. all have 3 different table...a,b, c A.a => Emp_code, count(*) B.b => emp_code, count(*) C.c => emp_code, copunt(*) Once get this...

5. Shell Programming and Scripting

Perl connect to remote oracle db without local oracle installation

I want to use Perl to connect to a remote Oracle DB I have no oracle installation on my server (and dont plan on installing one) I am using solaris 9 on x86 server. Is this possible? I basically want to run some basic sql queries on the remote oracle db which I have access to using perl on my...

6. Shell Programming and Scripting

Help with sed in Oracle DB backup script.

I have a script like this .. #!/bin/ksh database=$(echo $@ | sed 's/.*-S \(*\).*/\1/') instance=$(grep "$database" /var/opt/oracle/oratab | awk -F : '{print $1}') command=$(echo $@ | sed 's/"$database"/"$instance"/') echo $command when I tried to execute the script like this ... ksh...

7. Shell Programming and Scripting

Cold backup oracle and Restore to new db

Hello All, I am very new to Linux i have assignment to take offline backup in linux and restore it to new database oracle 10g? Help me out any script of it and steps i will be very thankful Regards, Sameer

8. Shell Programming and Scripting

Oracle Data BackUp with Help Of Perl

Hi All I am able to connect my oracle database with Perl and able to execute the queries. There is one schema names master19 which contains 50 table. I want to take backup of each table in and store at a given directory location in Perl For example suppose if a table student is present in...

9. UNIX for Dummies Questions & Answers

I need perl script on cold backup in Oracle 10 g

Hi , I am new to Perl script.Can u please provide me perl scripts for the following: 1. Perl script on Cold backup in Oracle 10g 2.Perl script on Hot backup in Oracle 10g

LEARN ABOUT SUNOS

export

asadmin-export(1AS)						   User Commands					       asadmin-export(1AS)

NAME

       asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode

SYNOPSIS

       export  [ name=value  [ name=value]*]

       Marks  a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
       as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable  name	is
       displayed.  If  the  export  command  is  used  without	any arguments, a list of all the exported variables and their values is displayed.
       Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and  set  as  exported  variables
       within asadmin. Unexported environment variables cannot be read by the asadmin utility.

OPERANDS

       name=value	       variable name and value for automatic export to the environment to be used by subsequent commands.

       Example 1: Using export to list the environment variables

       asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
       asadmin> export AS_ADMIN_PREFIX=server1.jms-service
       asadmin> export //to list the environment variables that are set
       AS_ADMIN_HOST=bluestar
       AS_ADMIN_PORT=8000
       AS_ADMIN_USER=admin
       AS_ADMIN_PASSWORD=********
       AS_ADMIN_PREFIX=server1.jms-service

       Where:  the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
       is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-unset(1AS), asadmin-multimode(1AS)

J2EE 1.4 SDK							    March 2004						       asadmin-export(1AS)