[oracle@host148 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 13:41:14 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1258293240 bytes
Database Buffers 385875968 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@host148 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 23 13:41:57 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1328859021, not open)
RMAN> run {
# backup the complete database to disk
allocate channel dev1 type disk;
backup
full
tag full_db_backup
format '/u01/app/bk/db_t%t_s%s_p%p'
database;
release channel dev1;
}2> 3> 4> 5> 6> 7> 8> 9> 10>
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: SID=20 device type=DISK
Starting backup at 2015-10-23 13:42:09
channel dev1: starting full datafile backup set
channel dev1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA02.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA03.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW02.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW03.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX01.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX02.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX03.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/orcl/ts_dist_data.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/orcl/ts_dist_index.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/orcl/ts_mis_data04.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/orcl/ts_cds_data.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/orcl/ts_cds_index.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel dev1: starting piece 1 at 2015-10-23 13:42:09
channel dev1: finished piece 1 at 2015-10-23 13:47:15
piece handle=/u01/app/bk/db_t893857329_s7_p1 tag=FULL_DB_BACKUP comment=NONE
channel dev1: backup set complete, elapsed time: 00:05:06
channel dev1: starting full datafile backup set
channel dev1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel dev1: starting piece 1 at 2015-10-23 13:47:17
channel dev1: finished piece 1 at 2015-10-23 13:47:18
piece handle=/u01/app/bk/db_t893857635_s8_p1 tag=FULL_DB_BACKUP comment=NONE
channel dev1: backup set complete, elapsed time: 00:00:01
Finished backup at 2015-10-23 13:47:18
released channel: dev1
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1 Full 9.83M DISK 00:00:01 2015-10-23 11:26:01
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20151023T112559
Piece Name: /u01/app/bk/bak_02qke3i8_1_1
SPFILE Included: Modification time: 2015-10-23 11:22:28
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448054411 Ckp time: 2015-10-23 11:26:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 9.83M DISK 00:00:01 2015-10-23 13:38:21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20151023T133819
Piece Name: /u01/app/bk/bak_04qkebac_1_1
SPFILE Included: Modification time: 2015-10-23 13:38:07
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059222 Ckp time: 2015-10-23 13:38:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 9.83M DISK 00:00:01 2015-10-23 13:40:57
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857256_s6_p1
SPFILE Included: Modification time: 2015-10-23 13:38:07
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059294 Ckp time: 2015-10-23 13:40:56
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 1.88G DISK 00:05:03 2015-10-23 13:47:12
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857329_s7_p1
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA.dbf
6 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA01.dbf
7 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA02.dbf
8 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA03.dbf
9 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW.dbf
10 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW01.dbf
11 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW02.dbf
12 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW03.dbf
13 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX.dbf
14 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX01.dbf
15 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX02.dbf
16 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX03.dbf
17 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_dist_data.dbf
18 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_dist_index.dbf
19 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_cds_index.dbf
20 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_cds_data.dbf
21 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_mis_data04.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 9.83M DISK 00:00:02 2015-10-23 13:47:17
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857635_s8_p1
SPFILE Included: Modification time: 2015-10-23 13:41:43
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059459 Ckp time: 2015-10-23 13:41:30
RMAN> exit
Recovery Manager complete.
[oracle@host148 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 13:48:11 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database open;
Database altered.
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 13:41:14 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size 2213896 bytes
Variable Size 1258293240 bytes
Database Buffers 385875968 bytes
Redo Buffers 7135232 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@host148 ~]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 23 13:41:57 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1328859021, not open)
RMAN> run {
# backup the complete database to disk
allocate channel dev1 type disk;
backup
full
tag full_db_backup
format '/u01/app/bk/db_t%t_s%s_p%p'
database;
release channel dev1;
}2> 3> 4> 5> 6> 7> 8> 9> 10>
using target database control file instead of recovery catalog
allocated channel: dev1
channel dev1: SID=20 device type=DISK
Starting backup at 2015-10-23 13:42:09
channel dev1: starting full datafile backup set
channel dev1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA02.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/orcl/TS_MIS_DATA03.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
input datafile file number=00009 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW02.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/orcl/TS_MIS_FLOW03.dbf
input datafile file number=00013 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX.dbf
input datafile file number=00014 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX01.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX02.dbf
input datafile file number=00016 name=/u01/app/oracle/oradata/orcl/TS_MIS_INDEX03.dbf
input datafile file number=00017 name=/u01/app/oracle/oradata/orcl/ts_dist_data.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/orcl/ts_dist_index.dbf
input datafile file number=00021 name=/u01/app/oracle/oradata/orcl/ts_mis_data04.dbf
input datafile file number=00020 name=/u01/app/oracle/oradata/orcl/ts_cds_data.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/orcl/ts_cds_index.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
channel dev1: starting piece 1 at 2015-10-23 13:42:09
channel dev1: finished piece 1 at 2015-10-23 13:47:15
piece handle=/u01/app/bk/db_t893857329_s7_p1 tag=FULL_DB_BACKUP comment=NONE
channel dev1: backup set complete, elapsed time: 00:05:06
channel dev1: starting full datafile backup set
channel dev1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel dev1: starting piece 1 at 2015-10-23 13:47:17
channel dev1: finished piece 1 at 2015-10-23 13:47:18
piece handle=/u01/app/bk/db_t893857635_s8_p1 tag=FULL_DB_BACKUP comment=NONE
channel dev1: backup set complete, elapsed time: 00:00:01
Finished backup at 2015-10-23 13:47:18
released channel: dev1
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1 Full 9.83M DISK 00:00:01 2015-10-23 11:26:01
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20151023T112559
Piece Name: /u01/app/bk/bak_02qke3i8_1_1
SPFILE Included: Modification time: 2015-10-23 11:22:28
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448054411 Ckp time: 2015-10-23 11:26:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 9.83M DISK 00:00:01 2015-10-23 13:38:21
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20151023T133819
Piece Name: /u01/app/bk/bak_04qkebac_1_1
SPFILE Included: Modification time: 2015-10-23 13:38:07
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059222 Ckp time: 2015-10-23 13:38:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 9.83M DISK 00:00:01 2015-10-23 13:40:57
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857256_s6_p1
SPFILE Included: Modification time: 2015-10-23 13:38:07
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059294 Ckp time: 2015-10-23 13:40:56
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 1.88G DISK 00:05:03 2015-10-23 13:47:12
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857329_s7_p1
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/system01.dbf
2 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/sysaux01.dbf
3 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/undotbs01.dbf
4 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/users01.dbf
5 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA.dbf
6 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA01.dbf
7 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA02.dbf
8 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_DATA03.dbf
9 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW.dbf
10 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW01.dbf
11 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW02.dbf
12 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_FLOW03.dbf
13 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX.dbf
14 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX01.dbf
15 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX02.dbf
16 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/TS_MIS_INDEX03.dbf
17 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_dist_data.dbf
18 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_dist_index.dbf
19 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_cds_index.dbf
20 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_cds_data.dbf
21 Full 2448059459 2015-10-23 13:41:30 /u01/app/oracle/oradata/orcl/ts_mis_data04.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 9.83M DISK 00:00:02 2015-10-23 13:47:17
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: FULL_DB_BACKUP
Piece Name: /u01/app/bk/db_t893857635_s8_p1
SPFILE Included: Modification time: 2015-10-23 13:41:43
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 2448059459 Ckp time: 2015-10-23 13:41:30
RMAN> exit
Recovery Manager complete.
[oracle@host148 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 23 13:48:11 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database open;
Database altered.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-1815868/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-1815868/