| restore subset of database [message #162368] |
Thu, 09 March 2006 22:24  |
chandanbhamra
Messages: 84
Registered: April 2005
Location: India
|
Member |
|
|
Hi All,
I want to know if its possible to restore subset of database not whole database like if i have backup of 1 month(say january) and i want to restore data of only 10 days and that of not first 10 days but of in between 10(say 10th to 20th) days.
Is it possible to do this ?
Thanks & Regards
Chandan Singh
|
|
|
|
|
|
| Re: restore subset of database [message #162462 is a reply to message #162368] |
Fri, 10 March 2006 06:46  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
>> not whole database like if i have backup of 1 month(say january) and i want to restore data of only 10 days and that of not first 10 days but of in between 10(say 10th to 20th) days.
Hypothetically speaking,
You have table of 30 rows that went through DML for about a month (10 rows per week).
So now you want to restore any of those 10 rows (with all delta changes) and ignore the rest 20 rows? It is not called restoration. You are using wrong terminology. Please read the documentation. Look into logminer.
>>if its possible to restore subset of database not whole database
Depends on how you define the 'subset of database'.
defintion1: With RMAN you can restore selected tablespaces instead of whole database.
defintion2: POINT-IN-TIME restoration of a whole database. You can restore a database to a particular point in time , say as of
20th of last month.
defintion3: Subset of a table. Do a TSPITR. from there you can get a subset of a table using exp/imp. like export only the MANAGERS from EMP table.
As TarunDua said,
NO. You cannot do TSPITR between two frames.
You can do two seperate clones. One as of 20th. another as of 10th. Then you have to do the deltas.
Else do logminer.
This URL gives a short and clear idea about Logminer.
http://home.clara.net/dwotton/dba/logminer.htm
| Quote: |
Oracle logminer is a tool which enables you inspect the contents of the Oracle Redo logs. In particular it shows every DML statement (insert, update, delete, etc.) issued against the database, together with the necessary SQL statements for rolling them back. It can be very useful for debugging, auditing, or reversing specified transactions.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
