rman完全恢复

export nls_date_format=yy-mm-dd hh24:mi:ss

rman target /

Recovery Manager: Release 11.1.0.7.0 - Production on Thu Sep 6 21:57:00 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database (not started)

RMAN> set DBID=3817408875

executing command: SET DBID

RMAN> startup nomount

Oracle instance started

Total System Global Area 1068937216 bytes

Fixed Size 2166536 bytes
Variable Size 427819256 bytes
Database Buffers 624951296 bytes
Redo Buffers 14000128 bytes

RMAN> restore controlfile from '/oracle/rmanbackup/mydb/c-3817408875-20120831-00.ctl'
2> ;

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

RMAN> recover database until time "2012-09-01 14:00:00";

RMAN> list backup of archivelog all;

RMAN> alter database open resetlogs;

database opened

RMAN> shutdown immediate;

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22036495/viewspace-1059393/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22036495/viewspace-1059393/