[oracle@zwc ~]$ sqlplus zhongwc/zhongwc
SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 5 10:40:49 2013
Copyright (c) 1982, 2011,
Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from t_rec;
ID NAME
---------- ----------
1 aaa
2 bbb
3 ccc
4 ddd
SQL> insert into t_rec values(5,'eee');
1 row created.
SQL> commit;
Commit complete.
SQL> select * from t_rec;
ID NAME
---------- ----------
1 aaa
2 bbb
3 ccc
4 ddd
5 eee
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@zwc ~]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Tue Feb 5 10:41:32 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=561451333)
RMAN> run{
2> allocate channel c1 device type disk;
3> backup full database format '/u01/backup/db_full_%u_%s_%p' tag 'fullbak'
4> include current controlfile;
5> sql 'alter system archive log current';
6> release channel c1;
7> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=40 device type=DISK
Starting backup at 05-FEB-2013 10:43:37
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ZWC/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/ZWC/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/ZWC/example01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/ZWC/undotbs01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ZWC/users01.dbf
channel c1: starting piece 1 at 05-FEB-2013 10:43:37
channel c1: finished piece 1 at 05-FEB-2013 10:44:33
piece handle=/u01/backup/db_full_01o16uap_1_1 tag=FULLBAK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:56
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel c1: starting piece 1 at 05-FEB-2013 10:44:34
channel c1: finished piece 1 at 05-FEB-2013 10:44:35
piece handle=/u01/backup/db_full_02o16uch_2_1 tag=FULLBAK comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 05-FEB-2013 10:44:35
sql statement: alter system archive log current
released channel: c1
RMAN> exit
Recovery Manager complete.
[oracle@zwc ~]$ sqlplus zhongwc/zhongwc
SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 5 10:49:39 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bi