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 logical system in sap basis
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Can you redefine a table online?
internal architecture
how can you implement fine-grained auditing?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the diffrence between core dba and apps dba?
What the different components in replication and what is their use? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you enable flashback feature?
What is the difference between clustered and non-clustered index? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.