Day: September 2, 2007

How To Move Online Redo Logs While Database Is Running

Issue You have online redo log files in the wrong place and want to move them. Solution Run the following SQL to locate the current redo log groups and their members: select l.group# group_number , l.status group_status , f.member group_member , f.status file_status from v$log l , v$logfile f where l.group# = f.group# order by […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Database, Oracle | 2 Comments

New Site

I am on call for work this week, and because I spend most of my on-call time at home, I have had a chance to play with setting up a new site. My postings have been rare as of late, and I will try to post more often. This blog will contain personal and technical […]

<span class="entry-utility-prep entry-utility-prep-cat-links">Posted in</span> Commentary | Leave a comment