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

Thread: restoring from cluster A to B with RMAN

  1. #1
    Join Date
    Sep 2001
    Posts
    200
    I have OPS. aix 4.3
    I wnat to restore from cluster A to B. I have the backup of A. But no archivelogs.
    Now I have restore to B. But it won't open irrespectively of the option I use. It call for use of backup contofile MUST BE DONE. But when you do that it calls for some checkpoint or log to be applied. The problem is I want to assume that all these achive logs are missing and thus open with resetlogs. I have used (set until scn 1635063555 this is the latest checkpoit in the controlfile that was backed up. I have even gone to earlier SCNs. In desperation I have decided to set time to 1 then 2 days earlier that the day of backup (rremmber this is whole database backup). Does this mean you cannot open a database without applying a log? This is somewhat fussy to me because if I took a bckup on jan 04 (online) it follows that all SCNS which were generated on jan 03:00:00 should be in the controlfile by now. Then i can be able to recover to say 03:23:59 and open with resetlogs 'b/c I don't have the archives'. Thsi this has been impossible. Below is an except of problem encountered.
    SVRMGR> recover database until time '2002-04-10:00:00:00';
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
    SVRMGR> recover database until time '2002-03-10:00:00:00';
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
    SVRMGR> RECOVER DATABASE UNTIL CHANGE 1634289916;
    ORA-00283: recovery session canceled due to errors
    ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
    SVRMGR> recover database until cancel using backup controlfile;
    ORA-00279: change 1629340135 generated at 12/28/2001 17:35:18 needed for thread
    1
    ORA-00289: suggestion : /u02/oracle/admin/prod/arch/prod1/redo1_25867.arc
    ORA-00280: change 1629340135 for thread 1 is in sequence #25867
    Specify log: {=suggested | filename | AUTO | CANCEL}
    cancel;
    ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
    ORA-01152: file 2 was not restored from a sufficiently old backup
    ORA-01110: data file 2: '/dev/rprod_0208_000'
    SVRMGR>
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    Even when you do an incomplete recovery, you need to apply at least one archive log after restoring your datafile(s). This would be the archive log containing the end-of-backup marker. Without that, you can't get the database into a consistent state.
    sonofsita
    http://www.ordba.net

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To do the restore and recovery, you need to be connected to the RMAN. In your case, looks like your are trying to do things through the server manager.


    http://technet.oracle.com/docs/produ...pdb.htm#441628

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Sep 2001
    Posts
    200
    Yea, because RMAN does not understand USING BACKUP CONTROLFILE.
    Life is what is happening today while you were planning tomorrow.

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