Question I
Edward uses an Oracle Database to maintain the inventory of his grocery store. Once every week, he runs a batch job to insert, update and delete data in his database. He uses a Windows machine running Oracle 9i R2. Edward starts the database up in the morning at 8 A.M., and shuts it down at 5 P.M., and operates the database all day in NOARCHIVELOG mode. He takes an offline backup (cold backup) of the database once a week, or every Sunday by copying all the datafiles, log files and control files to tape.

I.1. On a Wednesday morning, Edward realized that he had lost a datafile that contained all the user data. He tried to start up the database using the STARTUP OPEN command got the following error
ORA-01157 :cannot identify datafile 4 – file not found
ORA-01110: datafile 4 :’………………………/users01.dbf’
He realized that he had accidentally deleted one of the datafiles while trying to free some space on the disk.
a) How would he resolve this problem ?
How much data would you lose ?
c) Write down the steps you would perform to recover your database

I.2. Same as I.1 but the data file belonged to a temporary tablespace.
ORA-01157 :cannot identify data file 6 – file not found
ORA-01110 :datafile 6 : ‘…………………………./temp.dbf’
a) How would he resolve this problem ?
How much data would you lose ?
c) Write down the steps you would perform to recover your database

Question II
Smith is the DBA of a real-time call-tracking system. He uses Oracle 9i R2 on a Windows machine and takes an online backup of the database every night. The total database size is 50GB and the real-time call tracking system is a heavy OLTP system primarily with the maximum activity between 9 a.m and 9 p.m., everyday. At 9 p.m. a batch job runs a command procedure that puts the tablespaces in hot backup mode, takes the backup of all the datafiles to tape at the operating system level, and then issues the alter tablespace end backup command.

II.1. One afternoon a disk crashed, losing the SYSTEM tablespace residing on the disk. As this happened at the peak processing time, Smith had to keep the down time to a minimum and open the database as soon as possible. He wanted to start the database first and then restore the datafile that was lost, so he took the SYSTEM data file offline. When he tried to open the database he got the following error:
ORA-01147 : SYSTEM tablespace file 1 is offline
Write down the steps you would perform to recover your database

II.2. Let’s assume that instead of a system data file, a non-system data file is lost due to the disk crash (datafile number 4, datafile name users01.dbf)
Write down the steps you would perform to recover your database

Question III
Rama is a DBA in a banking firm. She administers an Oracle 9i R2 database on a Windows Server. She stores all the user data in the USERS tablespace, index data in the INDEXES tablespace, and undo data in the UNDOTBS tablespace. In addition, she has other tablespaces to store data for various banking applications. Since the database operates 24*7, she has an automated procedure to take online backups every night. In addition, she takes an export once a month of all the important tables in the database.
On Monday morning, due to a media failure, all the data files that belong to the tablespace UNDOTBS was lost. It was the beginning of the week and a lot of applications needed to be run against the database, so she decided to do an online recovery. Once she took the datafile offline and opened the database, she tried to select from a user table and got the following error:
ORA-00376 : file 2 cannot be read at this time
(File 2 happens to be one of the datafiles that belong to the tablespace UNDOTBS)
How would you perform a recovery ? write down the required instructions

Question IV
Anna works in a software company as a DBA to administer a small development database on a Windows server. She created a 500MB database.
She decided to mirror the control files but not the online redo logs, so created the database with three log groups with one member each. Her backup strategy includes taking online backups twice a week and a full database export once a week.
A power surge caused the database to crash and also caused a media failure, losing all the online log files. All the data files and the current control files are intact.
How would you perform a recovery ? write down the required instructions

Question V
In this problem scenario, our DBA has mistakenly dropped a production tablespace. Our mission is to recover this dropped tablespace to the most recent commit possible, where
 Daily backups are available.
 RMAN catalog is available.
 DBA accidentally dropped a production tablespace
o Drop tablespace tools;
Your mission is to recover the database to just before the DROP, using RMAN

وين الشباب معقول ولا رد وين أهل الخبرة

هذه أسئلة إحترافية


حدا يجبر بخاطرنا و إذا بيعرف شي يجاوب

أو حتى يناقش

The most appropriate thing to solve these problems is[يسار][/يسار]

To take course in oracle dba
:lol: :lol:

do are you do an interview
Indirectly
:o

In this case you will found many answer for this easy Q

:(

هذه أسئلة إحترافية
مين القال لك هذه أسإلة إحترافية