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

Thread: Backup doubt

  1. #1
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    Hi

    I have got some doubt. Your inputs highly appreciated.

    Assume my database is running in ARCHIVE LOG MODE and I perform hot backup

    ALTER TABLESPACE BEGIN BACKUP.... END BACKUP...blabla...

    And I performed RMAN backup using

    run {
    allocate channel d1 type disk;
    backup
    filesperset 5
    format '/u06/oradata/rmanbackups/df_%d_%s_%p'
    (database include current controlfile);
    release channel d1;
    allocate channel d1 type disk;
    backup
    format '/u06/oradata/rmanbackups/al_%d_%s_%p'
    (archivelog all delete input);
    release channel d1;
    }

    Now doubt is Is the above RMAN backup procedure is the same as hotbackup procedure in terms of result while recovery? Or any diffrences? or any thing I am missing in above RMAN backup procedure?

    Do I need to add ALTER SYSTEM SWITCH LOGFILE?

    Thanks In Advance
    Nagesh

  2. #2
    Join Date
    Nov 2001
    Posts
    335

    Yes, you do need to force log switch, otherwise your last online redo log will not be backed up. I do not see any difference in terms of recovery. However, how big is a file generated by rman? If it bigger than 2gb , do your have OS issues related to the size?
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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