---查看有几个表空间
---备份system表空间
----查看system备份的地址
---备份users表空间
---查看users表空间地址
----两者进行对比
----通过对比就会发现RMAN在备份重要的表空间的时候、会自动备份控制文件和参数文件
-
SQL> select TABLESPACE_NAME from Dba_Tablespaces;
-
-
TABLESPACE_NAME
-
------------------------------
-
SYSTEM
-
SYSAUX
-
UNDOTBS1
-
TEMP
-
USERS
-
EXAMPLE
-
-
6 rows selected.
-
- SQL>
-
RMAN> BACKUP AS BACKUPSET FORMAT '/home/oracle/ts_system_%U' TABLESPACE
-
2> system;
-
-
Starting backup at 16-DEC-16
-
using target database control file instead of recovery catalog
-
allocated channel: ORA_DISK_1
-
channel ORA_DISK_1: SID=146 device type=DISK
-
channel ORA_DISK_1: starting full datafile backup set
-
channel ORA_DISK_1: specifying datafile(s) in backup set
-
input datafile file number=00001 name=/u01/app/oracle/oradata/ORA/system01.dbf
-
channel ORA_DISK_1: starting piece 1 at 16-DEC-16
-
channel ORA_DISK_1: finished piece 1 at 16-DEC-16
-
piece handle=/home/oracle/ts_system_03rnkkb3_1_1 tag=TAG20161216T171827 comment=NONE
-
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
-
channel ORA_DISK_1: starting full datafile backup set
-
channel ORA_DISK_1: specifying datafile(s) in backup set
-
including current control file in backup set
-
including current SPFILE in backup set
-
channel ORA_DISK_1: starting piece 1 at 16-DEC-16
-
channel ORA_DISK_1: finished piece 1 at 16-DEC-16
-
piece handle=/home/oracle/ts_system_04rnkkbs_1_1 tag=TAG20161216T171827 comment=NONE
-
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
-
Finished backup at 16-DEC-16
-
- RMAN>
-
RMAN> list backup of tablespace system;
-
-
-
List of Backup Sets
-
===================
-
-
-
BS Key Type LV Size Device Type Elapsed Time Completion Time
-
------- ---- -- ---------- ----------- ------------ ---------------
-
2 Full 638.57M DISK 00:00:18 16-DEC-16
-
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20161216T171827
-
Piece Name: /home/oracle/ts_system_03rnkkb3_1_1
-
List of Datafiles in backup set 2
-
File LV Type Ckp SCN Ckp Time Name
-
---- -- ---- ---------- --------- ----
-
1 Full 1021865 16-DEC-16 /u01/app/oracle/oradata/ORA/system01.dbf
-
- RMAN>
-
RMAN> BACKUP AS BACKUPSET FORMAT '/home/oracle/ks/ts_user_%U' TABLESPACE
-
2> users;
-
-
Starting backup at 16-DEC-16
-
using channel ORA_DISK_1
-
channel ORA_DISK_1: starting full datafile backup set
-
channel ORA_DISK_1: specifying datafile(s) in backup set
-
input datafile file number=00004 name=/u01/app/oracle/oradata/ORA/users01.dbf
-
channel ORA_DISK_1: starting piece 1 at 16-DEC-16
-
channel ORA_DISK_1: finished piece 1 at 16-DEC-16
-
piece handle=/home/oracle/ks/ts_user_05rnkkj7_1_1 tag=TAG20161216T172247 comment=NONE
-
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
-
Finished backup at 16-DEC-16
-
-
RMAN>
-
RMAN> list backup of tablespace users;
-
-
-
List of Backup Sets
-
===================
-
-
-
BS Key Type LV Size Device Type Elapsed Time Completion Time
-
------- ---- -- ---------- ----------- ------------ ---------------
-
4 Full 3.29M DISK 00:00:01 16-DEC-16
-
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20161216T172247
-
Piece Name: /home/oracle/ks/ts_user_05rnkkj7_1_1
-
List of Datafiles in backup set 4
-
File LV Type Ckp SCN Ckp Time Name
-
---- -- ---- ---------- --------- ----
-
4 Full 1022162 16-DEC-16 /u01/app/oracle/oradata/ORA/users01.dbf
-
- RMAN>
system表空间
-
[oracle@zh ~]$ ls -lh
-
total 649M
-
drwxr-xr-x 2 oracle oinstall 4.0K Dec 16 17:22 ks
-
-rw-r----- 1 oracle oinstall 639M Dec 16 17:18 ts_system_03rnkkb3_1_1
-
-rw-r----- 1 oracle oinstall 9.4M Dec 16 17:18 ts_system_04rnkkbs_1_1
- [oracle@zh ~]$
users表空间
-
[oracle@zh ~]$ ls -lh
-
total 649M
-
drwxr-xr-x 2 oracle oinstall 4.0K Dec 16 17:22 ks
-
-rw-r----- 1 oracle oinstall 639M Dec 16 17:18 ts_system_03rnkkb3_1_1
-
-rw-r----- 1 oracle oinstall 9.4M Dec 16 17:18 ts_system_04rnkkbs_1_1
- [oracle@zh ~]$
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31399171/viewspace-2130823/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
