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 are the different types of upgrades that can be performed in sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What types of replication are supported in sql server? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
who owns the operating system files created by the utl_file package?
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 the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how can you communicate with operating system files from oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is the importance of a recovery model? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
how can you record information about current session?
