Oracle: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
(Created page with "== Archive log == how to setup: http://www.beyondoracle.com/2008/05/08/setup-oracle-database-archivelog-mode/ sql plus: shutdown immediate; startup mount; alter database ...")
 
No edit summary
Line 11: Line 11:
  alter database archivelog;
  alter database archivelog;
  alter database open;
  alter database open;
examine:
archive log list;
select log_mode from v$database;


[[/sqlplus help]]
[[/sqlplus help]]

Revision as of 15:44, 6 January 2012

Archive log

how to setup:

http://www.beyondoracle.com/2008/05/08/setup-oracle-database-archivelog-mode/

sql plus:

shutdown immediate;
startup mount;
alter database archivelog;
alter database open;

examine:

archive log list;
select log_mode from v$database;

/sqlplus help