what r the types of backup?
Answers were Sorted based on User's Feedback
Answer / kittu_chintu2005
logical backup: export/import from 10g datapump
physical backup: cold backup, hot backup & RMAN backup
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / srinivas
In sqlserver 8 types of backups
1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. file and file group backup
7. copy only backup
8. partial backup
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rohit bhosale
In SQL server 2008 we have following types of backup:
1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mahinder singh
Type of backup
1. Normal backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)
2. copy backup(A complete set of all files you wish to
back up. Think of this as your 'reference set'. You only
need perform a full backup occasionally.)
3. incremental backup(A backup of those files which have
changed since the last backup of any type.)
4. differential backup(A backup of those files which have
changes since the last full backup. Should be performed at
regular intervals.)
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / suman
three types of backups that is
1.physical backup:cold backup and hot backup
2.logical backup: export/import utility provided by oracle
3.Rman backup
Is This Answer Correct ? | 1 Yes | 0 No |
who owns the operating system files created by the utl_file package?
any body know about orawaves do they really provide placements in their unique placement program
what is grd?
What are the different types of indexes available in sql server? : 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.
Which autogrowth database setting is good? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
How many memory layers are in the shared pool?
what is the use of home directory???
Explain an ORA-01555
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What are statistics, under what circumstances they go out of date, how do you update them?