hi, how can i check all backups are exist to restore? I.e.
i forget to take backup on one day. But now i want to check
that all backups are there to restore now. I know the
answer of through timestamps we know how to check. But i
need any other way?
Answer Posted / kamal
if full backup has been taken , you can restore at any
time . if differential has been taken checkup the last full
backup date then verify diff. backup has been taken
immediate after that or not if not find the date & time for
which it was left and take diff. backup of that .
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the recovery models for a database? : sql server DBA
what is grd?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
. 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?
what functionality does oracle provide to secure sensitive information?
what is a user-defined lock?
which background process invoke at the time of upgradation tell me???
how can you enable flashback feature?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What the different components in replication and what is their use? : 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.
What are the commands used in dcl? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain materialized views and how they are used.
what is a crs resource?