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
- 27943 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
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.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Why would you call update statistics? : sql server DBA
which background process invoke at the time of upgradation tell me???
What is the default fill factor value? : sql server DBA
how can a session indicate its interest in receiving alerts?
how can you schedule a job in database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you process messages in order asynchronously?
what is a user-defined lock?
How to start SQL Server in minimal configuration mode?
Where would you look for errors from the database engine?
what is ora 24313?what is the procedure to exclude that error?
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
how can you record information about current session?
