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
What types of replication are supported in sql server? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what is logical system in sap basis
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
what is the role of dip user in our database?
Where do you find the default index fill factor and how to change it? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What are the operating modes in which database mirroring runs? : sql server DBA
internal architecture
Why would you call update statistics? : sql server DBA
which background process invoke at the time of upgradation tell me???
What is the difference between dropping a database and taking a database offline? : sql server DBA
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 functionality does oracle provide to secure sensitive information?