Full hot backup ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Full hot backup ??

  1. #1
    Join Date
    Jan 2000



    I have done a full hot database backup as shown below.
    However I have some questions about the backup .....

    1. Do I need to issue a 'alter system archivelog current' before I
    start to backup my archived redo logs?
    2. How do I backup incremental archived logs?
    3. Do I need to generate a log switch before ending the backup?
    4. It is recommended to compress the backup files?

    ....... Backup all the tablespaces .......

    alter tablespace USERS begin backup;
    host cp /data/users01.dbf /backup/users01.dbf.bak
    host compress -f /backup/users01.dbf.bak
    alter tablespace USERS end backup;

    ....... Backup all the archived redo logs .......

    host cp $ORACLE_HOME/arch/arch*.arc /backup/arch
    host compress -f /backup/arch/*

    ....... Backup contolfile .......

    alter database backup controlfile to '/backup/controlfile.bck';

  2. #2
    Join Date
    Jun 2000
    Q1 => Yes to synchronize file headers
    Q2 => Using RMAN
    Q3 => Yes To Synchronize file Headers
    Q4=> I always keep backup in mutliple formats ( like compressed set and a file based set for quick recovery time )
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Jan 2000

    Will it be a problem is I backup using the being/end backup at OS Level as well as RMAN backup individually? Will there be a crash or any problem?


  4. #4
    Join Date
    Jan 2000

    Thumbs down

    Can anyone help please? Thanks!

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