Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
- 11 Answers
- 24566 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
what are the benefits of flashback feature?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
how can you create a user-defined lock?
Explain materialized views and how they are used.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is a system database and what is a user database? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Explain about your sql server dba experience? : sql server DBA
what functionality does oracle provide to secure sensitive information?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How would you go about verifying the network name that the local_listener is currently using?
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
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
