Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    71

    Unanswered: Recovery Strategy

    We take weekly full hot backups using RMAN (no recovery catalog)
    with this script
    run {
    allocate channel c0 type disk format '/apps/oracle/admin/DBA/backup/DBA_%u_%s_%p';
    backup
    ( database include current controlfile );
    backup ( archivelog all delete input );
    }

    and also take daily export every night.
    What would be the best strategy of recovery in case of media failure and other major disastrous failure.
    The database runs in archivelog mode.

    Thanks
    Reema

  2. #2
    Join Date
    Oct 2003
    Posts
    71

    Re: Recovery Strategy

    Please note the db version is 8.1.7
    Originally posted by reemagupta
    We take weekly full hot backups using RMAN (no recovery catalog)
    with this script
    run {
    allocate channel c0 type disk format '/apps/oracle/admin/DBA/backup/DBA_%u_%s_%p';
    backup
    ( database include current controlfile );
    backup ( archivelog all delete input );
    }

    and also take daily export every night.
    What would be the best strategy of recovery in case of media failure and other major disastrous failure.
    The database runs in archivelog mode.

    Thanks
    Reema

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •