DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.