The Heap™ – Consultancy ©®

« first day (2764 days earlier) ← previous day next day → last day (2400 days later) »

Michael Green

05:39

@ConcernedOfTunbridgeWells I cracked a dad joke yesterday. Got a deadpan "Ha. Ha. Ha." from my 6 y.o. Proudest moment yet.

hot2use

06:18

morning

McNets

06:48

morning

Andriy M

07:01

Morning

1 hour later…

Colin 't Hart

08:09

Morning

The review queues can use some lovin'.

hot2use

08:21

Done sum' lovin'

Andy K

08:45

evening and morning

ConcernedOfTunbridgeWells

08:57

Morning all

Philᵀᴹ

10x Web Dev. LOLOLOLOL

dezso

09:19

@Philᵀᴹ you mean it's you?

Philᵀᴹ

10:01

Interesting: theregister.co.uk/2018/07/27/tachyums_prodigy_cpu

Paul White

10:34

morning

Philᵀᴹ

Hmm, i really need GETDATE() to return something different just for 1 session for a few minutes

hot2use

10:50

Why do people always write "...reduce costs by 3x...".

You can't mathematically reduce costs by 3x.

Unless you get a 2x payback.

Costs : 1'000'000
3x    : 3'000'000 -
       ___________
Total :-2'000'000
       ===========

@JackDouglas Here a glimpse of the incarnation history of one of my Oracle instances as seen from the central RMAN Catalog:

    DB_KEY  DBINC_KEY NAME     RESETLOGS_CHANGE# RESETLOGS_TIME      CUR PARENT_DBINC_KEY STATUS   PATH
---------- ---------- -------- ----------------- ------------------- --- ---------------- -------- --------------------------------------------------------------------
    149427     149428 TESTTEST                 1 2018-05-16 09:45:24 NO                   PARENT    -> 149428
    149427     318894 TESTTEST           1857895 2018-06-05 16:31:53 NO            149428 ORPHAN    -> 149428 -> 318894

Philᵀᴹ

11:11

I'm not all read-up on incarnations, but would all that cause big rman headaches?

Jack Douglas

@hot2use impressive

also impressive that you are using an rman catalog at all

db<>fiddle has a new skin, and probably some new bugs.

hot2use

It's easier to restore database back to points in time, when you have a database (RCATALOG) that can keep history for 2 years back.

Jack Douglas

yes that's that main advantage, isn't it

hot2use

Yes, Control Files are somewhat limited.

Jack Douglas

I've always thought it's an odd thing to rely on an oracle database to recover an oracle database though

is your catalog on completely different hardware?

it's certainly an extra level of complexity

hot2use

11:22

The productive catalog is on test hardware, but is set up and configured to be backed up like a productive instance.

@Philᵀᴹ No, not really.

@Philᵀᴹ You just have to be aware (for example) that restoring to a point in time requires you to set the database to the corresponding incarnation (time wise) along the timeline of your current path.

My current path is : -> 149428 -> 403476 -> 478893 -> 593840 -> 920295 -> 1039459

If I look at the incarnation history and I want to restore back to 2018-07-03 13:00:00 then I would have to set my database to the corresponding incarnation (After nearest RESETLOGS_TIME)

In this case I would have to RESET DATABASE TO INCARNATION 403476; in RMAN before restoring the database instance.

Oh sorry, here the statement to retrieve incarnation history from CATALOG database:

select DB_KEY, DBINC_KEY, NAME, RESETLOGS_CHANGE#, RESETLOGS_TIME, CURRENT_INCARNATION, PARENT_DBINC_KEY, STATUS, SYS_CONNECT_BY_PATH(DBINC_KEY, ' -> ') Path from CATALOG_122.RC_DATABASE_INCARNATION
WHERE NAME = 'TESTTEST'
AND LEVEL >=1
START WITH DBINC_KEY = '149428' CONNECT BY PRIOR DBINC_KEY = PARENT_DBINC_KEY order by Level, Path, RESETLOGS_TIME;

Here the query for the database specific incarnation information in your local instance:

select
    INCARNATION#,
    PRIOR_INCARNATION#,
    RESETLOGS_CHANGE#,
    RESETLOGS_TIME,
    STATUS,
    SYS_CONNECT_BY_PATH(INCARNATION#, ' -> ') Path
    FROM v$database_incarnation
    WHERE LEVEL >=1 START WITH INCARNATION# = '1'
        CONNECT BY PRIOR INCARNATION# = PRIOR_INCARNATION#
    ORDER BY LEVEL, Path, RESETLOGS_TIME;

taken from What is an orphan incarnation?

4 hours later…

Andy K

15:23

cya

Evan Carroll

15:44

HALLOOOO MY PEOPLE

sp_BlitzErik

16:22

explain yourself

Evan Carroll

16:34

hahahahahah

how cool

See... FORTH is THAT COOL

Ohh I found the PDF

atarimania.com/documents/…

You just gave me reading material.

sp_BlitzErik

16:50

@EvanCarroll y/w

Evan Carroll

FORTH is a fun language. I'll create you a FORTH.NET

then you can use it too.

so I have this idea to rewrite youtube-dl

sp_BlitzErik

then what?

Evan Carroll

Into something that integrates like Adblock into the browser for element selection, with a mechanism to create/test download based on a standardized format which it can export.

jcolebrand

@Philᵀᴹ you around?

Q: Storing huge amount of user game data

So I have this side project of mine which relies on me agreggation User game data from an API. What I want to store is the player encouters with other players and saving the result of those encounters aswell. The issue is that the only solution i have managed to come up is to create a Table for ...

Evan Carroll

And with a technology set that allows it to run in parallel.

jcolebrand

17:05

Do we need to remove the comments? I agree that comments are transient, but these do tell a story of learning.

Evan Carroll

The site has an unspoken policy about making comments disappear and moving the facts into answers/questions, stories are for story time!

I kind of agree with that policy too. In fact, generally I think removing all content that won't help subsequent users and search engines is a good thing.

4 hours later…

Sergiy Kolodyazhnyy

20:50

O.o . . . .o.O . . . . mighty quiet here, I see

ypercubeᵀᴹ

@SergiyKolodyazhnyy we are not talking so much lately

summer.

or winter.

Sergiy Kolodyazhnyy

I see, it's either too cold or too hot to talk :)

Well, hello world, regardless

Sergiy Kolodyazhnyy

21:10

May I ask how's my script ? unix.stackexchange.com/a/459453/85039

ypercubeᵀᴹ

@SergiyKolodyazhnyy ok but you don't need the DISTINCT when you have GROUP BY. The subquery could be removed, too

SELECT letter, COUNT(*) AS lcount, COUNT(DISTINCT number) AS dcount
FROM data
GROUP BY letter ;

Sergiy Kolodyazhnyy

21:33

That's far simpler

Well, as you can see I'm still just noobing my way through the basics.

ypercubeᵀᴹ

Feel free to edit your answer.

Sergiy Kolodyazhnyy

Ditto. Thanks :)

2 hours later…

Wildcard

23:34

I have a question that's probably off-topic for the main site but just want to check if anyone's heard of such a thing:

Is there any standalone command line tool that can do math with dates and times and intervals the way PostgreSQL does?

I think if the Postgres date/time/interval operators were wrapped up in a standalone tool, it would be a godsend to a lot of sysadmins.

I would love to be able to use those operators (e.g. date - date = interval) in shell scripts and such. :)

« first day (2764 days earlier) ← previous day next day → last day (2400 days later) »

all rooms

Transcript for

Jul29

Jul '1830

Jul31

General on- and off-site discussion for dba.stackexchange.com....

frogs mysql nosql oracle postgresql sqlite sql-server

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC