Oracle RMAN 完全恢复

Objectivel Describe the use of RMAN for restoration and recoveryl Perform complete recovery in ARCHIVELOG model Restore datafiles to different locationsl Relocate and recover a tablespace by using archived redo log files Restoration Using RMANl Restore files from backup sets or image copies by using the RMAN RESTORE commandl Recover files by using the RMAN RECOVER command Using RMAN in ARCHIVELOGrman target /RMAN> STARTUP MOUNTRMAN> RESTORE DATABASE;RMAN> RECOVER DATABASE;RMAN> ALTER DATABASE OPEN; 下面开始实验：实验环境：SYSTEM：IBM AIX 5L Oracle VERSION: 11g R2 $ rman target sys/oracle@orcl nocatalog Recovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 14 09:03:20 2011 Copyright （c） 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL （DBID=1276064171）using target database control file instead of recovery catalog RMAN> list backup; specification does not match any backup in the repository RMAN> backup database format "/u02/backup/orcl_%U"; --准备一个全备 Starting backup at 14-APR-11using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile（s） in backup setinput datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbfinput datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbfinput datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbfinput datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbfinput datafile file number=00006 name=/u01/app/oracle/oradata/orcl/app01.dbfinput datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbfchannel ORA_DISK_1: starting piece 1 at 13-APR-11channel ORA_DISK_1: finished piece 1 at 13-APR-11piece handle=/u02/backup/orcl_04m9mqh3_1_1 tag=TAG20110413T200555 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:07Finished backup at 14-APR-11 Starting Control File and SPFILE Autobackup at 14-APR-11piece handle=/u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_04_13/o1_mf_s_748382762_6tdl3tk7_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 14-APR-11 由于是热备，所以备份的过程中联机日志文件有可能发生变化，所以我们还需要备份一下当前的联机重做日志文件。 RMAN> sql "alter system archive log current"; --归档当前联机重做日志文件（REDO LOG） sql statement: alter system archive log current RMAN> list backup; List of Backup Sets=================== BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------3 Full 1.06G DISK 00:00:05 13-APR-11 BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20110413T200555 Piece Name: /u02/backup/orcl_04m9mqh3_1_1 List of Datafiles in backup set 3 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 1224029 13-APR-11 /u01/app/oracle/oradata/orcl/system01.dbf 2 Full 1224029 13-APR-11 /u01/app/oracle/oradata/orcl/sysaux01.dbf 3 Full 1224029 13-APR-11 /u01/app/oracle/oradata/orcl/undotbs01.dbf 4 Full 1224029 13-APR-11 /u01/app/oracle/oradata/orcl/users01.dbf 5 Full 1224029 13-APR-11 /u01/app/oracle/oradata/orcl/example01.dbf 6 Full 1183312 13-APR-11 /u01/app/oracle/oradata/orcl/app01.dbf BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------4 Full 7.58M DISK 00:00:00 13-APR-11 BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20110413T200602 Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2011_04_13/o1_mf_s_748382762_6tdl3tk7_.bkp SPFILE Included: Modification time: 13-APR-11 SPFILE db_unique_name: ORCL Control File Included: Ckp SCN: 1224037 Ckp time: 13-APR-11

Oracle join 多表连接----至少3张表EJBCA（4.0.1）在CentOS 5.5上的安装相关资讯 Oracle教程

Oracle中纯数字的varchar2类型和（07/29/2015 07:20:43）
Oracle教程：Oracle中查看DBLink密（07/29/2015 07:16:55）
[Oracle] SQL*Loader 详细使用教程（08/11/2013 21:30:36）

Oracle教程：Oracle中kill死锁进程（07/29/2015 07:18:28）
Oracle教程：ORA-25153 临时表空间（07/29/2015 07:13:37）
Oracle教程之管理安全和资源（04/08/2013 11:39:32）

本文评论查看全部评论（0）