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
- 27593 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit bhagat
1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
which background process invoke at the time of upgradation tell me???
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 do you understand by flashback feature of oracle?
What are the operating modes in which database mirroring runs? : sql server DBA
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.
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
What are the different ways you can create databases in sql server? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you process messages in order asynchronously?
What types of replication are supported in sql server? : sql server DBA
What is transparent data encryption? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
