OraFAQ Forum: Backup & Recovery » from NOARCHIVELOG to ARCHIVELOG

Home » RDBMS Server » Backup & Recovery » from NOARCHIVELOG to ARCHIVELOG

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

from NOARCHIVELOG to ARCHIVELOG [message #121970]

Thu, 02 June 2005 02:06

kaa2005
Messages: 4
Registered: June 2005

Junior Member

HI.
Please say, how to turn databse from NOARCHIVELOG to ARCHIVELOG mode?
Thanks.

[Updated on: Thu, 02 June 2005 02:08]

Report message to a moderator

Re: from NOARCHIVELOG to ARCHIVELOG [message #121971 is a reply to message #121970]

Thu, 02 June 2005 02:08

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Arrange for downtime, then do the following from sqlplus:

SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE NOARCHIVELOG;
SQL> ALTER DATABASE OPEN;

Best regards.

Frank

Report message to a moderator

Re: from NOARCHIVELOG to ARCHIVELOG [message #121973 is a reply to message #121970]

Thu, 02 June 2005 02:22

kaa2005
Messages: 4
Registered: June 2005

Junior Member

Thanks.

Report message to a moderator

Re: from NOARCHIVELOG to ARCHIVELOG [message #124497 is a reply to message #121973]

Sun, 19 June 2005 09:33

salmansh
Messages: 14
Registered: June 2005
Location: Al-Khobar

Junior Member

But before doing that don't forget to change the parameters for the archive log options in the initialization file.....

Report message to a moderator

Re: from NOARCHIVELOG to ARCHIVELOG [message #124814 is a reply to message #121970]

Tue, 21 June 2005 11:53

rsone
Messages: 7
Registered: June 2005
Location: Jacksonville

Junior Member

I think the previous reply is given in reverse fashion.

If you want turn on ARCHIVELOG mode from NOARCHIVELOG

Use these stpes

Go to init parameter file

Set Archivelog parameters
log_archive_start=True
log_archive_format=%S.arc
log_Archive_dest=<Path for Archive log>

SQL> shutdown;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
SQL> select log_mode from v$database;

Note: Backup the database once you trun on ARCHIVELOG mode since exisiting Redo logs are no longer useful for recovery.

Report message to a moderator

Previous Topic:	Urgent
Next Topic:	how can i implement RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 00:18:17 CDT 2024