Rman
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Rman

  1. #1
    Join Date
    Oct 2000
    Posts
    24

    Lightbulb

    Hi All

    I am using rman scripts to backup my database but everytime I run my script I get the following error. any ideas.

    RMAN> run {
    2> #backup the database to disk
    3> allocate channel d1 type disk;
    4> backup
    5> full
    6> tag full_db
    7> format '/backups/db_%t_%s_p%p'
    8> (database);
    9> release channel d1;
    10> }

    RMAN-03022: compiling command: allocate
    RMAN-03026: error recovery releasing channel resources
    RMAN-00569: ================error message stack follows================
    RMAN-06004: ORACLE error from recovery catalog database: ORA-01012: not logged o
    n
    RMAN-03002: failure during compilation of command
    RMAN-03013: command type: allocate
    RMAN-06004: ORACLE error from recovery catalog database: ORA-01012: not logged o
    n

    RMAN>


    Thanks Vinay

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    I think there is # with the command backup , is it typo mistake or it is really in the script,another thing there wont be any command like 'backup the database' it should be 'backup database',if it is preceded by # I think it is commented.U already allocated the channel to disk why again specifying the disk type with backup command.
    {
    Allocate channel c1 type disk;
    backup database
    ....
    ....
    }

  3. #3
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    How are you connecting to your target and catalog databases? Is this for 8.0 or 8i?

    D.

  4. #4
    Join Date
    Oct 2000
    Posts
    24
    I am connecting to the database via the command
    rman80 sys/password

    the version of oracle is 8.0.5

    Vinay


  5. #5
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    It seems that you did not connect to recovery catalog.
    If you ever created recovery catalog, you need to connect to both target database and the database your recovery catalog resides. I am using Oracle 8.1.5, it works fine for me.

  6. #6
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    Have you tried something like the following?

    rman80 rcvcat rman/rman@rmandb target sys/password
    -- or --
    rman80 rcvcat rman/rman@rmandb
    RMAN> connect target

    The key to be sure to indicate your catalog database with "rcvcat"
    For these examples, your target database is local. $ORACLE_SID (for UNIX) must be set as well for the target.

    D.

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