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

Thread: RMAN RESTORE PROBLEMS

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    I am trying to restore a database in another server using rman as part of my testing of my backup procedure .

    ORA-00289: suggestion : C:\ORACLE\ORA81\RDBMS\RMAN175.ARC
    ORA-00280: change 481208 for thread 1 is in sequence #175
    Specify log: {=suggested | filename | AUTO | CANCEL}
    cancel
    Media recovery cancelled.
    SVRMGR> select * from v$recover_file;
    FILE# ONLINE ERROR CHANGE# TIME
    ---------- ------- ------------------ ---------- ---------
    0 rows selected.
    SVRMGR> select file#,status from v$datafile;
    FILE# STATUS
    ---------- -------
    1 SYSTEM
    2 ONLINE
    3 ONLINE
    4 ONLINE
    5 ONLINE
    5 rows selected.
    SVRMGR> alter database open resetlogs;
    alter database open resetlogs
    *
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'C:\ORACLE\ORADATA\RMANPROD\SYSTEM01.DBF'
    SVRMGR>
    what should i do now there is no other archive are there to appy . rman175.arc is current logfile of the database
    Radhakrishnan.M

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can do the recovery until cancel and then resetlogs. Then shutdown the database. then open the database for the production after a full level 0 backup.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2000
    Posts
    384
    thanks that did the trick .
    Radhakrishnan.M

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