OraFAQ Forum: Server Administration » Automatic archival value

Home » RDBMS Server » Server Administration » Automatic archival value

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

Automatic archival value [message #277481]

Tue, 30 October 2007 05:39

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

Report message to a moderator

Re: Automatic archival value [message #277483 is a reply to message #277481]

Tue, 30 October 2007 05:42

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).

Report message to a moderator

Re: Automatic archival value [message #277486 is a reply to message #277481]

Tue, 30 October 2007 05:48

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Does it mean it is recording this value in CONTROL FILE ???

Report message to a moderator

Re: Automatic archival value [message #277488 is a reply to message #277486]

Tue, 30 October 2007 05:53

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Automatic archival value [message #277491 is a reply to message #277481]

Tue, 30 October 2007 06:04

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

That cleared my doubts.. Thanks a lot guys

Report message to a moderator

Previous Topic:	I don't rebuild index, return with ORA-01652 error?
Next Topic:	Version Compatibility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:14:29 CDT 2024