-
How can recover row delete the table having archivelog mode , bad not having rman.
-
-
I remember when this place was cool.
-
example
sql> select count(1) from tabla;
500 rows select
sql> delete from tabla;
500 rows delete
sql> commit;
i want recover data having archivelog mode.
thanks
-
Point in time recovery. Check the manuals on how to do it. BTW, you don't need RMAN to perform PITR.
Or, as Jeff allready suggested, use Log Miner.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
i run the command
svrmgrl> recover database until time 'date:hour:';
svrmgrl> alter database open noresetlogs;
but i didn't function.
-
Originally posted by cazpa
i run the command
svrmgrl> recover database until time 'date:hour:';
You must specify the time in the following format: 'YYYY-MM-DD:HH24:MI:SS'. No exceptions to this rule, only this date format will be accepted.
svrmgrl> alter database open noresetlogs;
You cant use NORESETLOGS after incomplete recovery. You must open your database with:
ALTER DATABASE OPEN RESETLOGS;
As I said, you realy should spend some time with your manuals if you are serious about backup&recovery.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
is clear dad format is
recover database until time '2001-02-05:12:43:00';
alter database open resetlogs;
but i didn'n function
-
What kind of error messages?
Did you restore your database?
Jeff Hunter
-
therd are no errors :
SVRMGR> recover database until time '2001-02-05:12:43:00';
Media recovery complete.
SVRMGR> alter database open resetlogs;
Statement processed.
but my table doesn't have rows.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|