1备份当前数据库rmanbackupdatabase;startingbackupat14-dec-12usingtargetdatabasecontrolfileinsteadofrecoverycatalogallocatedchannel:ora_disk_1channelora
1 备份当前数据库
rman> backup database;
starting backup at 14-dec-12
using target database control file instead of recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=211 devtype=disk
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
input datafile fno=00009 name=/oracle/test/zxbig.dbf
input datafile fno=00001 name=/oracle/test/system1.dbf
input datafile fno=00003 name=/oracle/test/sysaux01.dbf
input datafile fno=00005 name=/oracle/test/zxa.dbf
input datafile fno=00008 name=/oracle/test/undotbs1.dbf
input datafile fno=00002 name=/oracle/test/zxb.dbf
input datafile fno=00007 name=/oracle/test/zxc.dbf
input datafile fno=00004 name=/oracle/test/users01.dbf
input datafile fno=00006 name=/oracle/test/test1.dbf
input datafile fno=00010 name=/oracle/test2.dbf
input datafile fno=00011 name=/oracle/test/jiujian1.dbf
channel ora_disk_1: starting piece 1 at 14-dec-12
channel ora_disk_1: finished piece 1 at 14-dec-12
piece handle=/oracle/app/db1/dbs/0hnssesq_1_1 tag=tag20121214t221345 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:04:58
channel ora_disk_1: starting full datafile backupset
channel ora_disk_1: specifying datafile(s) in backupset
including current control file in backupset
including current spfile in backupset
channel ora_disk_1: starting piece 1 at 14-dec-12
channel ora_disk_1: finished piece 1 at 14-dec-12
piece handle=/oracle/app/db1/dbs/0inssf64_1_1 tag=tag20121214t221345 comment=none
channel ora_disk_1: backup set complete, elapsed time: 00:00:06
finished 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.
4 当前数据库日志状态如下：
sql> select group#,archived,sequence#,status from v$log;
group# arc sequence# status
---------- --- ---------- ----------------
1 no 20 current
2 yes 15 inactive
6 yes 18 inactive
4 yes 16 inactive
5 yes 17 inactive
3 yes 19 inactive
5 归档信息如下：