DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 30

Thread: backup question

  1. #1
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    Hi all,

    If I take and full export of my db (logical backup) and also copy all the control files, data files and redo log files (physical), which one of the two methods saves me storage space. And why?

    Thanks,
    leonard905
    leonard905@yahoo.com

  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    Export

    Export is compressed

    A cold backup of all the dB files is the size of the sum of all the files

  3. #3
    Join Date
    May 2002
    Posts
    219
    Export/import is not a backup methodology
    marist89 - http://www.dbasupport.com/forums/sho...6&pagenumber=3
    yodaDBA@hotmail.com

  4. #4
    Join Date
    Jun 2000
    Location
    dumfries,va,usa
    Posts
    227
    I know that export is not a backup method. I just need a figures to justify the need for both physical and logical methods for our production db.
    leonard905
    leonard905@yahoo.com

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Do you mean copy the redo log files as in a cold backup? Why copy those files? I think every book (well, quite a few of the more authoratative ones anyway) explicity tell you NOT to copy the redo log files in a cold backup. That should save you some space.

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by stecal:
    Do you mean copy the redo log files as in a cold backup? Why copy those files? I think every book (well, quite a few of the more authoratative ones anyway) explicity tell you NOT to copy the redo log files in a cold backup. That should save you some space.
    In fact, you should copy online redo logs files with cold backup.

    Sanjay


  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by SANJAY_G

    In fact, you should copy online redo logs files with cold backup.
    In fact, the only case when you need to copy online redo log files with cold backup is when your databas was shut down in ABORT mode prior to backup.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by jmodic
    In fact, the only case when you need to copy online redo log files with cold backup is when your databas was shut down in ABORT mode prior to backup.
    Well, what happens if you lose everything (including redo logs) and have to recover from a cold backup?
    The only option you have is, restore datafiles, cotrolfile and open the database with RESETLOGS and you may also have to issue a fake recover command in order to avaoid ORA-01139

    And when you open db with RESETLOGS all your previous hot backups will be invalidated.

    I would still backup redo logs with cold backup to avoid going through all these hassles.

    Sanjay

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    If you loose everything and have to restore from cold backup (BTW, why would you *have to* restore from cold backup, you could recover from hot backup as well), why would your previous hot backups be invalidated? They are still perfectly valid, no matter if you had to open your database with RESETLOGS. You still can recover to any point in time, both prior to resetlogs (in which case your starting backup would be any hot backup taken prior to RESETLOGS) and after it (in which case you would use any backup taken after the RESETLOGS).

    [Edited by jmodic on 10-04-2002 at 05:13 AM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by SANJAY_G
    Originally posted by stecal:
    Do you mean copy the redo log files as in a cold backup? Why copy those files? I think every book (well, quite a few of the more authoratative ones anyway) explicity tell you NOT to copy the redo log files in a cold backup. That should save you some space.
    In fact, you should copy online redo logs files with cold backup.

    Sanjay

    Sanjay I guess you have not used RMAN for cold backups. RMAN does not backup online redo logs whatsoever, not in cold backups or hot backups.

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