Recover table in 12c using RMAN

If one has RMAN backups, recovering table my be as easy as this:

1. For log sequence number:

RMAN> CONNECT TARGET "<ID@DB> AS SYSBACKUP";

          UNTIL SEQUENCE <LOG SEQ Number> THREAD <Thread>

          AUXILIARY DESTINATION <PATH>

          REMAP TABLE <REMAP SCHEMA:TABLE>:<TOSCHEMA:TABLE>;

RMAN>  RECOVER TABLE <Schema>.<TABLE> OF PLUGGABLE DATABASE <DB>

2.Point in time:

RMAN> CONNECT TARGET "<ID@DB> AS SYSBACKUP";

RECOVER TABLE <Schema>.<TABLE>

UNTIL TIME 'SYSDATE-1'

AUXILIARY DESTINATION '<PATH>'

DATAPUMP DESTINATION '<PATH>'

DUMP FILE 'DUMPFILE'

NOTABLEIMPORT;

Above option create dumpfile and doesnot import data because of NOTABLEIMPORT option.

More later!!!!

Oracle PGA & Swaping on host

10g:

*If see swaping  on oracle db host. Check how much PGA is being utilized.

How:
Select sum(PGA_ALLOC_MEM) from V$process;

Above shows current allocated PGA.

*SGA size
>Show SGA



If total of PGA+SGA is greater than memory, you have nailed the problem 'DB process is the issue'.


Recently we saw swapping happening on one of our DB host. Suspecting PGA is the culprit we found PGA utilization was actually about the same as defined by 'pga_aggregate_target'. Issue discovered was huge pages was defined much higher than required by SGA, causing PGA to swap. Fix was simple, reconfigure huge pages.

Commands used :
cat /proc/meminfo

Modify:
cat sysctl.conf parameter hugepages
eg:
vm.nr_hugepages=20

Either reboot or use /sbin/sysctl -p to reload and kick off the hugepages configuration.

Android app to watch movies

Android app to watch movies

App is 'Movie Tube HD' downloadable from play store. Excellent app built on You tube content/movies. Absolute delight of people on the move, watch movie anywhere, anytime.

https://play.google.com/store/apps/details?id=com.media.movi.tube

Corporate JunkYard

"Inspired by Dilbert and the world around me ........"

Corporate restructuring:

Truck on the road going @ 60km/hr, speed limit also 60km/hr. Driver felt truck's running heavy, stopped on the side, asked his helper how to resolve the issue.

Helper: Boss lets remove the rear tires.:-)

Driver: Very smart, lets do it :-)

Android Application Recomendations

Best thing that happened to mobile

My Favorite Mobile Applications:                                                              

*Google cloud print.
Enable remote printing from any device(laptop/mobile/Tab etc).

*Life 360
Fantastic replacement for Google Latitude(retired). One can add family and see them on map anytime in almost realtime. Offers customizable update intervals, emergency alerts and social chat.


* Yahoo Cricket

Absolutely fantastic application, has everything that is going on with the game.  One can click 'follow' button on an upcoming match and your android will let you know everything happening during the match fours,sixes,wickets etc. No need to keep app or mobile on.

I have this installed on my Samsung S3 and Tab2 devices. No match can go past me Yahoooooo!!!!.

* GPS Test: This is one app that lets me know every(almost/not sure what is missing) detail related GPS postion. I can see longitude/latitude, local time, compass, local/utc/etc time, etc and most beautiful piece how many satellite are visible to my mobile.

* Evernote : This is one stop notes application for me. I use it on all my devices and information is available to me when I want and where I want. Awesome. Highly recommended.

I use it on my Mac, Windows laptop(home) and all my android devices(mobile and tab).

* TouchDown Mail App: This my email application for work. It is probably the best email application for exchange. Loaded with features to make work life easier. More on features later.

* K-9 Mail: This is my personal email account application. I have all my google,yahoo emails configured on it. Very easy to work with, have using it for few years now and very impressed with the features offered and the ease of configuring email accounts.

* Milage : Great application to track milage of your vehicle.

* My Purchases: If one has bought lot of applications from 'Play Store', very difficult to keep track of all purchased applications in case you reset/change your device. This application really helpful to keep track of ones inventory of purchased applications.

* Yahoo weather: My top application to keep track of weather, perhaps the best available in its category.

* Aquarium: My favorite live wall paper on mobile. Fishes running around with astounding backgrounds. I don't miss having a personal aquarium of exotic fishes.