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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Can you redefine a table online?
Explain about your sql server dba experience? : sql server DBA
How do you open a cluster administrator? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
what functionality does oracle provide to secure sensitive information?
what is the use of recording information about current session?
who owns the operating system files created by the utl_file package?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What happens on checkpoint? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
how does an oracle clusterware manage crs resources?