Break of database restoring proces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Break of database restoring proces

Hybrid View

  1. #1
    Join Date
    Sep 2006
    Posts
    16

    Break of database restoring proces

    Hi,

    The restore database process was broken and after that I can repeat restore and recovery of database successifuly. I get the following message:

    restore not done; all files readonly, offline, or already restored

    Oracle database is 9.2.0.5.
    Backup is done using rman. Day before I try restoring I created full database backup and backup all archivelog files with controlfile autobackup option.

    The workflow for restore proces I try to execute is:

    startup nomount;
    set DBID
    restore controlfile from autobackup;
    alter database open;
    restore database;

    Does anybody have idea how to restore my database?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    read the rman manual, you cant restore a database in an open state
    startup nomount;
    set DBID
    restore controlfile from autobackup;
    restore database;
    recover database;
    alter database open;

  3. #3
    Join Date
    Sep 2006
    Posts
    16
    Sorry..

    I know that but I wrote wrong. So:

    startup nomount;
    set DBID
    restore controlfile from autobackup;
    alter database mount;
    restore database;

    In this phase I got message that dbf files have been already restored but that restore process is not done.

    restore not done; all files readonly, offline, or already restored

    Is there any idea to solve this?

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