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.
Hi Unix Shell Script Expert,
We have a robust shell script (from old time) for our 9i database hot backup but generated error:
Shell Script Content:
#check for auto log mode and redirect as early as possible
#
autolog_enable $AUTOLOG_MODE $ORACLE_BASE/${ORASID_LOW}log/cron_hotbackup.log... (1 Reply)
Hi,
I have a script which we use to take hot backup of oracle database.It connects to database and saves all database related activities in a spool file.Then the spool file is run for taking hot backup. But at one stage it is giving an error.
Please find my hot backup script as below:
... (2 Replies)
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... (5 Replies)
We have omni backup of oracle database about 40Gb, tablespaces are distributed over 2 partitions . But because of some reason both partition are not available more .
Now we are in need to restore the entire data on new partitions .Can any guru's confirm if tried so earlier will this going to... (1 Reply)
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 (0 Replies)
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... (1 Reply)
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... (3 Replies)
Hi i need a command to cut the last column from the location in a file and want write a
gzip command like
cat a.txt
/data01/oracle/oradata/vas/data/system01.dbf
/data01/oracle/oradata/vas/data/sysaux01.dbf
/data01/oracle/oradata/vas/data/undotbs01.dbf... (3 Replies)
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)
Hello All,
I need immediate help in creating shell script to call archivebkup.ksh script when archive file system capacity reaches threshold value or 60%
Need to identify the unique file system that reaches threshold value.
ex:
capacity
... (4 Replies)
Discussion started by: sasikanthdba
4 Replies
LEARN ABOUT REDHAT
backup_dbverify
BACKUP_DBVERIFY(8) AFS Command Reference BACKUP_DBVERIFY(8)NAME
backup_dbverify - Checks the integrity of the Backup Database
SYNOPSIS
backup dbverify [-detail] [-localauth]
[-cell <cell name>]
[-help]
backup db [-d] [-l] [-c <cell name>] [-h]
DESCRIPTION
The backup dbverify command checks the integrity of the Backup Database. The command's output indicates whether the Backup Database is
damaged (data is corrupted) or not. If the Backup Database is undamaged, it is safe to continue using it. If it is corrupted, discontinue
any backup operations until it is repaired.
CAUTIONS
While this command runs, no other backup operation can access the Backup Database; the other commands do not run until this command
completes. Avoid issuing this command when other backup operations are likely to run. The backup savedb command repairs some types of
corruption.
OPTIONS -detail
Reports the number of orphaned blocks found, any inconsistencies, and the name of the server machine running the Backup Server that is
checking its copy of the database.
-localauth
Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The backup command interpreter presents it to
the Backup Server, Volume Server and VL Server during mutual authentication. Do not combine this flag with the -cell argument. For more
details, see backup(8).
-cell <cell name>
Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see backup(8).
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The command displays one of the following two messages:
Database OK
The database is undamaged and can be used.
Database not OK
The database is damaged. You can use the backup savedb command to repair many kinds of corruption as it creates a backup copy. For
more detailed instructions, see the OpenAFS Administration Guide chapter about performing backup operations.
The -detail flag provides additional information:
o The number of orphan blocks found. These are ranges of memory that the Backup Server preallocated in the database but cannot use.
Orphan blocks do not interfere with database access, but do waste disk space. To free the unusable space, dump the database to tape by
using the backup savedb command, and then restore it by using the backup restoredb command.
o Any inconsistencies in the database, such as invalid hostnames for Tape Coordinator machines.
o The name of the database server machine on which the Backup Database was checked, designated as the "Database checker". For a detailed
trace of the verification operation, see the /var/log/openafs/BackupLog file on the indicated machine. You can use the bos getlog
command to display it.
EXAMPLES
The following command confirms that the Backup Database is undamaged:
% backup dbverify
Database OK
The following command confirms that the Backup Database is undamaged and that it has no orphan blocks or invalid Tape Coordinator entries.
The Backup Server running on the machine "db1.abc.com" checked its copy of the Database.
% backup dbverify -detail
Database OK
Orphan blocks 0
Database checker was db1.abc.com
PRIVILEGE REQUIRED
The issuer must be listed in the /etc/openafs/server/UserList file on every machine where the Backup Server is running, or must be logged
onto a server machine as the local superuser "root" if the -localauth flag is included.
SEE ALSO BackupLog(5), backup(8), backup_restoredb(8), backup_savedb(8), bos_getlog(8)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 BACKUP_DBVERIFY(8)