| one of the intrview questions could any one give answers plz [message #243254] |
Wed, 06 June 2007 11:02  |
srinivasy
Messages: 1
Registered: May 2007
Location: Hyderabad
|
Junior Member |
|
|
Hi to every one,
i am srinivas , i am new to oracle dba and i am trying to get the job on oracle dba.
i have few question. could any one answer it please. this question i faced in the interview.
1. one of my db user want to connect the oracle server. but oracle is rejecting this connection. how can you iedntify it. where you would see the error message.
i said in alert log file.. it is corrct.
2. i am using oracle 10g. i have a 2 days back backup. and . yesterday i took one full export(expdp). to day morning at 11 i lost the datafile in the database(user/system). how can you get the entire data back.
how can i do it.
could any one please answer my question...
thnaks,
|
|
|
|
| Re: one of the intrview questions could any one give answers plz [message #243283 is a reply to message #243254] |
Wed, 06 June 2007 14:23  |
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
|
Senior Member |
|
|
| Quote: | 2. i am using oracle 10g. i have a 2 days back backup. and . yesterday i took one full export(expdp). to day morning at 11 i lost the datafile in the database(user/system). how can you get the entire data back.
how can i do it.
|
if your database is in archivelog mode then your recover to the point of failure means 11 o'clock
by restoring the perivious back and then by applying archivelogs.
if your database is NOARCHIVE mode then you cant reover it 11 oclock.
|
|
|
|
| Re: one of the intrview questions could any one give answers plz [message #243285 is a reply to message #243283] |
Wed, 06 June 2007 14:52 |
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
|
Senior Member |
|
|
1. one of my db user want to connect the oracle server. but oracle is rejecting this connection. how can you iedntify it. where you would see the error message.
You can check in the listener.log file... for network connections.
2. i am using oracle 10g. i have a 2 days back backup. and . yesterday i took one full export(expdp). to day morning at 11 i lost the datafile in the database(user/system). how can you get the entire data back
If your db in Archivelog mode you can recover till time, as they have explicitily mentioned about export ... It means you have to restore whole database from backup and then again you have to import, so you can recover data till yesterday.....
HTH
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
