Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nagesh yadav
1)Database should be in archivelog mode
2)we can take the hot backup at tablespace level or database
level
3)when we kept in begin backup mode performance will be poor
so take the backup at tablespace level.
4)alter tablespace tablespace_name begin backup; OR
5)alter database begin backup;
Note:- Don't add datafiles in begin backup
select status from v$backup;
If status is active means its is in begin backup mode.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is asm?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What happens on checkpoint? : sql server DBA
how can you enable flashback feature?
what do you understand by fine-grained auditing?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are statistics, under what circumstances they go out of date, how do you update them?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is replication? : sql server DBA
how can you implement fine-grained auditing?
Can you redefine a table online?
Which autogrowth database setting is good? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
