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
- 27604 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / binod
Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..
FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
internal architecture
What are the different ways you can create databases in sql server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
how can you communicate with operating system files from oracle?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are statistics, under what circumstances they go out of date, how do you update them?
how can you find out if a table can be redefined?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What types of replication are supported in sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
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?
