Manage Database Availability Lab

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