------------查看数据-----------------
SQL> select * from gx;
NAME
----------
guoxiang
ggx
-------------删除数据---------------
SQL> delete gx;
2 rows deleted.
SQL> select * from gx;
no rows selected
-------------关闭数据库--------------
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
---------------使用rman恢复数据库时需要把数据库启动到mount状态---------------
SQL> startup mount;
ORACLE instance started.
Total System Global Area 159383552 bytes
Fixed Size 1218268 bytes
Variable Size 79694116 bytes
Database Buffers 75497472 bytes
Redo Buffers 2973696 bytes
Database mounted.
--------------------------修复数据库-------------------------
RMAN> restore database;
Starting restore at 24-JUL-2011 09:16:14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oracle/oradata/orcldb1/system01.dbf
restoring datafile 00005 to /u01/oracle/oradata/orcldb1/ggx1
channel ORA_DISK_1: reading from backup piece /home/oracle/ggx2/FULLBAK_ORCLDB1_20110723_530_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/ggx2/FULLBAK_ORCLDB1_20110723_530_1 tag=TAG20110723T225510
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /u01/oracle/oradata/orcldb1/undotbs01.dbf
restoring datafile 00003 to /u01/oracle/oradata/orcldb1/sysaux01.dbf
restoring datafile 00004 to /u01/oracle/oradata/orcldb1/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/ggx2/FULLBAK_ORCLDB1_20110723_531_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/home/oracle/ggx2/FULLBAK_ORCLDB1_20110723_531_1 tag=TAG20110723T225510
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 24-JUL-2011 09:17:26
---------------------------------做完全恢复---------------------------------
recover database;
恢复完成。
---------------------------------不完全恢复。------在修复数据库后直接恢复到一个时间点------------
需要设置一个时间格式:
需要注意''yyyy-mm-dd hh24:mi:ss'' 中的不是双引号,而是连个单引号。
RMAN> run { sql "alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";}
sql statement: alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''
-------------------------------恢复一个时间点---------------------------------
RMAN> recover database until time '2011-07-23 23:50:00';
Starting recover at 24-JUL-2011 09:27:23
using channel ORA_DISK_1
starting media recovery
archive log thread 1 sequence 4 is already on disk as file /u01/oracle/archive/1_4_757291390.dbf
archive log thread 1 sequence 5 is already on disk as file /u01/oracle/archive/1_5_757291390.dbf
archive log thread 1 sequence 6 is already on disk as file /u01/oracle/archive/1_6_757291390.dbf
archive log thread 1 sequence 7 is already on disk as file /u01/oracle/archive/1_7_757291390.dbf
archive log filename=/u01/oracle/archive/1_4_757291390.dbf thread=1 sequence=4
archive log filename=/u01/oracle/archive/1_5_757291390.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:05
Finished recover at 24-JUL-2011 09:27:31
-----------------------------------打开数据库-----------------------------------
SQL> alter database open resetlogs;
Database altered.
恢复完成。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25517773/viewspace-730292/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25517773/viewspace-730292/