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
- 27037 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amsu
4. No you can't take online backup while database in
NOARCHIVELOG mode.
5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how to restore files with rman?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How would you extract DDL of a table without using a GUI tool?
what is the use of ocr?
what are the benefits of flashback feature?
what is a crs resource?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How would you go about verifying the network name that the local_listener is currently using?
What would you do with an "in-doubt" distributed transaction?
What is dbcc? : 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
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
