不完全恢复

Recovery Manager complete. $ rman target usr/pwd@sid1 catalog /@sid2 Recovery Manager: Release 10.2.0.1.0 - Production on Thu Feb 1 10:36:30 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. connected to target database: grid (not mounted) connected to recovery catalog database RMAN> restore controlfile from autobackup; Starting restore at 2007-02-01 10:36:46 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=155 devtype=DISK recovery area destination: /u01/app/oracle/flash_recovery_area database name (or database unique name) used for search: GRID channel ORA_DISK_1: autobackup found in the recovery area channel ORA_DISK_1: autobackup found: /u01/app/oracle/flash_recovery_area/GRID/autobackup/2007_01_31/o1_mf_s_613328375_2w0pmqyr_.bkp channel ORA_DISK_1: control file restore from autobackup complete output filename=/u01/app/oracle/oradata/grid/control01.ctl output filename=/u01/app/oracle/oradata/grid/control02.ctl output filename=/u01/app/oracle/oradata/grid/control03.ctl Finished restore at 2007-02-01 10:36:50 RMAN> alter database mount; database mounted released channel: ORA_DISK_1 RMAN> restore database; Starting restore at 2007-02-01 10:37:30 Starting implicit crosscheck backup at 2007-02-01 10:37:30 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=155 devtype=DISK Crosschecked 7 objects Finished implicit crosscheck backup at 2007-02-01 10:37:32 Starting implicit crosscheck copy at 2007-02-01 10:37:32 using channel ORA_DISK_1 Crosschecked 3 objects Finished implicit crosscheck copy at 2007-02-01 10:37:32 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_nnndf_TAG20070201T093227_2w2jsm3r_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_ncsnf_TAG20070201T093227_2w2jtjbn_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_ncnnf_TAG20070201T093445_2w2jxppw_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_nnndf_TAG20070201T095906_2w2lcdvb_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_ncsnf_TAG20070201T095906_2w2lctdz_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_ncnnf_TAG20070201T095942_2w2ldhow_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/autobackup/2007_01_31/o1_mf_s_613318713_2w0f5vq0_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/autobackup/2007_01_31/o1_mf_s_613318718_2w0f5zt0_.bkp File Name: /u01/app/oracle/flash_recovery_area/GRID/autobackup/2007_01_31/o1_mf_s_613328375_2w0pmqyr_.bkp using channel ORA_DISK_1 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/app/oracle/oradata/grid/system01.dbf restoring datafile 00002 to /u01/app/oracle/oradata/grid/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/grid/sysaux01.dbf restoring datafile 00004 to /u01/app/oracle/oradata/grid/users01.dbf channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_nnndf_TAG20070201T095906_2w2lcdvb_.bkp channel ORA_DISK_1: restored backup piece 1 piece handle=/u01/app/oracle/flash_recovery_area/GRID/backupset/2007_02_01/o1_mf_nnndf_TAG20070201T095906_2w2lcdvb_.bkp tag=TAG20070201T095906 channel ORA_DISK_1: restore complete, elapsed time: 00:00:36 Finished restore at 2007-02-01 10:38:13 RMAN> run{ 2> recover database until time "to_date('2007-02-01 10:20:00','yyyy-mm-dd hh24:mi:ss')";} Starting recover at 2007-02-01 10:41:53 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=157 devtype=DISK starting media recovery RMAN> alter database open resetlogs; database opened