Results 1 to 10 of 10
  1. #1
    Join Date
    Nov 2004
    Posts
    5

    Unanswered: Simple Basic, Oracle Problem

    Hello,

    I am trying to:
    1. Backup a database to a file/disk
    2. Restore a database from a file/disk

    I am using RMAN to attempt to perform these functions. It seems like a very simple task, however, no matter what I do, I run into problems. It seems like no matter what I do I get an error saying "cannot backup or copy active file in NOARCHIVELOG mode". There has to be a simple, quick way to backup and restore databases.

    Does anyone know why I may be receiveing this error message. Or possibly of a quick workaround?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    What RMAN commands are you using?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2003
    Posts
    237
    RMAN runs as an ORACle Session; database has to be up when RMAN is running; When database is running you can take ONLY a HOT backup; HOT backup can be taken ONLY in ARCHIVELOG mode. If you want a COLD backup, shutdown the instance; copy the datafiles and the control files;recopy(restore) from these and start the instance.
    mota

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by dbamota
    RMAN runs as an ORACle Session; database has to be up when RMAN is running.
    this is incorrect.
    you can do a FULL or incremental backup using RMAN while in NOARCHIVELOG mode.

    However, you still need to shut down you db (through RMAN if you like) if
    you wish to be in NOARCHIVELOG mode and also wish to do a backup through
    RMAN.

    Read the docs or ask some further questions if you like.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Nov 2004
    Posts
    5
    If I shutdown the database, I need to connect to it using
    CONNECT TARGET user/pass@server

    Once I'm connected it says...
    " failure of backup command
    " could not obtain fully authorized session
    " ORACLE not availalble
    " shared memory realm does not exist

    How do I backup the database?

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    I don't have the manual in front of me, but if I remember correctly, you have to have the database in mount, but not open to perfrom an rman cold backup. A database that is completely down can't be backed up by rman.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Do this:

    1) Startup mount
    2) rman target user/passwd catalog <MyRmanCat>
    3)
    Code:
    RUN {
    ALLOCATE CHANNEL ch00 TYPE DISK;
    ALLOCATE CHANNEL ch01 TYPE DISK;
    ALLOCATE CHANNEL ch02 TYPE DISK;
    
    BACKUP
        INCREMENTAL LEVEL=0
        FORMAT "${backupdir}/${sid}_dbf_s%s_p%p_t%t"
        DATABASE;
    
    RELEASE CHANNEL ch01;
    RELEASE CHANNEL ch02;
    RELEASE CHANNEL ch00;
    }
    exit

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Nov 2004
    Posts
    5
    LKBrwn_DBA,

    I like the route you are taking with your solution... However, I receive the following message:
    ORA-19550: cannot use backup/restore functions while using dispatcher

    When I try to run your commands. Also, I do not have a startup script anywhere on my machine. I have to launch "rman" via the command line to enter your commands. Am I doing this correctly? Any suggestions?

    Thank you very much

  9. #9
    Join Date
    Dec 2003
    Posts
    1,074
    Although I've never encountered an error either way, are you connecting with RMAN via a SHARED or DEDICATED session? RMAN manual says you must use a DEDICATED session.

    -Chuck

  10. #10
    Join Date
    Jul 2003
    Posts
    2,296
    dispatchers mean MTS (multi-threaded server)
    as mentioned above you cannot login remotely using MTS

    why can't you log into the host, then login to rman?
    rman target /
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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