Error RMAN
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Error RMAN

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    Error RMAN

    Hello guys..

    I installed Oracle 10gR2 on solaris 10, and created a sample DB called HEAT. This database is configured to run in Archivelog mode and also Flash_recovery_area.

    Iam trying to take a simple backup using database control. there is only 1 database on that server and i plan to use controlfile instead of recovery catalog.
    Now here are the steps when i execute, i get an ERROR.

    1. connected as 'sys' from Database Control.
    2. Went to Maintenence Tab, click in Backup settings.
    3. click on Device Tab, and click on "Test disk backup"..
    4. I get an error that says "Disk Backup Test Failed!"

    When click on View Error Details :
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Recovery Manager: Release 10.2.0.1.0 - Production on Fri Feb 2 12:53:29 2007

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    RMAN>
    connected to target database (not started)

    RMAN>
    echo set on


    RMAN> run {
    2> allocate channel oem_disk_backup device type disk;
    3> backup as BACKUPSET current controlfile tag '02022007125328';
    4> restore controlfile validate from tag '02022007125328';
    5> release channel oem_disk_backup;
    6> }
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of allocate command at 02/02/2007 12:53:30
    RMAN-06403: could not obtain a fully authorized session
    ORA-01034: ORACLE not available


    RMAN> allocate channel for maintenance type disk;
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of allocate command at 02/02/2007 12:53:30
    RMAN-06403: could not obtain a fully authorized session
    ORA-01034: ORACLE not available


    RMAN> delete noprompt backuppiece tag '02022007125328';
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of delete command at 02/02/2007 12:53:30
    RMAN-12010: automatic channel allocation initialization failed
    RMAN-06403: could not obtain a fully authorized session
    ORA-01034: ORACLE not available


    RMAN> exit;

    Recovery Manager complete.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    I only have 1 database , and it is configured to backup using Controlfile and not Recovery catalog ( which is the default)...

    What additional steps do i have to do, to take a simple backup using database control ?

    any help is appreciated..

    thanks
    Ron

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    You can not run backup when database is not started.
    It says in the log:

    connected to target database (not started)
    One, who thinks that the other one who thinks that know and does not know, does not know either!

  3. #3
    Join Date
    Oct 2002
    Posts
    284
    thanks BV

    I have only 1 database, HEAT and that database is up and running. so iam confused when it says that "Database is not avalable". I want to back up the HEAT database itself using Control file.(The information can be stored in the control file or in a recovery catalog). I have not created any Recovery catalog .

    Like i said...
    1. Installed 10g R2
    2. Created a Test Database HEAT ( with Archive log & flash Recovery area using DBCA)
    3. started EMCTL
    4. connected to Database thru database control using sys id
    5. now..when i try to use RMAN , i get this error ..

    What database is it saying that is not availabel ?...HEAT is available...

    Iam confused.

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,027
    "ORA-01034: ORACLE not available" Is the database mounted but not open? Do you have your oracle_sid set correctly?
    this space intentionally left blank

  5. #5
    Join Date
    Oct 2002
    Posts
    284
    yes...i can connect to database using Scott id. How do you set the SID when you are using "database Control" thru URL ?...

    I think i know what the problem is , ...not sure how to solve it.
    I have to tell DB control what my target is. How do we set what the target is in database Control ?

    thanks
    Ron

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