Consulta view v$databases
|
1 2 3 4 5 |
SYS@ORCL > select log_mode from v$database; LOG_MODE ------------ NOARCHIVELOG |
Baixar o banco
|
1 2 3 4 |
SYS@ORCL> shut immediate Database closed. Database dismounted. ORACLE instance shut down. |
Iniciar o banco modo Mount
|
1 2 3 4 5 6 7 8 9 |
SYS@ORCL> startup mount ORACLE instance started. Total System Global Area 4275781632 bytes Fixed Size 2260088 bytes Variable Size 1157628808 bytes Database Buffers 3103784960 bytes Redo Buffers 12107776 bytes Database mounted. |
Habilitar modo Archivelog
|
1 2 |
SYS@ORCL> alter database archivelog; alter database set archivelog |
Alterando status para Open
|
1 2 3 |
SYS@ORCL > alter database open; Database altered. |
Verificando status
|
1 2 3 4 5 |
SYS@ORCL > select status from v$instance; STATUS ------------ OPEN |
Consulta view v$database
|
1 2 3 4 5 |
SYS@ORCL > select log_mode from v$database; LOG_MODE ------------ ARCHIVELOG |