BASE MODO ARCHIVELOG
1- Consultar modo base de datos
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
SQL>
2- Bajamos la base de Datos
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
3- Inicie la base de datos en estado de montaje.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2.0243E+10 bytes
Fixed Size 2261968 bytes
Variable Size 3087010864 bytes
Database Buffers 1.7113E+10 bytes
Redo Buffers 41164800 bytes
Database mounted.
SQL>
4: Configurar la base de datos en modo ARCHIVELOG.
SQL> alter database archivelog;
Database altered.
SQL>
5: Alterar la base de datos para abrir el estado.
SQL> alter database open;
Database altered.
SQL>
6: Consultar modo Archive log
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
SQL>
7: Consultar modo base de datos
SQL> select log_mode from v$database;
LOG_MODE
------------
ARCHIVELOG
SQL>
8: Asegure el destino ARCHIVELOG.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 371769
Next log sequence to archive 371772
Current log sequence 371772
SQL>
9: En caso de que desee cambiar el destino predeterminado a "/backup/archivelog/":
SQL> alter system set log_archive_dest_1='location=/backup/archivelog/' scope=both;
System altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /backup/archivelog/
Oldest online log sequence 371769
Next log sequence to archive 371772
Current log sequence 371772
SQL>
10: Forzar el Cambio de Registro Archive log
SQL> alter system switch logfile;
System altered.
SQL>
11: Verificar ala existencia del Archive log
[oracle@server]$ ls
1_371772_873365601.dbf
[oracle@server archivelog]$