Pavan DBA's Blog

The DBA Knowledge Store

opening for Corporate Security [3-8 yrs]

Posted by Pavan DBA on May 19, 2016


1

2

3

send your resumes to mymailbox.21@gmail.com before 26th May 2016.

Posted in Jobs | Leave a Comment »

BPO referral walkin [0-8 yrs] in Cognizant

Posted by Pavan DBA on May 19, 2016


1

2

3

Please send ur cv’s to mymailbox.21@gmail.com to obtain reference details.

Posted in Jobs | Leave a Comment »

BPO referral [1-3 yrs] in Cognizant

Posted by Pavan DBA on May 19, 2016


1

2

please send resumes to mymailbox.21@gmail.com. Mention subject line as “BPO referral for Cognizant”

Note: Resumes must be sent only with the mentioned subject line. any others will not be considered.

Posted in Jobs | Leave a Comment »

Referral walkin for Java Developer [3-8 yrs] in Pune

Posted by Pavan DBA on May 19, 2016


1

2

please send resumes to mymailbox.21@gmail.com for reference.

Posted in Jobs | Leave a Comment »

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 »

 
Follow

Get every new post delivered to your Inbox.

Join 4,392 other followers

%d bloggers like this: