Home » RDBMS Server » Server Administration » Automatic archival value
Automatic archival value [message #277481] Tue, 30 October 2007 05:39 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi please see the followin output .

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1
Next log sequence to archive 3
Current log sequence 3

SQL> show parameter log_archive_start

NAME TYPE VALUE
------------------------------------ ----------- ------
log_archive_start boolean FALSE


Automatic archival is ENABLED, but log_archive_start value is FALSE .Can someone tell me from where Oracle is picking this value ? i reboot the database but same thing .

Please help me
Re: Automatic archival value [message #277483 is a reply to message #277481] Tue, 30 October 2007 05:42 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

LOG_ARCHIVE_START initialization parameter was deprecated as of Oracle Database 10g Release 1 (10.1).
Re: Automatic archival value [message #277486 is a reply to message #277481] Tue, 30 October 2007 05:48 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Does it mean it is recording this value in CONTROL FILE ???
Re: Automatic archival value [message #277488 is a reply to message #277486] Tue, 30 October 2007 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It means that Oracle does not care of its value.
If you are in ARCHIVELOG mode then archiving is activated.

Regards
Michel
Re: Automatic archival value [message #277491 is a reply to message #277481] Tue, 30 October 2007 06:04 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
That cleared my doubts.. Thanks a lot guys
Previous Topic: I don't rebuild index, return with ORA-01652 error?
Next Topic: Version Compatibility
Goto Forum:
  


Current Time: Sat Dec 10 09:02:10 CST 2016

Total time taken to generate the page: 0.23444 seconds