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
Where do you find the default index fill factor and how to change it? : sql server DBA
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?
What is the difference between clustered and non-clustered index? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the default port no on which sql server listens? : sql server DBA
What is fill factor? : sql server DBA
who owns the operating system files created by the utl_file package?
What is a system database and what is a user database? : 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?
What are the commands you'd issue to show the explain plan for "select * from dual"?
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?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What happens on checkpoint? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA