RECREATING RMAN in 9.0.1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RECREATING RMAN in 9.0.1

  1. #1
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857

    RECREATING RMAN in 9.0.1

    I am in the process of recreating my standby database, A hardware failure(hard disk) occured. Not only the datafiles of the standby database was affected, it also include the datafile of the tablespace in which RMAN catalog resides in another small DB.

    We recreate the RMAN catalog owner and the tablespaces it uses.
    But when I try to create the catalog the list below shows errors,
    please shed some lights in this concern guys and gals 'cause we needs this to be addressed as soon as possible


    PPI[SFV880]:/var/opt/oracle*> rman catalog rman/rman@oms9

    Recovery Manager: Release 9.0.1.1.0 - 64bit Production

    (c) Copyright 2001 Oracle Corporation. All rights reserved.

    connected to recovery catalog database
    recovery catalog is not installed

    RMAN> create catalog tablespace rman;

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00579: the following error occurred at 09/20/2004 20:00:21
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found "rman": expecting one of: "double-quoted-string,
    identifier, single-quoted-string"
    RMAN-01007: at line 1 column 27 file: standard input

    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-00579: the following error occurred at 09/20/2004 20:00:21
    RMAN-00558: error encountered while parsing input commands
    RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, backup,
    beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, co
    nfigure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list
    , mount, open, print, quit, recover, register, release, replace, report, renorma
    lize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, sta
    rtup, shutdown, send, show, test, upgrade, validate"
    RMAN-01007: at line 1 column 31 file: standard input

    RMAN>

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857


    just forget to pug RMAN in double-quote("RMAN")

    thanks anyway....best regards...

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