Home » RDBMS Server » Backup & Recovery » No-Archive to Archive Mode Conversion.
No-Archive to Archive Mode Conversion. [message #146530] Thu, 10 November 2005 22:34 Go to next message
weekend79
Messages: 198
Registered: April 2005
Location: Islamabad
Senior Member
Hi

How can I change the mode of my Database From No-Archivelog to Archivelog.

Because I want to take consistent backups online using RMAN.

Wishes
Jawad

Report message to a moderator

Re: No-Archive to Archive Mode Conversion. [message #146543 is a reply to message #146530] Thu, 10 November 2005 23:33 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

no searching on google, no searching on forum .

Did u read the documentation ?????

look here
http://www.orafaq.com/node/127

Report message to a moderator

Re: No-Archive to Archive Mode Conversion. [message #146650 is a reply to message #146543] Fri, 11 November 2005 16:04 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

see below written thing

============================================================
[A] Steps for changing Database to 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
==============================================================

regards
Always friend sunilkumar.

Report message to a moderator

Previous Topic: Unable to open the database
Next Topic: Reg Standby Databse
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 03:31:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.