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
- 24560 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What authentication modes does sql server support? : sql server DBA
What is dbcc? : sql server DBA
how can you implement fine-grained auditing?
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
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what are the benefits of flashback feature?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the operating modes in which database mirroring runs? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
how does an oracle clusterware manage crs resources?
when does an alert gets signaled?
Where do you find the default index fill factor and how to change it? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the recovery models for a database? : sql server DBA
