siva


{ City } chennai
< Country > india
* Profession * dba
User No # 19040
Total Questions Posted # 2
Total Answers Posted # 1

Total Answers Posted for My Questions # 3
Total Views for My Questions # 14690

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 1
Questions / { siva }
Questions Answers Category Views Company eMail

what is incremental checkpoint?

CTS,

1 DB Administration 8145

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

CTS,

2 DB Administration 6545



Answers / { siva }

Question { 2900 }

if monday take full backup and tuesday it was cumulative
backup and wednesday we taken incremental backup, thursday
some disaster happen then what type of recovery and how it
will take?


Answer

You can recover using this command

Rman>restore database;
Rman>recover database;

Rman automatically applied appropriate backups,ther is no
need apply specific backup.

regards
siva

Is This Answer Correct ?    0 Yes 1 No