What are things which play major role in designing the backup strategy?
Submitted by: AdministratorCold backup: shutdown the database and copy the datafiles with the help of
O.S. command. this is simply copying of datafiles just like any other text file
copy.
Holt backup: backup process starts even though database in running. The
process to take a hot backup is
1) sql> alter database begin backup;
2) copy the datafiles.
3) after copying
sql> alter database end backup;
Begin backup clause will generate the timestamp. it'll be used in backup
consistency i.e. when begin backup pressed, it'll generate the timestamp. During
restore, database will restore the data from backup till that timestamp and
remaining backup will be recovered from archive log.
Submitted by: Administrator
O.S. command. this is simply copying of datafiles just like any other text file
copy.
Holt backup: backup process starts even though database in running. The
process to take a hot backup is
1) sql> alter database begin backup;
2) copy the datafiles.
3) after copying
sql> alter database end backup;
Begin backup clause will generate the timestamp. it'll be used in backup
consistency i.e. when begin backup pressed, it'll generate the timestamp. During
restore, database will restore the data from backup till that timestamp and
remaining backup will be recovered from archive log.
Submitted by: Administrator
Read Online Oracle RMAN Job Interview Questions And Answers
Top Oracle RMAN Questions
☺ | What are RTO, MTBF, and MTTR? |
☺ | How to enable the encryption for RMAN backups? |
☺ | How RMAN improves backup time? |
☺ | Explain what is Channel? How to enable the parallel backups with RMAN? |
☺ | How to setup the physical stand by database with RMAN? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |