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 / 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 |
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
How do you trace the traffic hitting a sql server? : sql server DBA
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you get actual data change values from previous transactions in oracle?
how can you record information about current session?
When a user process fails, what background process cleans up after it?
orra 1555 what is this error,why it is occur?
Where would you look for errors from the database engine?
Describe what redo logs are.
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)