Rman error with daily scripts (ORA-27101)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Rman error with daily scripts (ORA-27101)

  1. #1
    Join Date
    Oct 2002
    Posts
    182

    Rman error with daily scripts (ORA-27101)

    Oracle 9.2.0.2 on Solaris
    Someone else wrote this RMAN script and I am trying to determine why there are errors. It is run through a cronjob.


    RMAN-LOG:
    • Recovery Manager: Release 9.2.0.2.0 - 64bit Production

      Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

      RMAN> connect target rman/rman
      2> connect catalog rman/rman@bck1
      3>
      4> run {
      5>
      6> set command id to 'hotfull';
      7>
      8> # Configure the tape drive as the default device and indicate parallelism
      9> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=sunprod1,NSR_DATA_VOLUME_POOL=Default)';
      10> allocate channel t2 type 'SBT_TAPE' parms 'ENV=(NSR_SERVER=sunprod1,NSR_DATA_VOLUME_POOL=Default)';
      11>
      12> debug on;
      13>
      14> # Have to use logs option for hotbackup. Cannot do nologs
      15> backup incremental level=0 tag hot_level_0 filesperset=1 format 'FULL_%d_%u' database keep until time
      "trunc((sysdate + 62),'DD')" logs;
      16>
      17> debug off;
      18>
      19> # Now backup controlfile
      20> backup current controlfile format 'CF_%d_%u';
      21>
      22> release channel t1;
      23> release channel t2;
      24>
      25> }
      26>
      27> exit;
      connected to target database: KOP (DBID=2863956211)

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-04004: error from recovery catalog database: ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      SVR4 Error: 2: No such file or directory

      Recovery Manager complete.



    KOrn Shell scripts:
    • bash-2.03$ more run_hotfull.ksh
      #!/bin/ksh

      # Remember to configure controlfile auto backup
      BASE_DIR=/users/oracle/local/admin/backup
      LOG_FILE=dbhotfull_`date '+%m%d%y_%H%M%S'`.log
      LOG_DIR=$BASE_DIR/logs

      $BASE_DIR/batch_env.ksh

      # Call archive log backup script
      rman cmdfile $BASE_DIR/db_hotfull.rcv log $LOG_DIR/$LOG_FILE

      #$BASE_DIR/bootstrap_backup.ksh
      bash-2.03$ more bootstrap_backup.ksh
      #!/bin/ksh

      savegrp -O -l full -P downtown -c sunprod1 -c sunprod1



    I looked up all the errors and searched in the archives here and couldn't find anything pertaining to this problem.
    I was thinking some PATH was not set correctly.
    Any help is appreciated.
    - Cookies

  2. #2
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Your catalog database bck1 is down.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  3. #3
    Join Date
    Nov 2002
    Location
    Dublin, Ireland
    Posts
    132
    did you check if your RMAN database is up and running?
    Giani

  4. #4
    Join Date
    Oct 2002
    Posts
    182
    thanks for the suggestion.
    evidentally they didn't have dbstart set up.
    - Cookies

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width