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
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 are the commands you'd issue to show the explain plan for "select * from dual"?
what are the benefits of flashback feature?
What the different components in replication and what is their use? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the default fill factor value? : sql server DBA
what is the use of ocr?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how can you schedule a job in database?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
who owns the operating system files created by the utl_file package?
What the different types of replication and why are they used? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.