Month: September 2009

nonsense correlation

I was doing a little light reading on my Saturday night in my Oxford Dictionary of Statistics by Graham Upton and Ian Cook and came across this definition:nonsense correlation: A term used to describe a situation where two variables (X and Y, say) are correlated without being causally related to one another. The usual explanation is that they are both related to a third variable, Z. Often the

nonsense correlation

I was doing a little light reading on my Saturday night in my Oxford Dictionary of Statistics by Graham Upton and Ian Cook and came across this definition:nonsense correlation: A term used to describe a situation where two variables (X and Y, say) are correlated without being causally related to one another. The usual explanation is that they are both related to a third variable, Z. Often the

Data Modelling & Scalability

For what I call Enterprise Class Applications, scalability is an important factor. Scalability can occur in multiple directions – increases in user count, transaction volume, database size. These can occur individually or in combination together. The…

Data Modelling & Scalability

For what I call Enterprise Class Applications, scalability is an important factor. Scalability can occur in multiple directions – increases in user count, transaction volume, database size. These can occur individually or in combination together. The…

mock-ups, prototypes and production builds

(I can’t talk about planes going off on tangents but I’ve moved them all to the end this time. Read them in whatever order works for your brain – or skip ’em. They’re not crucial to the post.)While I didn’t get to work on the SR-71 or the F-117, I had the opportunity to work with men who did. One particular man, Walt Paskowietz, became something of a mentor/champion for me and taught me about

mock-ups, prototypes and production builds

(I can’t talk about planes going off on tangents but I’ve moved them all to the end this time. Read them in whatever order works for your brain – or skip ’em. They’re not crucial to the post.)While I didn’t get to work on the SR-71 or the F-117, I had the opportunity to work with men who did. One particular man, Walt Paskowietz, became something of a mentor/champion for me and taught me about

Interrupting Flashback Database

So a user called me up and said he was flashing back a database and he was not too happy with the amount of time it was taking to complete the operation and so he did a Ctrl-C…When he tried to open the database this is what he saw..==================…

Interrupting Flashback Database

So a user called me up and said he was flashing back a database and he was not too happy with the amount of time it was taking to complete the operation and so he did a Ctrl-C…

When he tried to open the database this is what he saw..

==================================================================================

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 838860800 bytes
Fixed Size 2033832 bytes
Variable Size 520099672 bytes
Database Buffers 310378496 bytes
Redo Buffers 6348800 bytes
Database mounted.
ORA-38760: This database instance failed to turn on flashback database

SQL> alter database flashback off;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashback database

===>… Well he just turned off flashback..

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

==================================================================================

Looking through the alert.log

Fri Sep 18 08:35:05 2009
flashback database to restore point TEST_AFTER
Fri Sep 18 08:35:05 2009
ORA-38757 signalled during: flashback database to restore point TEST_AFTER…
Fri Sep 18 12:00:48 2009

No errors in the RVWR process trace file

So I just dropped the restore point and voila

> drop restore point TEST_AFTER;

Restore point dropped.

> select flashback_on from v$database;

FLASHBACK_ON
——————
NO

> alter database open;

Database altered.

quick catch up on peoplesoft

It’s been a while since I posted anything to do with my "beloved" Peoplesoft…umm… well, you know what I mean…Some might recall this post a while ago? It’s where I discussed our approach to this common problem with scratchpad tables in Peoplesoft.Anyways: some developments I reckon could be of use to anyone going through the same problem.I’ve since had a good exchange with Dave Kurtz where

quick catch up on peoplesoft

It’s been a while since I posted anything to do with my "beloved" Peoplesoft…umm… well, you know what I mean…Some might recall this post a while ago? It’s where I discussed our approach to this common problem with scratchpad tables in Peoplesoft.Anyways: some developments I reckon could be of use to anyone going through the same problem.I’ve since had a good exchange with Dave Kurtz where

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569