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
Explain materialized views and how they are used.
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is logical system in sap basis
Can you redefine a table online?
what functionality does oracle provide to secure sensitive information?
how can a session indicate its interest in receiving alerts?
What are statistics, under what circumstances they go out of date, how do you update them?
what do you understand by fine-grained auditing?
Why would you use sql agent? : sql server DBA
what are the benefits of flashback feature?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
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.
How would you extract DDL of a table without using a GUI tool?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.