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?
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 ora 24313?what is the procedure to exclude that error?
what is asm?
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.
Query processing is slow(eg select query)how will u solve that
What is the difference between clustered and non-clustered index? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What is a correlated sub-query? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What the different components in replication and what is their use? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is the default fill factor value? : sql server DBA
Can you redefine a table online?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
internal architecture