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 |
||
| (4 intermediate revisions by the same user not shown) | |||
| 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; | |||
== Other tips == | |||
[[/sqlplus help]] | [[/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/ | |||
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
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/
