This page contains articles related to Oracle Database 10g
Latest articles
- PROCESSED Messages not clearing from Oracle Queue
- ORA-01873 error running SAP pre-upgrade scripts
- LGWR terminating instance due to error 338
- portmap: unrecognized service on RHEL6
- ORA-12514 due to DNS issue
General database Administration
- Copying Oracle Scheduler jobs with Arguments
- Effect Of Multiple SHMMAX Settings
- Using Oracle Wallet to Execute Shell script/cron without hard coded Oracle database password
- CleanUp Temporary Segments Occupying Permanent Tablespace
- Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
- Cloning database..Just do some Post checks !!
- Connections to DataBase Hang Including “/ as sysdba”
- Scheduling Job through Cron??
- Recreating Database Link
- Creating Oracle Extended RAC on Oracle VM
- Full Database Export Failing With ORA-00980
- Checking Database Feature Usage Stats
- 10.2.0.4 Window’s Patchset overwrites Sqlnet.ora
- Simplified Approach to Resolve ORA-4031
- High Database Sessions
- ORA-01426 After Upgrade to 10g
- ORA- 4031 – A Case Study
- Solving ORA-1031 while connecting as “/ as sysdba” :
- AWE -What is It and How to use it?
- Recovering from ORA-1578 ORA-8103 (Logical Corruption)
#!/bin/ksh
#Script to Perform incremental backup every day at 11 am
################################################################
#Change History
#================
#DATE AUTHOR CHANGE
#——— ———————– ——————-
#08-mar-2012 Prashanth Kumar H New Script Created
#
################################################################
export ORACLE_HOME=/home/oracle10g/oracle/product/10.2.0/db_1
export ORACLE_SID=soft
export PATH=$PATH:$ORACLE_HOME/bin
rman target sys/soft
run {
ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK;
CROSSCHECK BACKUP;
BACKUP incremenatal level 1 AS COMPRESSED BACKUPSET FORMAT ‘/home/oracle10g/SOFT/backupsset/databasefiles_%d_%u_%s_%T’;
sql ‘ALTER SYSTEM ARCHIVE LOG CURRENT’;
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT ‘/home/oracle10g/SOFT/archivelog/archivelogs_%d_%u_%s_%T’ DELETE INPUT;
BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT ‘/home/oracle10g_SOFT/controlfile_%d_%u_%s_%T’;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
RELEASE CHANNEL RMAN_BACK_CH01;
}
EXIT;
#Script Used To backup the incremental database using rman
###############################################################
* 11 * * * /home/oracle10g/rman_inc_bk.sh
but the i am getting the below error…
From [email protected] Tue Mar 13 11:42:06 2012
Return-Path:
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
by localhost.localdomain (8.13.1/8.13.1) with ESMTP id q2D6C6uq008864
for ; Tue, 13 Mar 2012 11:42:06 +0530
Received: (from oracle10g@localhost)
by localhost.localdomain (8.13.1/8.13.1/Submit) id q2D6C1xn008857;
Tue, 13 Mar 2012 11:42:01 +0530
Date: Tue, 13 Mar 2012 11:42:01 +0530
Message-Id:
From: [email protected] (Cron Daemon)
To: [email protected]
Subject: Cron /home/oracle10g/rman_inc_bk.sh
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
X-Cron-Env:
Recovery Manager: Release 10.2.0.1.0 – Production on Tue Mar 13 11:42:01 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SOFT (DBID=3725122068)
RMAN>
Recovery Manager complete.
/home/oracle10g/rman_inc_bk.sh[22]: run: not found
/home/oracle10g/rman_inc_bk.sh[23]: ALLOCATE: not found
/home/oracle10g/rman_inc_bk.sh[24]: CROSSCHECK: not found
/home/oracle10g/rman_inc_bk.sh[25]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[26]: sql: not found
/home/oracle10g/rman_inc_bk.sh[27]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[28]: BACKUP: not found
/home/oracle10g/rman_inc_bk.sh[29]: CROSSCHECK: not found
/home/oracle10g/rman_inc_bk.sh[30]: DELETE: not found
/home/oracle10g/rman_inc_bk.sh[31]: DELETE: not found
/home/oracle10g/rman_inc_bk.sh[32]: RELEASE: not found
/home/oracle10g/rman_inc_bk.sh[33]: syntax error: `}’ unexpected