Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 3926 Views
- I also Faced
- E-Mail Answers
Answer Posted / braj123
--> Restore the monday full backup+tuesday cumulative
backup+wednesday Incremental backup.(bcz cumulative and
incremental clears the archives every backup).
--> Recover the database
--> reset the logs
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what do you understand by flashback feature of oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What is the importance of a recovery model? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
what is asm?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
what is the role of dip user in our database?
. 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?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How can you control the amount of free space in your index pages? : sql server DBA
how can a session indicate its interest in receiving alerts?
which background process invoke at the time of upgradation tell me???
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
when does an alert gets signaled?
