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?
4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?
Answer Posted / srihari macha
1. Backup are Cold and Hot.
2. Cold Backup
3. No.
4. No.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
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.
What would you do with an "in-doubt" distributed transaction?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
How do you open a cluster administrator? : sql server DBA
How to start SQL Server in minimal configuration mode?
Where would you look for errors from the database engine?
what is the use of ocr?
How do you trace the traffic hitting a sql server? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?