| online backup [message #172281] |
Mon, 15 May 2006 15:28  |
nunnoo
Messages: 4
Registered: May 2006
|
Junior Member |
|
|
I want to restore a backup of production into my test environment.The backup was done in online mode.Do I need the archived redo after the backup in order to restore the DB or can I just do a restore and then resetlogs.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: online backup [message #172430 is a reply to message #172427] |
Tue, 16 May 2006 08:02  |
nunnoo
Messages: 4
Registered: May 2006
|
Junior Member |
|
|
I did an online backup with archived logs , the backup is on the BCV ( Third volume in an EMC arrays).The archived log is on tape.I might not be able to recover the archived logs from tape .After I restore my backup , I do not a point in time as this is test, Can I open the database with resetlogs option or do I most definitily need the archived redo.
Rgds
|
|
|
|
| Re: online backup [message #172431 is a reply to message #172430] |
Tue, 16 May 2006 08:07 |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
If you don't care about losing the data in the archive logs, you can most certainly do a point-in-time-recovery and OPEN RESETLOGS.
Just CANCEL recovery when it asks for the first archive log and then OPEN RESETLOGS.
[Updated on: Tue, 16 May 2006 08:07] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
