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?
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
internal architecture
what functionality does oracle provide to secure sensitive information?
What is the difference between clustered and non-clustered index? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how does an oracle clusterware manage crs resources?
what is the use of ocr?
Query processing is slow(eg select query)how will u solve that
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what are the differences of where and if in SAS?
Where would you look for errors from the database engine?
Explain about your sql server dba experience? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the operating modes in which database mirroring runs? : sql server DBA