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 / 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
What authentication modes does sql server support? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How do you open a cluster administrator? : sql server DBA
how does an oracle clusterware manage crs resources?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
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 is the role of dip user in our database?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the differences of where and if in SAS?
Can you redefine a table online?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Why would you call update statistics? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
what is asm?