Chapter 1

  1. Put the database in ARCHIVELOG mode
    shutdown the database
    start the database in mount mode
    set the database in ARCHIVELOG mode
    open the database
  2. Ensure that a FRA is configured
    alter system set db_recovery_file_dest_size=2GB;
    alter system set db_recovery_file_dest=’/u01/app/oracle/fast_recovery_area’;
    show parameter db_recovery
  3. Backup the database
    backup database plus archivelog delete input;
  4. Check the backups
    list backup;
    list backup of database summary;
    list backup of archivelog all summary;
  5. Restore the database
    start database in the mount mode
    restore database
    recover database
    alter database open

No responses yet

Leave a Reply

Your email address will not be published. Required fields are marked *