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
- 27939 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 are the different types of upgrades that can be performed in sql server? : sql server DBA
What is fill factor? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
how can you create a user-defined lock?
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.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What authentication modes does sql server support? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the diffrence between core dba and apps dba?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What the different types of replication and why are they used? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
Query processing is slow(eg select query)how will u solve that
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
