No 5) shut immediate startup mount alter database archivelog

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?

Question Posted / m.madhusudan reddy

11 Answers
27924 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

Please Help Members By Posting Answers For Below Questions

What are the different sql server versions you have worked on? : sql server DBA

1068

Which autogrowth database setting is good? : sql server DBA

1236

what do you understand by flashback feature of oracle?

1041

how to restore files with rman?

2355

how can you generate profile of pl/sql applications to identify performance bottlenecks?

1123

How do you trace the traffic hitting a sql server? : sql server DBA

1627

How to start SQL Server in minimal configuration mode?

8077

Explain materialized views and how they are used.

2496

What is a correlated sub-query? : sql server DBA

1154

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

2346

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1160

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1135

Query processing is slow(eg select query)how will u solve that

8032

what is asm?

1110

What is dcl? : sql server DBA

1316