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
- 27113 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Where do you find the default index fill factor and how to change it? : sql server DBA
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 record information about current session?
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 are the different ways you can create databases in sql server? : sql server DBA
how can you find out if a table can be redefined?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Query processing is slow(eg select query)how will u solve that
. 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 is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you process messages in order asynchronously?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
