Habilitando archivelog

Habilitando archivelog

  • Configurar os parâmetros de archivelog
SYS@ORCL > show parameter recovery
SYS@ORCL > alter system set db_recovery_file_dest='/u02/fra';
SYS@ORCL > alter system set db_recovery_file_dest_size=20G;
SYS@ORCL > alter system set archive_lag_target=900;
  • Baixar a base.
SYS@orcl > shut immediate;
  • Subir o banco em modo mount
SYS@orcl > startup mount;
  • Colocando o banco em modo archivelog
SYS@orcl > alter database archivelog;
  • Abrir o banco
SYS@orcl > alter database open;