I was looking at the RMAN DEBUG options and came across the CHECKSYNTAX function which I had not used before.
Firstly a quick recap on the DEBUG option.
This can be called using the following syntax
rman target / catalog rman12g1/xxxx@rmancat debug trace=rmantrace.log cmdfile=backup.rcv
rman target / catalog rman12g1/xxxx@rmancat debug trace=rmantrace.log then run RMAN> @backup.rcv (or just type in your run block of commands)
There are a number of options (more...)
The Enterprise Manager AWR Warehouse is designed to hold performance data from multiple databases for long-term analysis. It promoses that it will save storage and improve performance on your production systems. In that it is indeed correct. However the warehouse itself does not seem to be performant when taking in multiple sources and retaining them long-term – 400 days in our case. Why 400 days is an obvious question that might be asked. Primarily because (more...)
I am currently interested in managing storage on our Exadata platform which is primarily used for running a data warehouse.
The ongoing challenge is that most of the large tablespaces use a bigfile datafile and we insert data using append. That causes data gaps within the datafile and it is constantly growing. A recent example showed a 7Tb datafile containing only 2Tb of data and yet the ASM diskgroups were reporting we were running out (more...)
I attempt to export a table with 76,000 rows using a relatively standard datapump command
expdp schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp include=table:"IN('ORDM_ERROR_COUNTS')" parallel=8 logfile=OEC.log
It fails with a fatal error and also produces a warning
Connected to: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management and OLAP options
Starting “ODI_TEMP”.”SYS_EXPORT_SCHEMA_03″: odi_temp/******** schemas=ODI_TEMP cluster=y directory=MCB content=ALL dumpfile=OEC_%U.dmp (more...)
Today an application team had a problem with a production system and they wanted the database restored to a point a couple of days ago. It is a configuration management system and they figured they could lose any changes . Their call.
I did all the good things
- Checked we had a change in place
- Blacked out primary and standby in OEM
- Checked flashback was on –
select flashback_on from v$database;
- Checked how far we could (more...)
Back in Nov 2015 I commented on a Oracle-L discussion about What happened to SQL*Developer SQL Formatter asking why people liked to see a comma at the beginning of the line in sql code and there was a fair bit of input into how it was easier to use and amend – think of it like bullet points was one comment.
Fair enough I though and I have used that technique when I remember ever (more...)
What is the difference between the summaries of disk space on these two systems? Look at the free_usable_file_MB column and free space
ASMCMD [+] > lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED NORMAL N 512 4096 4194304 72769536 2031032 433152 798940 0 N DATA_PEX0/ MOUNTED NORMAL N 512 4096 4194304 128286720 20004028 2672640 8665694 0 N DATA_PEX1/
Group Diskgroup Total Req'd Free (more...)
I saw this from an Oracle account manager who I deal with.
Oracle’s regional price lists are based on a constant Dollar based price list, and these are usually recalculated at the beginning of each financial quarter. Given the recent sharp decline in the £ against the $, I’m expecting an increase of roughly 15% for Oracle’s next financial quarter, beginning September.
For illustration, a single Oracle DB EE license has a current GBP list (more...)
I was showing some basic sqlplus connection tips to a new DBA starter today and my normal warning about putting the password on the line when calling sqlplus didn’t produce what I expected.
For ever and a day if you have entered a line within a server session such as when using putty or similar to this :-
and then ‘host’ to the unix shell and run a ps -ef|grep sqlplus you will (more...)