OraFAQ Forum: Backup & Recovery » How does one put a database into ARCHIVELOG mode?

Home » RDBMS Server » Backup & Recovery » How does one put a database into ARCHIVELOG mode?

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

How does one put a database into ARCHIVELOG mode? [message #153970]

Thu, 05 January 2006 03:13

quytc
Messages: 81
Registered: November 2005
Location: Viet Nam

Member

I have a database. I put my database by command following:
SQL> CONNECT sys AS SYSDBA
SQL> STARTUP MOUNT EXCLUSEVE;
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ARCHIVE LOG START;
SQL> ALTER DATABASE OPEN;

When I run command STARTUP MOUNT EXCLUSEVE;. I get a error.
SQL> STARTUP MOUNT EXCLUSEVE;
ORA-01031: insufficient privileges

Can anybody tell me what is error?

Report message to a moderator

Re: How does one put a database into ARCHIVELOG mode? [message #153979 is a reply to message #153970]

Thu, 05 January 2006 04:03

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Follow the below step to convert Database into Archive log mode
===============================================================
[1] Shutdown
[2] Set init.ora Parameters.
LOG_ARCHIVE_START = TRUE
LOG_ARCHIVE_DEST_1 = path
LOG_ARCHIVE_FORMAT = format (i.e. %t%s.arch)

[3] Startup mount
[4] Alter database archivelog
[5] Alter database open
[6] Archive log list

Report message to a moderator