I got hit by a ransomware attack, that destroyed my server. Thankfully I have keep really good backups and was able to just wipe the server and restore my backups. Some configuration information was lost, so it’s taking me a big to get all the bugs worked out. The good news is I didn’t lose …
Category Archive: Uncategorized
May 20
RMAN table recovery error
I had a user delete the data in a table that they didn’t mean to. It took them a week to notify us, so no chance to use flashback to get the data back. I was not looking forward to restoring 100TB of datafiles and recovery logs just to restart a couple GBs of data. …
Sep 17
Getting and formatting index ddl
This is a little useful sql I used this morning for stripping out all the additional information that dbms_metadata.get_ddl outputs. This strips the create index statements down to their bare bones.
Jan 24
wrong number or types of arguments in call to ‘CHECKDATAFILEFORSTANDBY’
I started seeing this today in one of our databases I found metalink article 2360045.1 which states that it is a catalog version mismatch, however running upgrade catalog doesn’t resolve the problem. I remember hitting this error a long time ago, and although I can’f find the reason why, running upgrade catalog two times in …
Sep 13
TDE Wallet on RAC
So I have been having trouble getting the oracle wallet to auto open, and it’s always messed up in gv$encryption_wallet select * from gv$encryption_wallet; INST_ID WRL_TYPE WRL_PARAMETER STATUS WALLET_TYPE WALLET_OR FULLY_BAC CON_ID ———- ———— ———————- ————- ———- ———— —— 4 FILE OPEN AUTOLOGIN SINGLE NO 0 1 FILE OPEN AUTOLOGIN SINGLE NO 0 3 FILE …
Sep 09
DBSNMP long running query
I noticed a long running query in one of my databases this morning. SELECT TABLESPACE, ROUND ( ( (max_size_mb – used_space + free_space_mb) / max_size_mb), :”SYS_B_00″) * :”SYS_B_01″ AS pct_free FROM ( SELECT ts.tablespace_name TABLESPACE, ROUND (SUM (NVL (fs.bytes, :”SYS_B_02″))) / :”SYS_B_03″ / :”SYS_B_04″ free_space_mb, ROUND (SUM (df.bytes)) / :”SYS_B_05″ / :”SYS_B_06″ used_space, ROUND ( …
Jan 04
Monitoring Online ASM Datafile Moves
I’m moving a ~7TB database online as the development group that uses it doesn’t want to take any down time. Thankfully the database isn’t horribly active right now so moving the data files online isn’t causing a huge problem. The only other times I have moved data files online was in an incredibly busy database …
Mar 28
Now on SSL
I have moved this site over to a secure connection. LetsEncrypt offers free SSL certificates for your website! The setup was a bit of a pain because I have a non-standard configuration for this server, but after a little poking and prodding, we are now running on https.
Jun 08
Rushing = Stupid Mistakes
I am currently being asked to refresh a database. The end users are pissed because they asked for the database to be refreshed at noon yesterday, this was the first they had asked for it, and they were doing “really important things” and by 3pm were pissed that I hadn’t responded to them, let alone …
Recent Comments