Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
Answer Posted / kittu
1. Logical Backups(traditional backups of oracle)export/import, datapump physical backup hot backup(online backup), cold backup(offline backup), RMAN backup
2. cold backup & logical backups
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the default fill factor value? : sql server DBA
what is grd?
What are the different sql server versions you have worked on? : sql server DBA
how can you record information about current session?
What the different types of replication and why are they used? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
what is a user-defined lock?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how does an oracle clusterware manage crs resources?