In Oracle 10g, start automatically archive mode

  In Oracle10g, as long as the start of the archive database model, Oracle will be activated automatically archiving, thereby avoiding the 10 g ago because of the negligence of the users a range of issues. 

  $ Sqlplus "/ as sysdba" 

  SQL * Plus: Release 10.1.0.3.0 – Production on Wed Apr 13 09:53:25 2005 

  Copyright (c) 1982, 2004, Oracle. All rights reserved. 


  Connected to: 
  Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 – 64bit Production 
  With the Partitioning and Data Mining options 

  SQL> archive log list; 
  Database log mode No Archive Mode 
  Automatic archival Disabled 
  Archive destination USE_DB_RECOVERY_FILE_DEST 
  Oldest online log sequence 25 
  Current log sequence 27 
  SQL> show parameter log_archive_start 

  NAME TYPE VALUE 
  ———————————— ———– — ————————— 
  log_archive_start boolean FALSE 
  SQL> shutdown immediate; 
  Database closed. 
  Database dismounted. 
  ORACLE instance shut down. 

  SQL> startup mount; 
  ORACLE instance started. 

  Total System Global Area 3204448256 bytes 
  Fixed Size 1304912 bytes 
  Variable Size 651957936 bytes 
  Database Buffers 2550136832 bytes 
  Redo Buffers 1048576 bytes 
  Database mounted. 
  SQL> alter database archivelog; 

  Database altered. 

  SQL> alter database open; 

  Database altered. 

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

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • DZone
  • Netvouz
  • NewsVine
  • Technorati

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

AddThis Social Bookmark Button

Tags: ,