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
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 do you understand by fine-grained auditing?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
what is asm?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Explain materialized views and how they are used.
how does an oracle clusterware manage crs resources?
What are the different ways you can create databases in sql server? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how can you get actual data change values from previous transactions in oracle?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
