DBA task

₹600-1500 INR

Closed

Posted

about 3 years ago

₹600-1500 INR

Paid on delivery

This script is needed to avoid a DR server manual restore and bring the DBs online. The script I want it to do 1- by the time of emergency, SP will run and check the job history of restored jobs and identify which need to bring online(if it all then it will do for all) 2- after it identified which need to brought online - click the restore job - disable the restore job - it will bring the database online.

T-SQL (Transact Structures Query Language)

Project ID: 29386092

About the project

2 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

2 freelancers are bidding on average ₹1,025 INR for this job

@DBhut

Hello , I will do this project for you, i will write a script for your need to disbale and kick off restore jobs and bring your DR databases online at time of emergency , lets talk in chat and close this . Check out my profile ,iam a sql server architect with many years of eperience. give me chance wot work with you . you will never be disappointed . Thanks

₹1,000 INR in 1 day

4.9

(6 reviews)

3.6

@aakashwingz

12C and 18C RDBMS installation using Run Installer and Silent Installation. Creating Oracle Database using DBCA,Manual and Silent DBCA method. RMAN backups and recovery. Schema Refresh. RMAN Cloning. Tablespace management. RMAN point in time recovery. Good Knowledge on ASM. User Management. Profile Management. Creating meteialized views. Connecting to remote databases using DBlinks. Good knowledge on Oracle Dataguard. EXPDP/IMPDP. SPFILE and PFILE management. CPU patch. Adding datafiles in tablespace based on requirment. Making the database from Archivelog mode to No-Archivelog mode. Granting roles and privilages to database USERS. Good knowledge on LINUX,WINDOWS servers. Knowledge on LINUX command line. Good knowledge on SQL DEVELOPER tool. DGMGRL tool Knowledge on adding ASM disks. Used yum install to install ASM libs. Strong technical documentation skills. Good command over all the operating systems. Oracle Linux Installation Good knowledge on PostgreSQL and MySQL

₹1,050 INR in 7 days