Oracle: Difference between revisions

From Federal Burro of Information
Jump to navigationJump to search
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 16: Line 16:
  archive log list;
  archive log list;
  select log_mode from v$database;
  select log_mode from v$database;
== Other tips ==


[[/sqlplus help]]
[[/sqlplus help]]
Line 22: Line 24:


mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884
mysql's \G vertical output: https://forums.oracle.com/forums/thread.jspa?threadID=923884
sqlplus for windows - setting it up right http://www.williamrobertson.net/documents/sqlplus-setup.html
formatting output http://blog.tanelpoder.com/2007/08/07/sqlplus-is-my-second-home-part-1-htmlizing-your-sqlplus-output/

Latest revision as of 22:50, 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;

Other tips

/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

sqlplus for windows - setting it up right http://www.williamrobertson.net/documents/sqlplus-setup.html

formatting output http://blog.tanelpoder.com/2007/08/07/sqlplus-is-my-second-home-part-1-htmlizing-your-sqlplus-output/