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
- 27114 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
What is a system database and what is a user database? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is the difference between the 2 operating modes of database mirroring? : 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 to restore files with rman?
What authentication modes does sql server support? : sql server DBA
what is the use of recording information about current session?
what are the differences of where and if in SAS?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Where do you find the default index fill factor and how to change it? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
what are the types of connection load-balancing?
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.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
what are the benefits of flashback feature?
