sqlplus sys as sysdba
Verificando onde ficaram os ARCHIVELOG
SQL> show parameter log_archive_dest_1
Habilitando...
SQL> select log_mode from gv$database;
SQL> shutdown immediate;
SQL> startup mount exclusive;
SQL> alter database archivelog;
SQL> alter database open;
SQL> select log_mode from gv$database;
Desabilitando...
SQL> startup mount
SQL> alter database noarchivelog;
SQL> alter database open;
Mudando o Local de Gravação
SQL> shutdown immediate;
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION=/var/backup/archivelog' SCOPE=BOTH;
SQL> ARCHIVE LOG START;
SQL> ALTER DATABASE OPEN;
Querendo mais informações do Archive tipo local no disco.
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 30
Next log sequence to archive 32
Current log sequence 32
===> Para saber o local da um show no Archive destination
SQL> show parameter DB_RECOVERY_FILE_DEST
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size big integer 3882M