JOB SUMMARY The successful candidate will be a member of the DBA team in the MIS Group involved in support and administration of Oracle and SQL Server databases and Oracle Application Server and a number of applications in use in College. BACKGROUND A position is available to a suitably qualified and experienced person to work as a database administrator in the MIS group. The position will be filled on a 3 year contract basis on [...]

Topics cover: 1. Describe the factors that affect planned and unplanned downtime. 2. Basic Components of Oracle Data Guard. 3. Difference between Physical and Logical backup. 4. Benefits of creating a Data Guard. 5. Use of Data Guard in high-availability architectures. Causes of Data Loss Hardware & System error’s Human errors Computer virus. Software corruption Natural disasters

Listing 2 Move the cursor to the right by using the arrows right, up, up then make the corrections. Move the cursor again right, up until you reach the end of the line. To correct this, we come to the last part of the command — part five, the options. Options allow you to specify that a search and replace are being performed globally on a line. It is odd to think of a search [...]

‘Making money is short-term, creating wealth is long-term’ ‘Making money is short-term, creating wealth is long-term’January 14, 2008 | 17:12 IST Making money is a short-term process, while creating wealth only happens�in the long run.�Vikas Khemani,�executive vice president and co-head, institutional equities, at Edelweiss, believes this is the only mantra for young investors to become wealthy in the long-term. “I have seen most young people these days call up their friends working in a stock [...]

channel d1: restoring datafile 00004 to /database/ORADUP/users01.dbf channel d1: restoring datafile 00005 to /database/ORADUP/jobs1_file1.dbf channel d1: restoring datafile 00007 to /database/ORADUP/jobs1_file2.dbf channel d1: reading from backup piece /database/rman/catalog/full/oradb1_bk_25_1_735912346 channel d2: starting datafile backup set restore channel d2: specifying datafile(s) to restore from backup set channel d2: restoring datafile 00001 to /database/ORADUP/system01.dbf channel d2: restoring datafile 00003 to /database/ORADUP/undo01.dbf channel d2: restoring datafile 00006 to /database/ORADUP/jobs2_file1.dbf channel d2: restoring datafile 00008 to /database/ORADUP/jobs2_file2.dbf channel d2: reading [...]

Vi: Search and Replace Change to normal mode with <ESC>. Search (Wraped around at end of file): Search STRING forward : / STRING. Search STRING backward: ? STRING. Repeat search: n Repeat search in opposite direction: N (SHIFT-n) Replace: Same as with sed, Replace OLD with NEW: First occurrence on current line: :s/OLD/NEW Globally (all) on current line: :s/OLD/NEW/g Between two lines #,#: :#,#s/OLD/NEW/g Every occurrence in file: :%s/OLD/NEW/g

Step 1. $ echo $ORACLE_SID ORADB1 Step 2: $ rman Step 3: connect catalog rmancat/dublin Step 4: connect catalog rmancat@rmancat Step 5: Register ORADB1 to RMANCAT catalog RMAN> connect target / Step 6: RMAN> show all; RMAN configuration parameters for database with db_unique_name ORADB1 are:

Create the new groups and users: groupadd oinstall groupadd dba groupadd oper groupadd asmadmin useradd -g oinstall -G dba,oper,asmadmin oracle passwd oracle Note. We are not going to use the “asmadmin” group, since this installation will not use ASM. Create the directories in which the Oracle software will be installed: mkdir -p /u01/app/oracle/product/11.1.0/db_1 chown -R oracle:oinstall /u01 chmod -R 775 /u01

Login as root and exec this command below. $:date -s “10/18/2010 11:07:00″

Wake on LAN: Quick Way to Power Up Computer Remotely Wake on Lan (WOL) is the implementation to power up your computer remotely from other computer within your home network or over the Internet by using special packet, called magic packet. On this article, I will show you how to power up your computer (remote computer) in your home network by using WOL implementation. Is there any requirement? You can only do this if that remote [...]