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 / sree
1. physical and Logical backup
2.cold backup
3.No.. we can't take partial backup in no archivelog mode
4.No... we can't take online backups if the database running in noarchivelog mode.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
how can you enable flashback feature?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is fill factor? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : 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?
how can you create a user-defined lock?
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 is dcl? : 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?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what are the benefits of flashback feature?
What are the recovery models for a database? : sql server DBA