Tuesday, August 24, 2004

xbindkeys

xbindkeys

A great meta-key for use with XBindkeys is the "Windows" key, which sits idly on so many keyboards. Chances are it's unused, so it won't conflict with anything. Say you have a script called "backup" that you like to run manually. This is how to bind it to the "Windows" and F5 keys with XBindkeys.

Run the command:

$ xbindkeys -mk

Then, press the "Windows" key; then, F5; then, q to quit. It will generate keycodes like this:

--- Press "q" to stop. ---
"NoCommand"
m:0x50 + c:115
Mod2+Mod4 + Super_L
"NoCommand"
m:0x10 + c:71
Mod2 + F5

Choose one line from each set of keycodes, and make this entry in $HOME/.xbindkeysrc:

"backup"
m:0x50 + c:115 + m:0x10 + c:71

Now, when you press the "Windows" and F5 keys, your backup script will run.

Sunday, August 01, 2004

Oracle - Turning archive logging on and off

Start.

1. add the following to init.ora file

log_archive_start = true
log_archive_dest = /path/to/archive/dir
log_archive_format = _%s.log

2. Starting archive logging

startup mount exclusive
alter database archivelog;
alter database open;

3. Check to make sure
SQL> archive log list
Database log mode ARCHIVELOG
Automatic archival ENABLED
Archive destination /path/to/archive/dir
Oldest online log sequence 2
Current log sequence 3

Stop.

1.
startup mount exclusive
alter database noarchivelog;
alter database open;
2.
SQL> archive log list
Database log mode NOARCHIVELOG
Automatic archival ENABLED
Archive destination /path/to/archive/dir
Oldest online log sequence 2
Current log sequence 3
SQL>