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 / muhammad masood
1-HOT BACKUP AND COLD BACKUP
2- Cold
3- No... Should take complete backup as no incarnation
level is defined.
4- No without Archive loging.
| Is This Answer Correct ? | 34 Yes | 1 No |
Post New Answer View All Answers
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what are the types of connection load-balancing?
what is the use of recording information about current session?
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
How would you go about verifying the network name that the local_listener is currently using?
which background process invoke at the time of upgradation tell me???
What is a correlated sub-query? : sql server DBA
What is the default fill factor value? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?