db-blog.web.cern.ch
Datafile without backups - how to restore? | Databases at CERN
http://db-blog.web.cern.ch/blog/szymon-skorupinski/2015-01-datafile-without-backups-how-restore
Databases at CERN blog. Databases at CERN blog. Datafile without backups - how to restore? Have you ever had a problem with restoring datafiles without any backups available? It's easy, of course if you have all archived logs from the time datafile was created. Please check it here: Re-Creating Data Files When Backups Are Unavailable. Moreover, RMAN is clever enough to create empty datafile automatically during restore phase and then recover it using archived logs. So far, so good, but. Solution with all...
db-blog.web.cern.ch
Heat Map Visualization of Latency Histograms for NetApp C-Mode | Databases at CERN
http://db-blog.web.cern.ch/blog/luca-canali/2015-07-heat-map-visualization-latency-histograms-netapp-c-mode
Databases at CERN blog. Databases at CERN blog. Heat Map Visualization of Latency Histograms for NetApp C-Mode. This post is about collecting and visualizing I/O latency histograms for NetApp. The drill down of I/O latency is an important technique for troubleshooting and benchmarking storage. Average latency values can hide details. Representing latency histograms over time is a 3-D visualization problem and can be nicely solved using heat maps. This has been discussed in details by Brendan Gregg in .
minersoracleblog.wordpress.com
GoldenGate 12 – Classic, Coordinated and Integrated Replicat | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/03/07/goldengate-12-classic-coordinated-and-integrated-replicat
Rick Miners' Oracle Blog. GoldenGate 12 – Classic, Coordinated and Integrated Replicat. This entry was posted on March 7, 2014, in GoldenGate. I New Replicat Modes Availalble in GolgenGate 12.1. The new Coordinated and Integrated Replicats can help you achieve transactions being applied in parallel on the target database without having to manually split out tables into multiple replicats. Let’s take a look at the difference in the replicat modes. Constructs logical change records (LCR) that represent sou...
minersoracleblog.wordpress.com
Using dstat for monitoring CPU, Memory, Disk, etc | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/10/15/using-dstat-for-monitoring-cpu-memory-disk-etc
Rick Miners' Oracle Blog. Using dstat for monitoring CPU, Memory, Disk, etc. This entry was posted on October 15, 2014, in Linux. Dstat is a good tool for replacing vmstat, netstat, iostat, and ifstat. It it a very lightweight tool that can consolidate and correlate data that you would normally have to capture in different terminals. I’ve used dstat before in the past to monitor backup throughput over interfaces. Of course, this is possible if the backups are going to disk. CPU, Load, Disk I/O and Memory.
minersoracleblog.wordpress.com
GoldenGate Initial-Load Direct Load | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/05/24/goldengate-initial-load-direct-load
Rick Miners' Oracle Blog. GoldenGate Initial-Load Direct Load. This entry was posted on May 24, 2013, in GoldenGate. And tagged OGG Initial Load. This article will demostrate how to perform a OGG Initial Load using the Direct Load technique. Other Initial Load techniques and their advantages and disadvantages can be found here. OGG is installed on source and target systems. OGG : 11.2.1.0.1. Database : 11.2.0.3. Linux : OEL 6 ( 64 bit ). 1 Configure the initial-load processes. GGSCI start extract csoea.
minersoracleblog.wordpress.com
Oracle GoldenGate Initial Load Techniques | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/05/23/oracle-goldengate-initial-load-techniques
Rick Miners' Oracle Blog. Oracle GoldenGate Initial Load Techniques. This entry was posted on May 23, 2013, in GoldenGate. And tagged OGG Initial Load. In order to start using OGG replication, the source and target databases must be in sync. This means that the source data must be copied over to the target and remain in sync while changes are occurring in the source database. So, why is a native tool recommended? General Steps for Performing an Initial-Load. 1 The continuous standard extract for replicat...
db-blog.web.cern.ch
Add new comment | Databases at CERN
http://db-blog.web.cern.ch/comment/reply/64
Databases at CERN blog. Databases at CERN blog. Which shared memory segments belong to my database instance? How important is to test your backup strategy and restore/recovery procedures, but while doing so, you could of course encounter some problems, not really related with the recoverability as such. Recently, we've got such a problem on our recovery server, at the very beginning of an automatic restore (database name masked):. ORA-1092 : opitsk aborting process. Because output of ipcs. Sysresv IPC Re...
minersoracleblog.wordpress.com
Changing Timezone Settings on Oracle Database Servers | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/09/19/changing-timezone-settings-on-oracle-database-servers
Rick Miners' Oracle Blog. Changing Timezone Settings on Oracle Database Servers. This entry was posted on September 19, 2014, in Oracle. These settings shown were valid for DB 11.2.0.2 and above on Redhat/Oracle Linux 6. Look at /etc/localtime to see the timezone setting for the server. The. Setting should be set to an entry in the /usr/share/zoneinfo directory/subdirectory. Ls -lhF /etc/localtime lrwxrwxrwx 1 root root 35 May 9 17:54 /etc/localtime - /usr/share/zoneinfo/America/Chicago. Incorrect SYSDAT...
minersoracleblog.wordpress.com
Mapping problem with compressed update record – Key column missing from update | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2013/12/20/mapping-problem-with-compressed-update-record-key-column-missing-from-update
Rick Miners' Oracle Blog. Mapping problem with compressed update record – Key column missing from update. This entry was posted on December 20, 2013, in GoldenGate. Here’s an example of an update statement failing on the target database on a table without a primary or unique key. Since there are no keys defined on the table, the replicat will consider all the columns as key columns. Doing some research on My Oracle Support turned up the following two notes that were used to come up with a solution. Here&...
minersoracleblog.wordpress.com
GNU screen Command | Rick Miners' Oracle Blog
https://minersoracleblog.wordpress.com/2014/07/29/gnu-screen-command
Rick Miners' Oracle Blog. This entry was posted on July 29, 2014, in Linux. The screen utility can be used to start a session that will be persistent if the terminal is lost, plus it also provides the ability to login from another computer simply by attaching to the screen session name. Here are some essential commands to know:. Start new session with a name and a log file. Screen -S name -L. Attach to a running session. Screen -d -R name. Leave a Reply Cancel reply. Enter your comment here. Oracle Golde...