Which types of backups you can take in Oracle?

2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?

3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?

4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?

Answer Posted / vinay prakash

1.cold backup, hot backup

2.cold backup

3.No

4. no (in Archivelog mode backup is in online)

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

3797


What is dbcc? : sql server DBA

775


how can you implement fine-grained auditing?

598


How to start SQL Server in minimal configuration mode?

6942


What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

587






What are the different types of upgrades that can be performed in sql server? : sql server DBA

678


how can you enable flashback feature?

532


What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

2100


Explain about your sql server dba experience? : sql server DBA

543


what is the role of dip user in our database?

2043


how can you connect from 10g user to 11g user??

1681


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

1535


Where would you look for errors from the database engine?

2349


Why would you use sql agent? : sql server DBA

575


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3305