| Backup and Recovery [message #369250] |
Wed, 26 July 2000 05:20  |
Kevin McInerney
Messages: 7
Registered: July 2000
|
Junior Member |
|
|
Hi,
I'm trying to test our backup and recovery procedures but I have had a few problems on tests I thought would be simple.
I have created a table
added a couple of rows/ committed then backed up the database (seems ok)
then deleted all of the rows and tried to recover upto the point where the rows existed using
recover database until time .....
abd then opened using resetlogs
but the rows are still missing???.
I thought that the 'until' would stop the redo logs being applied before the rows where deleted?.
Can anyone please help
Kevin.
|
|
|
|
| Re: Backup and Recovery [message #369253 is a reply to message #369250] |
Wed, 26 July 2000 10:21  |
Marisol Balza
Messages: 1
Registered: July 2000
|
Junior Member |
|
|
Are you using RMAN to perform the backup?
If so, do you set the until clause before the restore?
Should be something like this:
run{
allocate channel 'SB_TAPE';
set until time = 'YYYY:MM:DD:HH:MI:SS'; (or your NLS_DATE_FORMAT)
restore database;
recover database;
sql "alter database open resetlogs";
release channel;
}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
