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 / 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 |
how can you generate profile of pl/sql applications to identify performance bottlenecks?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you open a cluster administrator? : sql server DBA
What is blocking and how would you troubleshoot it?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
why Datapump is faster than traditional export and import
How to make a replica of existing oracle server to another server?