Pavan DBA's Blog

The DBA Knowledge Store

RMAN & User managed Backup and Recovery

Posted by Pavan DBA on July 17, 2015

1. Explain the difference between a hot backup and a cold backup and the benefits associated with each.
A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is shut down and does not require being in archive log mode. The benefit of taking a hot backup is that the database is still available for use while the backup is occurring and you can recover the database to any point in time. The benefit of taking a cold backup is that it is typically easier to administer the backup and recovery process. In addition, since you are taking cold backups the database does not require being in archive log mode and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

2. You have RMAN database backup excluding controlfiles. how you will proceed for recovery?
We can manually create controlfile with new location for datafiles and redolog files (or if we already know the location, we can use that) and once controlfile is created, we can mount the database, restore the database and switch datafiles. Finally use resetlogs to open the database.

Posted in RMAN, backup n recovery | Tagged: , , , , | Leave a Comment »

Oracle DBA [6+ yrs] in Hyderabad

Posted by Pavan DBA on June 30, 2015

We have an Openings with Polaris Financial Tech Ltd Hyderabad at the level of Oracle DBA.

Location – Hyderabad
Experience – 6+ Years
Joining Time – Immediately


Good experience as Oracle DBA
Expertise in core DBA actitivies, Installation, Configuration,
Maintenance, back up recovery, performance tuning.
Expertise in installing oracle 9i/10g/11g,
Should have experience with Oracle 12c as well,
Must have experience in RAC and RMAN
Good exp. with Dataguard

If you are interested , Please send me your updated resume along with below details.

1. Current CTC
2. Expected CTC
3. Notice Period


Neha Gupta
Eresource Infosolution

Posted in Jobs | Leave a Comment »

Oracle APPS DBA [6+ yrs] in Hyderbad

Posted by Pavan DBA on June 30, 2015

Oracle Apps DBA
6+ Years – Hyderabad
Oracle Application DBA and Adminstration skills. Must have worked in production support or implementation support.
Apps DBA + Core DBA
Unix scripting/Weblogic/SOA
Excellent written and verbal communication skills are mandatory.

If you are interested please share your updated profile along with the following details asap. to

Total & Relevant Experience:-
Current CTC:-

Expected CTC:-

Notice Period:-

Current Location:-
Are you will to work on Contract position:-

Posted in Jobs | Leave a Comment »

Oracle DBA with RAC [4-5 yrs]

Posted by Pavan DBA on June 30, 2015

Job Description : Oracle Core DBA With RAC

Oracle Database Administration support for production systems and provide DBA services to application teams and database production support. Provide DBA support with a high degree of customer service, technical expertise, and timeliness. Provide accurate and creative solutions to user problems of moderate nature to ensure user productivity. Should have good knowledge in RAC, ASM/CRS, Database refresh, Database patching, troubleshooting DB issues. Performance tuning, Exadata and Exalogic experience is preferred. Should have good analytical and communication skills

Minimum Experience: 4 Maximum Experience :5
Primary Skill : Oracle Core DBA
Job Location : Blr /HYD

Work Location : Bangalore.

Candidate should join within in 30 Days

If the above req suites you pls send u r update profile to
Need to fill all these below mentioned skill experience

1.Notice Period : 30 days
2.Total Years of Experience in Oracle Core DBA :
3.Relevant Exp in RAC & ASM :
8.Current CTC & Expected CTC:
9.Notice period (Should join in 30 Days):
8,Ready to work on contract basis through inetframe payroll Y/N: Yes

Thanks & Regards,


iNetFrame Technologies Pvt. Ltd.
#185 “ISHTA” – 1st floor,
17th Main Road,
Banashankari II Stage, Bangalore-560 070
Contact No: : 26971300/325

Posted in Jobs | 2 Comments »

Oracle APPS DBA [6+ yrs] in Hyderabad

Posted by Pavan DBA on June 30, 2015

Location: Hyderabad
Type: Permanent

6+ years’ experience as an Applications DBA.

 Excellent hands on experience working directly with end customers.

 Ability to work independently.

 Excellent practical experience in all routine DBA tasks including health checks, patching,

cloning, troubleshooting issues and installations.

 Willing to work in the night shift (from around 10 pm to 6 am) on a rotation basis.

 Will be on-call 24 x 7.

 Ability to execute the following:

o Install the EBusiness suite, R12

o Install and administer the EBusiness database.

o Experience with 11.5.9, and R12 required.

o Experience with database versions 9i,10g,11g and 12c (required)

o Experience with RAC/ASM and RAW devices. (strongly recommended)

o Patch prerequisite analysis.

o Apply Oracle apps patches, rollup patches.

o Properly install custom forms and reports upon developer requests.

o Perform RMAN backup and recovery.

o Create RMAN scripts for automated backups

o Oracle apps hot backup and point in time recovery.

o Perform Oracle apps user and security administration.

o Install Oracle apps custom triggers, alerts, reports, and forms.

o Know how to do traces, and find poorly performing SQL.

o Identify and possibly rewrite poorly performing SQL.

o Capable of taking performance reports and doing formal write-ups for a client.

o Setup and interpret AWR reports.

o Knowledge of Service Request escalation and management.

o Past experience with discovering new Oracle database bugs. (strongly recommended)

o Experience with multiple VPN’s. (strongly recommended)

BE/BTech/ME/MTech in Computer Science, Engineering or related technical discipline preferred

Please fill the below details

Total Exp:
Relevant Exp:
Current Location:
Current CTC:
Expected CTC:
Notice Period:
Phone Number:
Mail Id:

Thanks & Regards,
Narendra Reddy M
Sriven Info Consultants India Pvt. Ltd.
Madhapur, Hyderabad, India
Email :
Phone: 040 – 45639952, +91 9492525819

Posted in Jobs | 2 Comments »


Get every new post delivered to your Inbox.

Join 3,798 other followers

%d bloggers like this: