11-04-2010
perl script for generates a report for backup times
Hi all,
we do have daily oracle database backups and i need to generate report of each database start point and end point
we are using netapp snapshot(filer level) for backups.
all backups logs will be come in one directory
/u01/app/oracle/backup/hostname/log/*
here hostname=usadc*
for each host we have n number of databases
suppose i have hostname usadc01 and i have 5 databases residing in this and i take any one database say test
/u01/app/oracle/backup/usadc01/log/ in this path i will get 2 files for this database test.begin and test.end in these 2 files i will get database backup bagin time(test.begin) and database end time(test.end) here i need to parse these 2 files to take timestamp and need to direct to some file
and we have 40 servers and 300 databases
all servers will start from usadc in the path /u01/app/oracle/backup/
so in a loop i need to go one by one directory and for each server i need to go the path /u01/app/oracle/backup/usadc01/log/ here there will be n no of databases and for each database there will be 2 log files (*.begin and *.end) and i need to take the timestamp of these 2 files and need to direct to some file
i think this can be achived by perl it seems
is anybody there to advice me how i can go ahead.
appreciated a lot for help
thanks
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
Let me know how to write a script that
runs a <a backup command> to check the backups of a particular client
from the last_night & today' dates
and print the out. (2 Replies)
Discussion started by: new2prog
2 Replies
2. UNIX for Advanced & Expert Users
I have a C++ program, running on Fedora Linux, which has to be able to update itself to a new version, which it can obtain from a server. The way I do this is to have it create a shell script which kills it (the parent process), uninstalls it, downloads the new version (actually it does this... (1 Reply)
Discussion started by: BrandonShw
1 Replies
3. Shell Programming and Scripting
Hi, im trying to make a script that backups mysql databases but apparently I am having trouble with the variables, or simply something I am missing.
Would appreciate any help, here is the script
#!/usr/bin/perl -w
use strict;
require File::Spec;
#VARIABLES
my $databasename =... (4 Replies)
Discussion started by: Fireline
4 Replies
4. Solaris
Hi
A file is generated/created/modified during installation (or) execution of a script.
vice versa..How to find out which script is responsible for creating/modifying a file.
Example:- ....An existing file ( hosts.ulcm ), this file is created or modified by running a script ( may be... (1 Reply)
Discussion started by: frintocf
1 Replies
5. Shell Programming and Scripting
Hello,
I have a large amount of data with the following structure:
Word=Transliterated word
I have written a Perl Script (reproduced below) which goes through the full file and identifies all dupes on the right hand side. It creates successfully a new file with two headers: Singletons and Dupes.... (5 Replies)
Discussion started by: gimley
5 Replies
6. Shell Programming and Scripting
Hello all,
I would like to create a for loop or whatever is quick that will print the one’s place of a number for 1-N times
say for example a printed page formatting is 132 characters wide,
I would like a single line
123456789012345678901234567890... ...012
That is 132 characters long. I... (11 Replies)
Discussion started by: KmJohnson
11 Replies
7. Shell Programming and Scripting
Hi,
I have a perl script to read the log file and create a report from it. I have the script file and log file in a different directories. Now i have pipe the log file data to the perl script to create the report (HMTL file). I am using the below command this isn't working
tail -f... (4 Replies)
Discussion started by: vel4ever
4 Replies
8. UNIX for Dummies Questions & Answers
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 (0 Replies)
Discussion started by: Niharika Srivas
0 Replies
9. UNIX for Dummies Questions & Answers
hi I have a script with HTML code and am currently generating the html page everytime using genWebsite.sh > startPage.html
Is it possible to have a loop at the begining of the script to run this command every minute so an updated HTML page is displayed or could someone suggest an alternative... (2 Replies)
Discussion started by: scriptnewbie
2 Replies
LEARN ABOUT CENTOS
db2bak
DB2BAK(8) System Manager's Manual DB2BAK(8)
NAME
db2bak - Directory Server script for making a backup of the database
SYNOPSIS
db2bak [archivedir] [-Z serverID] [-q] [-h]
DESCRIPTION
Creates a backup of the database. This script can be executed while the server is running or stopped.
OPTIONS
A summary of options is included below:
archivedir
The full path to the directory to store the backup.
-Z Server Identifier
The server ID of the Directory Server instance. If there is only one instance on the system, this option can be skipped.
-q
Quiet mode. Reduces output of task.
-h
Display the usage.
EXAMPLE
db2bak -Z instance2
Makes a backup of the entire database for 'instance2', and stores it in the default server instance backup directory.
db2bak /LDAP/backups/20130305
Creates a backup of the database and stores it in specified location.
DIAGNOSTICS
Exit status is zero if no errors occur. Errors result in a non-zero exit status and a diagnostic message being written to standard error.
AUTHOR
db2bak was written by the 389 Project.
REPORTING BUGS
Report bugs to http://bugzilla.redhat.com.
COPYRIGHT
Copyright (C) 2013 Red Hat, Inc.
Mar 5, 2013 DB2BAK(8)