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?
- 1 Answers
- 4163 Views
- I also Faced
- E-Mail Answers
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
how can you record information about current session?
how can you connect from 10g user to 11g user??
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
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
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
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.
how can you implement fine-grained auditing?
what is the use of ocr?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
internal architecture
how can you communicate with operating system files from oracle?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
