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 / amit bhagat
6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.
| Is This Answer Correct ? | 4 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?
what is asm?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what are the performance views in an oracle rac environment?
What are the commands used in dcl? : sql server DBA
how can you communicate with operating system files from oracle?
What is the default port no on which sql server listens? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the different ways you can create databases in sql server? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
What is a correlated sub-query? : sql server DBA
what is the diffrence between core dba and apps dba?
What is dcl? : sql server DBA
What is replication? : sql server DBA