Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 27590 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / uki
DB can be turned to archive log mode by turning the
LOGRETAIN parameter to RECOVERY and/or USEREXIT to YES. DB
will be in backup pending state which in turn requires to
be taken an offline backup to bring back the db to normal.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How do you open a cluster administrator? : sql server DBA
how can you create a user-defined lock?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
how can you process messages in order asynchronously?
What is a system database and what is a user database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What purpose does the model database server? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
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 performance views in an oracle rac environment?
