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
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
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.
Previous Topic: Unable to open the database
Next Topic: Reg Standby Databse
Goto Forum:
  


Current Time: Thu Mar 28 04:10:04 CDT 2024