Oracle: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
No edit summary
Line 20: Line 20:


Quick tour http://docs.oracle.com/cd/B19306_01/text.102/b14217/quicktour.htm
Quick tour http://docs.oracle.com/cd/B19306_01/text.102/b14217/quicktour.htm
mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884

Revision as of 21:11, 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

Quick tour http://docs.oracle.com/cd/B19306_01/text.102/b14217/quicktour.htm

mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884