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
- 27483 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
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Which autogrowth database setting is good? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Where do you find the default index fill factor and how to change it? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
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?
internal architecture
how to restore files with rman?
what do you understand by flashback feature of oracle?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the operating modes in which database mirroring runs? : sql server DBA
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.
what functionality does oracle provide to secure sensitive information?
What is a system database and what is a user database? : sql server DBA
