Configurar ARCHIVELOG mode

[igorbmParticipante]

Amigos resolvi seguir os passos de todos vocês. Então refiz tudo o que tinha falado no primeiro e-mail.
1. Me loguei como sys;
2. Executei o comando archive log list;
3. Executei o comando shutdown immediate;
4. Executei o comando startup mount; Nesse momento que o erro ocorreu.
SQL> startup mount;
Instância ORACLE iniciada.
ORA-12528: Message 12528 not found; product=RDBMS; facility=ORA

1. Qualquer comando que tento executar após o erro acima me retorna o seguinte erro: ORA-01041: erro interno: a extensão hostdef não existe
2. A partir desse ponto vou seguindo todas as dicas:

[root@localhost bin]# lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 16-MAR-2009 10:13:00

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production
Start Date 16-MAR-2009 09:47:09
Uptime 0 days 0 hr. 25 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
Service “XE” has 1 instance(s).
Instance “XE”, status BLOCKED, has 1 handler(s) for this service…
Service “XE_XPT” has 1 instance(s).
Instance “XE”, status BLOCKED, has 1 handler(s) for this service…
The command completed successfully

1. [root@localhost bin]# lsnrctl stop

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 16-MAR-2009 10:39:10

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
The command completed successfully

1. [root@localhost bin]# lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 16-MAR-2009 10:13:54

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait…

TNSLSNR for Linux: Version 10.2.0.1.0 – Production
System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))

STATUS of the LISTENER

Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 – Production
Start Date 16-MAR-2009 10:13:54
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary…
Service “PLSExtProc” has 1 instance(s).
Instance “PLSExtProc”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully

1. Depois de iniciar o Listener novamente é como se não tivesse executado os comandos acima e tudo volta ao normal, porém não consegui fazer o que eu queria que é qtiver o modo de arquivamento.

2. Alguém tem mais alguma solução? Desde já agradeço muito pela força até o momento.