在dos下
1、svrmgrl
2、connect system/manager as sysdba;
3、shutdown abort;
4、recover database until time '2003-11-11 08:00:00';
1、svrmgrl
2、connect system/manager as sysdba;
3、shutdown abort;
4、recover database until time '2003-11-11 08:00:00';
调试欢乐多
1 If the database is opened, shut it down by using either the NORMAL
or IMMEDIATE or TRANSACTIONAL options.
2 Mount the database.
3 Restore all data files from backup (the most recent if possible):
UNIX> cp /disk1/backup/*.dbf /disk1/data/
UNIX> cp /disk2/backup/*.dbf /disk2/data/
UNIX> ...
NT> copy c:\backup\*.dbf c:\data\
NT> copy d:\backup\*.dbf d:\data\
NT> ...
4 You may need to restore archived logs. If there is enough space
available, restore to the LOG_ARCHIVE_DEST location or use the
ARCHIVE SYSTEM ARCHIVE LOG START TO <LOCATION>
or SET LOGSOURCE <LOCATION> to change the location.
5 Recover the database:
Note: LogMiner can help you to find the right time of the delete
statement.
SQL> recover database until time ‘1999-03-
09:11:44:00’;
ORA-00279: change 148448 ...02/29/98 17:04:20
needed for thread
ORA-00289: suggestion : /disk1/archive/
arch_6.rdo
ORA-00280: change 148448 for thread 1 is in
sequence #6
Log applied.
...
Media recovery complete.
6 To synchronize data files with control files and redo logs, open
database by using RESETLOGS option:
SQL> alter database open resetlogs;
SQL> archive log list;
...
Oldest online log sequence 0
Next log sequence to archive 1
Current log sequence 1
SVRMGRL> connect internal;
SVRMGRL> SHUTDOWN IMMEDIATE;
SVRMGRL> STARTUP MOUNT;
SVRMGRL> recover database until time '2003-11-10:07:59:30';
SVRMGRL> ALTER DATABASE OPEN resetlogs;这就可以了。
SVRMGRL> connect internal;
SVRMGRL> SHUTDOWN IMMEDIATE;
SVRMGRL> STARTUP MOUNT;
SVRMGRL> recover database until time '2003-11-10:07:59:30';
SVRMGRL> ALTER DATABASE OPEN resetlogs;