Home » RDBMS Server » Server Administration » Backup and Recovery
Backup and Recovery [message #369250] Wed, 26 July 2000 05:20 Go to next message
Kevin McInerney
Messages: 7
Registered: July 2000
Junior Member

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

Re: Backup and Recovery [message #369253 is a reply to message #369250] Wed, 26 July 2000 10:21 Go to previous message
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:

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;
Previous Topic: Storing MS Word files in Oracle8 database
Next Topic: Re: Creating an ASCII file (line size -- 2000 chars) in PL/SQL
Goto Forum:

Current Time: Sun May 26 10:00:09 CDT 2024