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?
- 1 Answers
- 3644 Views
- I also Faced
- E-Mail Answers
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
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you process messages in order asynchronously?
what is ora 24313?what is the procedure to exclude that error?
What is a system database and what is a user database? : sql server DBA
How to start SQL Server in minimal configuration mode?
what is a user-defined lock?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
how can you communicate with operating system files from oracle?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
