Oracle备份恢复之跨越归档进行恢复

1 备份当前数据库RMAN> backup database; Starting backup at 14-DEC-12using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=211 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile（s） in backupsetinput datafile fno=00009 name=/Oracle/test/zxbig.dbfinput datafile fno=00001 name=/oracle/test/system1.dbfinput datafile fno=00003 name=/oracle/test/sysaux01.dbfinput datafile fno=00005 name=/oracle/test/zxa.dbfinput datafile fno=00008 name=/oracle/test/undotbs1.dbfinput datafile fno=00002 name=/oracle/test/zxb.dbfinput datafile fno=00007 name=/oracle/test/zxc.dbfinput datafile fno=00004 name=/oracle/test/users01.dbfinput datafile fno=00006 name=/oracle/test/test1.dbfinput datafile fno=00010 name=/oracle/test2.dbfinput datafile fno=00011 name=/oracle/test/jiujian1.dbfchannel ORA_DISK_1: starting piece 1 at 14-DEC-12channel ORA_DISK_1: finished piece 1 at 14-DEC-12piece handle=/oracle/app/db1/dbs/0hnssesq_1_1 tag=TAG20121214T221345 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:04:58channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile（s） in backupsetincluding current control file in backupsetincluding current SPFILE in backupsetchannel ORA_DISK_1: starting piece 1 at 14-DEC-12channel ORA_DISK_1: finished piece 1 at 14-DEC-12piece handle=/oracle/app/db1/dbs/0inssf64_1_1 tag=TAG20121214T221345 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:06Finished backup at 14-DEC-12 2 创建测试表 SQL> create table t5（a int） tablespace jiujian1; Table created. SQL> select table_name,tablespace_name from dba_tables where table_name="T5"; TABLE_NAME TABLESPACE_NAME------------------------------ ------------------------------T5 JIUJIAN1 3插入数据，切换日志，产生归档： 当前日志状态如下： SQL> select group#,archived,sequence#,status from v$log; GROUP# ARC SEQUENCE# STATUS---------- --- ---------- ---------------- 1 YES 2 INACTIVE 2 YES 3 INACTIVE 3 YES 1 INACTIVE 4 YES 4 INACTIVE 5 YES 5 INACTIVE 6 NO 6 CURRENT 6 rows selected. 6号归档中的数据如下：SQL> insert into t5 values（1）; 1 row created.SQL> insert into t5 values（2）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile； System altered.7号归档中的数据如下：SQL> insert into t5 values（3）; 1 row created. SQL> insert into t5 values（4）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.8号归档中的数据如下：SQL> insert into t5 values（6）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.9号归档中的数据如下：SQL> insert into t5 values（5）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile;10号归档中的数据如下：System altered. SQL> insert into t5 values（7）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.11号归档中的数据如下：SQL> insert into t5 values（8）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.12号归档中的数据如下：SQL> insert into t5 values（9）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.13号归档中的数据如下：SQL> insert into t5 values（10）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.14号归档中的数据如下：SQL> insert into t5 values（11）; 1 row created. SQL> insert into t5 values（12）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.15号归档中的数据如下：SQL> insert into t5 values（13）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered. SQL> insert into t5 values（14）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered. SQL> insert into t5 values（15）; 1 row created. SQL> commit; Commit complete. SQL> alter system switch logfile; System altered.

SQL Server 安全性部分实验Oracle中对UNNAMEDnnnnn文件的处理相关资讯 Oracle备份 Oracle备份恢复 Oracle恢复 Oracle备份和恢复

利用Oracle自带的impdp和expdp进行（05月18日）
Oracle使用句柄实现特定场景的无备（11/24/2014 14:07:02）
Oracle基于cancel的不完全恢复（10/08/2014 19:32:05）

Oracle数据库物理文件备份/恢复（07/20/2015 20:53:07）
Oracle数据表被drop后的恢复（10/15/2014 10:43:07）
Java实现Oracle数据库备份（08/12/2014 11:24:51）

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