DBAsupport.com Forums - Powered by vBulletin
Page 5 of 7 FirstFirst ... 34567 LastLast
Results 41 to 50 of 61

Thread: RMAN backup

  1. #41
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Hmm can you just substitute the set until date format temporarily with SCN values and check if we can restore the control files.

    (note for restoring this way you have a catalog configured)

    somethin like

    set until sequence

    regards
    Hrishy
    Last edited by hrishy; 07-08-2005 at 06:50 AM.

  2. #42
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I tested this and it works for me.I do not have a catalog so i have configured a snapshot controlfile to on.

    I first did a backup of my database and then tried restoring the controlfile.

    Code:
    run {
    set until time "to_date('08-07-2005 18:58:00','dd-mm-yyyy hh24:mi:ss')";
    restore controlfile to '/tmp/control01.ctl';
    }
    
    
    
    executing command: SET until clause
    
    Starting restore at 08-JUL-05
    
    using channel ORA_DISK_1
    channel ORA_DISK_1: starting datafile backupset restore
    channel ORA_DISK_1: restoring controlfile
    output filename=/tmp/control01.ctl
    channel ORA_DISK_1: restored backup piece 1
    piece handle=/xxxxx/app/oracle/product/9.2.0.4.0/dbs/c-3446257643-20050708-01 tag=null params=NUL
    L
    channel ORA_DISK_1: restore complete
    Finished restore at 08-JUL-05

    cd /tmp
    ls -ltr

    -rw-r----- 1 oracle dba 6676480 Jul 8 18:59 control01.ctl

    regards
    Hrishy

  3. #43
    Join Date
    Jan 2000
    Posts
    387
    Hi

    The controlfile is autobackup or manually?

  4. #44
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    I am not using a catalog .So for me to restore the controlfile i am using a autobackup.

    regards
    Hrishy

  5. #45
    Join Date
    Jan 2000
    Posts
    387
    Hi

    I am not using a catalog too. I have autobackup the controlfile too, but i am still encountering error...

    I have listed the backup to ensure that the controlfile has been backup:

    Starting Control File and SPFILE Autobackup at 14-JUL-05
    piece handle=/oracle/app/product/9204/dbs/c-2272111974-20050714-02 comment=NONE
    Finished Control File and SPFILE Autobackup at 14-JUL-05

    Then I tried to restore the controlfile and I got the following error:
    RMAN-06026: some targets not found - aborting restore
    RMAN-06024: no backup or copy of the controlfile found to restore

    Any help please??

  6. #46
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you try this whole excersise again.

    create a tablespace

    Please take a complete backup of your database with the controlfiel backup set to auto

    drop the tablespace

    and now restore the controlfile which was backed up above.

    I am asking you this becoz atleast this time its saying the controlfile was not found.

    regards
    Hrishy

  7. #47
    Join Date
    Jan 2000
    Posts
    387
    Hi Hrishy

    It was my mistake for the error as the controlfile cannot be overwritten which resulted in the error message the controlfile was not found!

    Anyway I have restored the controlfile and overwrite my current control file. I brought down the db and startup mount. I did a restore and recover database before opening the database with resetlogs. I can see from the messages that my deleted tablespace has been restored.

    channel ORA_DISK_1: starting datafile backupset restore
    channel ORA_DISK_1: specifying datafile(s) to restore from backup set
    restoring datafile 00011 to /oracle/oradata/test.dbf
    channel ORA_DISK_1: restored backup piece 1
    piece handle=/oracle/t563728056_s127_p1 tag=TAG20050715T150736 params=NULL
    channel ORA_DISK_1: restore complete
    Finished restore at 15-JUL-05

    However when i did a query on dba_tablespaces, I did not see the tablespace that I have deleted. Why?

  8. #48
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Mooks

    what about v$datafile does that show you the file associated with the tablespace.

    what about v$tablespace

    regards
    Hrishy

  9. #49
    Join Date
    Jan 2000
    Posts
    387
    Hi Hrishy

    I have checked those tables too, they do not reflect my dropped tablespace has been restored.

  10. #50
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Mooks

    Well i suggest that you carry out this test once again a fresh and if you are able to reproduce this then i assume its a bug and probably time to raise a TAR with oracle :-)

    regards
    Hrishy

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