Oracle DBA

Először nézzük meg, hogy milyen módban van az adatbázisunk. / First let's check which mode our database is in.

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Fri Oct 28 15:06:43 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

 OK, állítsuk le, majd mount módban indítsuk el, és tegyük ARCHIVELOG módba, majd nyissuk meg. / Okay, let's shut it down, then start it in mount mode and then change it to ARCHIVELOG mode then open it.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  456146944 bytes
Fixed Size                  1344840 bytes
Variable Size             377490104 bytes
Database Buffers           71303168 bytes
Redo Buffers                6008832 bytes
Database mounted.
SQL> alter database archivelog;
SQL> alter database open;

Database altered

Nézzük meg, sikerült-e. / Let's check if it succeeded.

SQL> select log_mode from v$database;

LOG_MODE
------------
ARCHIVELOG
Megnézhetjük archive log list paranccsal is. / We can also check with archive log list command.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     384
Next log sequence to archive   386
Current log sequence           386