Testing Rman Backup5
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Testing Rman Backup5

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    Testing Rman Backup

    Im testing my Rman backup.
    We do our backup with the following command:

    BACKUP AS COPY DATABASE TAG = 'Full Copy 2007/03/11 19:15:02';


    On another machine, im testing the recovery like the following:
    rman TARGET / NOCATALOG
    startup nomount;
    SET DBID my_bd_id;
    RESTORE CONTROLFILE FROM '/mnt/jukprod_rman/rman_backup/20070311/c-3976015942-20070311-00';
    alter database mount;
    RESTORE DATABASE UNTIL TIME "TO_DATE('20070311 21:35:00','YYYYMMDD HH24:MI:SS')" PREVIEW;



    Problem:
    Rman wants 2 months of archive logs!!

    no backup of log thread 1 seq 80017 lowscn 10641963078 found to restore

    To

    no backup of log thread 1 seq 85592 lowscn 13248466314 found to restore

    That is 5575 archive logs that Rman needs. 100 Megs in size.
    so Rman needs 557 gig of archive!


    Whats wrong here?

    How come Rman needs all those archive?
    Why would rman need archive older that the backup since we did a backup as copy?

    We want full backup with not need older archive logs.
    Last edited by steeve123; 03-12-2007 at 12:41 PM.

  2. #2
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    rman TARGET / NOCATALOG
    -----------------------------
    Can you try using catalog during restore ?
    Milind
    -----------------------------
    www.milinds.com
    My Private World on the Web !

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    We are not using catalog for out rman backup. Everything in controlfile.

  4. #4
    Join Date
    Nov 2000
    Posts
    440
    Anyone?

  5. #5
    Join Date
    Nov 2000
    Posts
    440
    Solved everything witht the following metalink note: Note:419137.1

  6. #6
    Can you post a summary of that note?

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