Oracle10g

This page contains articles related to Oracle Database 10g

Latest  articles

General database Administration

Corruption

One thought on “Oracle10g

  1. #!/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 [email protected])
    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

Leave a Reply