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
- 24559 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / binod
Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..
FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
how can you process messages in order asynchronously?
how can you get actual data change values from previous transactions in oracle?
Explain about your sql server dba experience? : sql server DBA
Where would you look for errors from the database engine?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what functionality does oracle provide to secure sensitive information?
What are the different sql server versions you have worked on? : sql server DBA
What are the recovery models for a database? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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?
how can you find out if a table can be redefined?
