Square DBA – Oracle DBA Talk

How to put a database in archivelog mode?

How to put a database in archivelog mode? It’s pretty simple really.

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

Total System Global Area 1241513984 bytes
Fixed Size                   778976 bytes
Variable Size             333716768 bytes
Database Buffers          905969664 bytes
Redo Buffers                1048576 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

That is all there is to it. Now make sure you have properly set your LOG_ARCHIVE_DEST or it will cause issues later. To see what mode you database is in currently use this SQL:

SELECT LOG_MODE FROM SYS.V$DATABASE;

Upgrade an Oracle 10g database to Oracle 11g

Most of my databases are Oracle 10G instances. I have one instance that is Oracle 11G, but that was a fresh install. I have a test 10G database with some old production data in it. I am going to up upgrade it to 11G and I will post my experience. After the upgrade I will be setting up a test RMAN configuration. The plan is to work on backup and recovery. A co-worker and I will practice breaking a test database in various ways and trying to recover the database. It should be fun, stay tuned.