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 / gangaram
1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.
Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
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?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is the role of dip user in our database?
Can you redefine a table online?
what is a user-defined lock?
What would you do with an "in-doubt" distributed transaction?
what is asm?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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 do you trace the traffic hitting a sql server? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
Query processing is slow(eg select query)how will u solve that
how can a session indicate its interest in receiving alerts?