Oracle10g

One thought on “Oracle10g”

• 

  Prashanth

  13 March, 2012 at 12:28 pm

  #!/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

This site uses Akismet to reduce spam. Learn how your comment data is processed.