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 / muhammad masood
1-HOT BACKUP AND COLD BACKUP
2- Cold
3- No... Should take complete backup as no incarnation
level is defined.
4- No without Archive loging.
| Is This Answer Correct ? | 34 Yes | 1 No |
Post New Answer View All Answers
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What the different topologies in which replication can be configured? : sql server DBA
What are the commands used in dcl? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What is the default port no on which sql server listens? : sql server DBA
What is a correlated sub-query? : 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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
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
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
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
how does an oracle clusterware manage crs resources?