Hot backup procedure?

Question Posted / kittu_chintu2005

2 Answers
4859 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hot backup procedure?..

Answer / kittu_chintu2005

Startup mount
Alter database archive log;
Alter database begin backup;
Alter tablespace ts_name begin backup;
Copy the *.dbf & *.ctl files @ os level when copying completed issue the statement “alter database end backup;”

Is This Answer Correct ?

4 Yes

2 No

Hot backup procedure?..

Answer / 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

More DB Administration Interview Questions

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers

What background process refreshes materialized views?

2 Answers Accenture, FLSmidth,

Name three advisory statistics you can collect.

1 Answers

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers

How would you go about verifying the network name that the local_listener is currently using?