Bo's Oracle Station

查看: 2100|回复: 0

课程第28/29次(2017-05-13星期六上下午)

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-5-14 22:27:03 | 显示全部楼层 |阅读模式
上完1Z0-053第3/4章
进行1Z0-053第5章(已经上完块跟踪/上完单个文件Section Size并行分片/进行Archival Backup)
1Z0-0
52共19章(上完12章),1Z0-053共21章(上完8章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的20章
  1. [root@station90 桌面]# su - oracle
  2. [oracle@station90 ~]$ . oraenv
  3. ORACLE_SID = [orcl] ? rcat
  4. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  5. [oracle@station90 ~]$ sqlplus /nolog

  6. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:15:52 2017

  7. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  8. SQL> conn / as sysdba
  9. Connected to an idle instance.
  10. SQL> startup
  11. ORACLE instance started.

  12. Total System Global Area 1603411968 bytes
  13. Fixed Size                    2213776 bytes
  14. Variable Size                  469764208 bytes
  15. Database Buffers         1124073472 bytes
  16. Redo Buffers                    7360512 bytes
  17. Database mounted.
  18. Database opened.
  19. SQL> select dbid from v$database;

  20.       DBID
  21. ----------
  22. 590260915

  23. SQL> exit
  24. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  25. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  26. [oracle@station90 ~]$ . oraenv
  27. ORACLE_SID = [rcat] ? orcl
  28. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  29. [oracle@station90 ~]$ sqlplus /nolog

  30. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:26:02 2017

  31. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  32. SQL> conn / as sysdba
  33. Connected.
  34. SQL> select dbid from v$database;

  35.       DBID
  36. ----------
  37. 1343950367

  38. SQL> exit
  39. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  40. With the Partitioning, Automatic Storage Management, OLAP, Data Mining
  41. and Real Application Testing options
  42. [oracle@station90 ~]$ rman  catalog u90/oracle_4U@rcat

  43. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:30:19 2017

  44. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  45. connected to recovery catalog database

  46. RMAN> import catalog u90/oracle_4U@utforcl199
  47. 2> ;

  48. Starting import catalog at 13-MAY-17
  49. RMAN-00571: ===========================================================
  50. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  51. RMAN-00571: ===========================================================
  52. RMAN-03002: failure of import catalog command at 05/13/2017 09:30:40
  53. RMAN-04035: error from source recovery catalog database: ORA-12154: TNS:could not resolve the connect identifier specified

  54. RMAN> import catalog u90/oracle_4U@utforcl199
  55. 2> ;

  56. Starting import catalog at 13-MAY-17
  57. connected to source recovery catalog database
  58. import validation complete
  59. RMAN-00571: ===========================================================
  60. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  61. RMAN-00571: ===========================================================
  62. RMAN-03002: failure of import catalog command at 05/13/2017 09:31:46
  63. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20512: source database already registered in recovery catalog

  64. RMAN> import catalog u90/oracle_4U@utforcl199 dbid=1347195613 no unregister;

  65. Starting import catalog at 13-MAY-17
  66. connected to source recovery catalog database
  67. import validation complete
  68. Finished import catalog at 13-MAY-17

  69. RMAN> exit


  70. Recovery Manager complete.
  71. [oracle@station90 ~]$ . oraenv
  72. ORACLE_SID = [orcl] ? rcat
  73. The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
  74. [oracle@station90 ~]$ sqlplus /nolog

  75. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 09:45:33 2017

  76. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  77. SQL> conn u90/oracle_4U
  78. Connected.
  79. SQL> select dbid from v$database;
  80. select dbid from v$database
  81.                  *
  82. ERROR at line 1:
  83. ORA-00942: table or view does not exist


  84. SQL> select dbid from db;
  85. select dbid from db
  86.        *
  87. ERROR at line 1:
  88. ORA-00904: "DBID": invalid identifier


  89. SQL> select * from db;

  90.     DB_KEY        DB_ID CURR_DBINC_KEY
  91. ---------- ---------- --------------
  92.          2 1343950367                   4
  93.       3002 1359978017                3003
  94.       6127 1347195613                6128

  95. SQL> select * from db;

  96.     DB_KEY        DB_ID CURR_DBINC_KEY
  97. ---------- ---------- --------------
  98.          2 1343950367                   4
  99.       3002 1359978017                3003
  100.       6127 1347195613                6128

  101. SQL> /

  102.     DB_KEY        DB_ID CURR_DBINC_KEY
  103. ---------- ---------- --------------
  104.          2 1343950367                   4
  105.       3002 1359978017                3003
  106.       6127 1347195613                6128

  107. SQL> /

  108.     DB_KEY        DB_ID CURR_DBINC_KEY
  109. ---------- ---------- --------------
  110.          2 1343950367                   4
  111.       3002 1359978017                3003
  112.       8474  454057935                8475
  113.       6127 1347195613                6128

  114. SQL>
  115. ----------------------------------------------------------------




  116. create user v91 identified by oracle_4U ;

  117. create user v92 identified by oracle_4U ;

  118. create user v93 identified by oracle_4U ;

  119. grant recovery_catalog_owner to v91;

  120. grant recovery_catalog_owner to v92;

  121. grant recovery_catalog_owner to v93;

  122. create user v94 identified by oracle_4U ;

  123. grant recovery_catalog_owner to v94;
  124. ------------------------------------------------------
  125. [root@station90 桌面]# su - oracle
  126. [oracle@station90 ~]$ rman catalog  u90/oracle_4U@rcat

  127. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:47:02 2017

  128. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  129. connected to recovery catalog database

  130. RMAN> grant catalog for database 1343950367 to v91;

  131. Grant succeeded.

  132. RMAN> grant catalog for database 1347195613 to v92;

  133. Grant succeeded.

  134. RMAN> grant catalog for database 1359978017 to v93 ;

  135. Grant succeeded.

  136. RMAN> connect v91/oracle_4U@rcat

  137. RMAN-00571: ===========================================================
  138. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  139. RMAN-00571: ===========================================================
  140. RMAN-00558: error encountered while parsing input commands
  141. RMAN-01009: syntax error: found "identifier": expecting one of: "auxiliary, catalog, target"
  142. RMAN-01008: the bad identifier was: v91
  143. RMAN-01007: at line 1 column 9 file: standard input

  144. RMAN> connect catalog v91/oracle_4U@rcat

  145. RMAN-00571: ===========================================================
  146. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  147. RMAN-00571: ===========================================================
  148. RMAN-06167: already connected

  149. RMAN>  connect catalog v91/oracle_4U@rcat

  150. RMAN-00571: ===========================================================
  151. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  152. RMAN-00571: ===========================================================
  153. RMAN-06167: already connected

  154. RMAN> create virtual catalog;

  155. recovery catalog already exists

  156. RMAN> exit


  157. Recovery Manager complete.
  158. [oracle@station90 ~]$ rman catalog  v91/oracle_4U@rcat

  159. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:11 2017

  160. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  161. connected to recovery catalog database

  162. RMAN> create virtual catalog;

  163. found ineligible base catalog owned by U4
  164. found ineligible base catalog owned by U26
  165. found ineligible base catalog owned by U77
  166. found eligible base catalog owned by U90
  167. created virtual catalog against base catalog owned by U90

  168. RMAN> exit


  169. Recovery Manager complete.
  170. [oracle@station90 ~]$ rman catalog  v92/oracle_4U@rcat

  171. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:40 2017

  172. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  173. connected to recovery catalog database

  174. RMAN> create virual catalog;

  175. RMAN-00571: ===========================================================
  176. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  177. RMAN-00571: ===========================================================
  178. RMAN-00558: error encountered while parsing input commands
  179. RMAN-01009: syntax error: found "identifier": expecting one of: "catalog, global, restore, script, virtual"
  180. RMAN-01008: the bad identifier was: virual
  181. RMAN-01007: at line 1 column 8 file: standard input

  182. create virtual catalog;talog;


  183. found ineligible base catalog owned by U4
  184. found ineligible base catalog owned by U26
  185. found ineligible base catalog owned by U77
  186. found eligible base catalog owned by U90
  187. created virtual catalog against base catalog owned by U90

  188. RMAN>
  189. RMAN> exit


  190. Recovery Manager complete.
  191. [oracle@station90 ~]$ rman catalog  v93/oracle_4U@rcat

  192. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:51:08 2017

  193. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  194. connected to recovery catalog database

  195. RMAN> create virtual catalog;

  196. found ineligible base catalog owned by U4
  197. found ineligible base catalog owned by U26
  198. found ineligible base catalog owned by U77
  199. found eligible base catalog owned by U90
  200. created virtual catalog against base catalog owned by U90

  201. RMAN>
  202. --------------------------------------------

  203. v91:

  204. [root@station90 桌面]# su - oracle
  205. [oracle@station90 ~]$ rman catalog  u90/oracle_4U@rcat

  206. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:47:02 2017

  207. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  208. connected to recovery catalog database

  209. RMAN> grant catalog for database 1343950367 to v91;

  210. Grant succeeded.

  211. RMAN> grant catalog for database 1347195613 to v92;

  212. Grant succeeded.

  213. RMAN> grant catalog for database 1359978017 to v93 ;

  214. Grant succeeded.

  215. RMAN> connect v91/oracle_4U@rcat

  216. RMAN-00571: ===========================================================
  217. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  218. RMAN-00571: ===========================================================
  219. RMAN-00558: error encountered while parsing input commands
  220. RMAN-01009: syntax error: found "identifier": expecting one of: "auxiliary, catalog, target"
  221. RMAN-01008: the bad identifier was: v91
  222. RMAN-01007: at line 1 column 9 file: standard input

  223. RMAN> connect catalog v91/oracle_4U@rcat

  224. RMAN-00571: ===========================================================
  225. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  226. RMAN-00571: ===========================================================
  227. RMAN-06167: already connected

  228. RMAN>  connect catalog v91/oracle_4U@rcat

  229. RMAN-00571: ===========================================================
  230. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  231. RMAN-00571: ===========================================================
  232. RMAN-06167: already connected

  233. RMAN> create virtual catalog;

  234. recovery catalog already exists

  235. RMAN> exit


  236. Recovery Manager complete.
  237. [oracle@station90 ~]$ rman catalog  v91/oracle_4U@rcat

  238. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:11 2017

  239. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  240. connected to recovery catalog database

  241. RMAN> create virtual catalog;

  242. found ineligible base catalog owned by U4
  243. found ineligible base catalog owned by U26
  244. found ineligible base catalog owned by U77
  245. found eligible base catalog owned by U90
  246. created virtual catalog against base catalog owned by U90

  247. RMAN> exit


  248. Recovery Manager complete.
  249. [oracle@station90 ~]$ rman catalog  v92/oracle_4U@rcat

  250. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:50:40 2017

  251. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  252. connected to recovery catalog database

  253. RMAN> create virual catalog;

  254. RMAN-00571: ===========================================================
  255. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  256. RMAN-00571: ===========================================================
  257. RMAN-00558: error encountered while parsing input commands
  258. RMAN-01009: syntax error: found "identifier": expecting one of: "catalog, global, restore, script, virtual"
  259. RMAN-01008: the bad identifier was: virual
  260. RMAN-01007: at line 1 column 8 file: standard input

  261. create virtual catalog;talog;


  262. found ineligible base catalog owned by U4
  263. found ineligible base catalog owned by U26
  264. found ineligible base catalog owned by U77
  265. found eligible base catalog owned by U90
  266. created virtual catalog against base catalog owned by U90

  267. RMAN>
  268. RMAN> exit


  269. Recovery Manager complete.
  270. [oracle@station90 ~]$ rman catalog  v93/oracle_4U@rcat

  271. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:51:08 2017

  272. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  273. connected to recovery catalog database

  274. RMAN> create virtual catalog;

  275. found ineligible base catalog owned by U4
  276. found ineligible base catalog owned by U26
  277. found ineligible base catalog owned by U77
  278. found eligible base catalog owned by U90
  279. created virtual catalog against base catalog owned by U90

  280. RMAN>


  281. --------------------------------------------
  282. V93:




  283. [root@station90 ~]# ssh station26
  284. The authenticity of host 'station26 (192.168.0.26)' can't be established.
  285. RSA key fingerprint is df:20:f7:84:94:66:b7:46:f5:2e:f8:2e:0c:4c:32:ac.
  286. Are you sure you want to continue connecting (yes/no)? yes
  287. Warning: Permanently added 'station26,192.168.0.26' (RSA) to the list of known hosts.
  288. Last login: Sat May 13 09:28:10 2017 from station90.example.com
  289. [root@station26 ~]# su - oracle
  290. [oracle@station26 ~]$ rman target  / catalog v93/oracle_4U@rcat

  291. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:53:56 2017

  292. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  293. connected to target database: ORCL (DBID=1359978017)
  294. connected to recovery catalog database

  295. RMAN> report schema;

  296. Report of database schema for database with db_unique_name ORCL

  297. List of Permanent Datafiles
  298. ===========================
  299. File Size(MB) Tablespace           RB segs Datafile Name
  300. ---- -------- -------------------- ------- ------------------------
  301. 1    690      SYSTEM               YES     +DATA/orcl/datafile/system.256.943294517
  302. 2    580      SYSAUX               NO      +DATA/orcl/datafile/sysaux.258.941388173
  303. 3    100      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.259.941388169
  304. 4    7        USERS                NO      +DATA/orcl/datafile/users.265.943357169
  305. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.257.941388169

  306. List of Temporary Files
  307. =======================
  308. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
  309. ---- -------- -------------------- ----------- --------------------
  310. 1    29       TEMP                 32767       +DATA/orcl/tempfile/temp.264.832197335
  311. 3    6144     TEMP                 6144        /u01/app/oracle/oradata/orcl/temp03.dbf

  312. RMAN> exit


  313. Recovery Manager complete.
  314. [oracle@station26 ~]$ rman target  / catalog v91/oracle_4U@rcat

  315. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:54:10 2017

  316. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  317. connected to target database: ORCL (DBID=1359978017)
  318. connected to recovery catalog database

  319. RMAN> report schema;

  320. RMAN-00571: ===========================================================
  321. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  322. RMAN-00571: ===========================================================
  323. RMAN-03002: failure of report command at 05/13/2017 09:54:15
  324. RMAN-06004: ORACLE error from recovery catalog database: RMAN-20001: target database not found in recovery catalog

  325. RMAN> exit


  326. Recovery Manager complete.
  327. [oracle@station26 ~]$ rman target  / catalog u90/oracle_4U@rcat

  328. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 09:54:20 2017

  329. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  330. connected to target database: ORCL (DBID=1359978017)
  331. connected to recovery catalog database

  332. RMAN> report schema;

  333. Report of database schema for database with db_unique_name ORCL

  334. List of Permanent Datafiles
  335. ===========================
  336. File Size(MB) Tablespace           RB segs Datafile Name
  337. ---- -------- -------------------- ------- ------------------------
  338. 1    690      SYSTEM               YES     +DATA/orcl/datafile/system.256.943294517
  339. 2    580      SYSAUX               NO      +DATA/orcl/datafile/sysaux.258.941388173
  340. 3    100      UNDOTBS1             YES     +DATA/orcl/datafile/undotbs1.259.941388169
  341. 4    7        USERS                NO      +DATA/orcl/datafile/users.265.943357169
  342. 5    100      EXAMPLE              NO      +DATA/orcl/datafile/example.257.941388169

  343. List of Temporary Files
  344. =======================
  345. File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
  346. ---- -------- -------------------- ----------- --------------------
  347. 1    29       TEMP                 32767       +DATA/orcl/tempfile/temp.264.832197335
  348. 3    6144     TEMP                 6144        /u01/app/oracle/oradata/orcl/temp03.dbf

  349. RMAN>

  350. ------------------------------------
  351. V94:



  352. Microsoft Windows [版本 6.1.7600]
  353. 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。

  354. C:\Users\Administrator>sqlplus /nolog

  355. SQL*Plus: Release 11.2.0.1.0 Production on 星期六 5月 13 10:00:41 2017

  356. Copyright (c) 1982, 2010, Oracle.  All rights reserved.

  357. SQL> conn / as sysdba
  358. 已连接。
  359. SQL> select   dbid from v$database;

  360.       DBID
  361. ----------
  362. 454057935

  363. SQL> exit
  364. 从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
  365. With the Partitioning, OLAP, Data Mining and Real Application Testing options 断


  366. C:\Users\Administrator>tnsping rcat

  367. TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 13-5月 -
  368. 2017 10:01:08

  369. Copyright (c) 1997, 2010, Oracle.  All rights reserved.

  370. 已使用的参数文件:
  371. C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora


  372. 已使用 TNSNAMES 适配器来解析别名
  373. 尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.90)(PORT =
  374. 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = rcat.example.com)))
  375. OK (10 毫秒)

  376. C:\Users\Administrator>rman target  /  catalog v94/oracle_4U@rcat

  377. 恢复管理器: Release 11.2.0.1.0 - Production on 星期六 5月 13 10:01:25 2017

  378. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  379. 连接到目标数据库: UTFORCL (DBID=454057935)
  380. 连接到恢复目录数据库

  381. RMAN> register database;

  382. 注册在恢复目录中的数据库
  383. 正在启动全部恢复目录的 resync
  384. 完成全部 resync

  385. RMAN> exit


  386. 恢复管理器完成。

  387. C:\Users\Administrator>rman target  /  catalog u90/oracle_4U@rcat

  388. 恢复管理器: Release 11.2.0.1.0 - Production on 星期六 5月 13 10:02:07 2017

  389. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  390. 连接到目标数据库: UTFORCL (DBID=454057935)
  391. 连接到恢复目录数据库

  392. RMAN> report schema;

  393. db_unique_name 为 UTFORCL 的数据库的数据库方案报表

  394. 永久数据文件列表
  395. ===========================
  396. 文件大小 (MB) 表空间           回退段数据文件名称
  397. ---- -------- -------------------- ------- ------------------------
  398. 1    700      SYSTEM               YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  399. SYSTEM01.DBF
  400. 2    510      SYSAUX               NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  401. SYSAUX01.DBF
  402. 3    100      UNDOTBS1             YES     C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  403. UNDOTBS01.DBF
  404. 4    5        USERS                NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  405. USERS01.DBF
  406. 5    100      EXAMPLE              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  407. EXAMPLE01.DBF
  408. 6    5        TBSUTF8_11G          NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  409. TBSUTF8_11G01.DBF
  410. 7    30       RCATTBS              NO      C:\APP\ADMINISTRATOR\ORADATA\UTFORCL\
  411. RCATTBS.DBF

  412. 临时文件列表
  413. =======================
  414. 文件大小 (MB) 表空间           最大大小 (MB) 临时文件名称
  415. ---- -------- -------------------- ----------- --------------------
  416. 1    29       TEMP                 32767       C:\APP\ADMINISTRATOR\ORADATA\UTFO
  417. RCL\TEMP01.DBF

  418. RMAN>
复制代码
  1. [root@station90 桌面]# obtool
  2. ob> exit
  3. [root@station90 桌面]# obtool
  4. ob> lspiece
  5. ob> exit
  6. [root@station90 桌面]# su - oracle
  7. [oracle@station90 ~]$ rman target /  

  8. Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 13 11:18:09 2017

  9. Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

  10. connected to target database: ORCL (DBID=1343950367)

  11. RMAN> show all;

  12. using target database control file instead of recovery catalog
  13. RMAN configuration parameters for database with db_unique_name ORCL are:
  14. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  15. CONFIGURE BACKUP OPTIMIZATION ON;
  16. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  17. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  18. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  19. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  20. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  21. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  22. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  23. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  24. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  25. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  26. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  27. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  28. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  29. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  30. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  31. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  32. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';
  33. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  34. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  35. RMAN> list backup;


  36. List of Backup Sets
  37. ===================


  38. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  39. ------- ---- -- ---------- ----------- ------------ ---------------
  40. 16      Full    9.38M      SBT_TAPE    00:00:15     20-OCT-13      
  41.         BP Key: 16   Status: EXPIRED  Compressed: NO  Tag: TAG20131020T172458
  42.         Handle: c-1343950367-20131020-01   Media: station90-000009
  43.   SPFILE Included: Modification time: 20-OCT-13
  44.   SPFILE db_unique_name: ORCL
  45.   Control File Included: Ckp SCN: 1042551      Ckp time: 20-OCT-13

  46. BS Key  Size       Device Type Elapsed Time Completion Time
  47. ------- ---------- ----------- ------------ ---------------
  48. 17      64.00K     SBT_TAPE    00:00:15     20-OCT-13      
  49.         BP Key: 17   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  50.         Handle: 0homt4ha_1_1   Media: station90-000009

  51.   List of Archived Logs in backup set 17
  52.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  53.   ---- ------- ---------- --------- ---------- ---------
  54.   1    13      1042532    20-OCT-13 1042606    20-OCT-13

  55. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  56. ------- ---- -- ---------- ----------- ------------ ---------------
  57. 18      Incr 1  128.00K    SBT_TAPE    00:00:15     20-OCT-13      
  58.         BP Key: 18   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  59.         Handle: 0iomt4hq_1_1   Media: station90-000009
  60.   List of Datafiles in backup set 18
  61.   File LV Type Ckp SCN    Ckp Time  Name
  62.   ---- -- ---- ---------- --------- ----
  63.   1    1  Incr 1042619    20-OCT-13 +DATA/orcl/datafile/system.256.816169553

  64. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  65. ------- ---- -- ---------- ----------- ------------ ---------------
  66. 19      Incr 1  7.44M      SBT_TAPE    00:00:24     20-OCT-13      
  67.         BP Key: 19   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  68.         Handle: 0jomt4hq_1_1   Media: station90-000010
  69.   List of Datafiles in backup set 19
  70.   File LV Type Ckp SCN    Ckp Time  Name
  71.   ---- -- ---- ---------- --------- ----
  72.   2    1  Incr 1042622    20-OCT-13 +DATA/orcl/datafile/sysaux.257.816169553

  73. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  74. ------- ---- -- ---------- ----------- ------------ ---------------
  75. 20      Incr 1  1.50M      SBT_TAPE    00:00:39     20-OCT-13      
  76.         BP Key: 20   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  77.         Handle: 0komt4hq_1_1   Media: station90-000010
  78.   List of Datafiles in backup set 20
  79.   File LV Type Ckp SCN    Ckp Time  Name
  80.   ---- -- ---- ---------- --------- ----
  81.   3    1  Incr 1042625    20-OCT-13 +DATA/orcl/datafile/undotbs1.258.816169553

  82. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  83. ------- ---- -- ---------- ----------- ------------ ---------------
  84. 21      Incr 1  64.00K     SBT_TAPE    00:00:40     20-OCT-13      
  85.         BP Key: 21   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  86.         Handle: 0lomt4hq_1_1   Media: station90-000009
  87.   List of Datafiles in backup set 21
  88.   File LV Type Ckp SCN    Ckp Time  Name
  89.   ---- -- ---- ---------- --------- ----
  90.   5    1  Incr 1042629    20-OCT-13 +DATA/orcl/datafile/example.265.816169651

  91. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  92. ------- ---- -- ---------- ----------- ------------ ---------------
  93. 22      Incr 1  64.00K     SBT_TAPE    00:00:53     20-OCT-13      
  94.         BP Key: 22   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  95.         Handle: 0momt4hr_1_1   Media: station90-000010
  96.   List of Datafiles in backup set 22
  97.   File LV Type Ckp SCN    Ckp Time  Name
  98.   ---- -- ---- ---------- --------- ----
  99.   4    1  Incr 1042632    20-OCT-13 +DATA/orcl/datafile/users.259.816169553

  100. BS Key  Size       Device Type Elapsed Time Completion Time
  101. ------- ---------- ----------- ------------ ---------------
  102. 23      640.00K    SBT_TAPE    00:00:15     20-OCT-13      
  103.         BP Key: 23   Status: EXPIRED  Compressed: NO  Tag: 3TCUMU_WHOLE_INCR1
  104.         Handle: 0nomt4ji_1_1   Media: station90-000009

  105.   List of Archived Logs in backup set 23
  106.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  107.   ---- ------- ---------- --------- ---------- ---------
  108.   1    14      1042606    20-OCT-13 1043204    20-OCT-13

  109. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  110. ------- ---- -- ---------- ----------- ------------ ---------------
  111. 24      Full    9.38M      SBT_TAPE    00:00:16     20-OCT-13      
  112.         BP Key: 24   Status: EXPIRED  Compressed: NO  Tag: TAG20131020T172739
  113.         Handle: c-1343950367-20131020-02   Media: station90-000009
  114.   SPFILE Included: Modification time: 20-OCT-13
  115.   SPFILE db_unique_name: ORCL
  116.   Control File Included: Ckp SCN: 1043235      Ckp time: 20-OCT-13

  117. BS Key  Size       Device Type Elapsed Time Completion Time
  118. ------- ---------- ----------- ------------ ---------------
  119. 25      16.00M     SBT_TAPE    00:00:25     12-DEC-16      
  120.         BP Key: 25   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  121.         Handle: 0prn9uun_1_1   Media: station90-000009

  122.   List of Archived Logs in backup set 25
  123.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  124.   ---- ------- ---------- --------- ---------- ---------
  125.   1    15      1043204    20-OCT-13 1047404    11-DEC-13

  126. BS Key  Size       Device Type Elapsed Time Completion Time
  127. ------- ---------- ----------- ------------ ---------------
  128. 26      15.50M     SBT_TAPE    00:00:25     12-DEC-16      
  129.         BP Key: 26   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  130.         Handle: 0qrn9uun_1_1   Media: station90-000010

  131.   List of Archived Logs in backup set 26
  132.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  133.   ---- ------- ---------- --------- ---------- ---------
  134.   1    16      1047404    11-DEC-13 1049898    11-DEC-13

  135. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  136. ------- ---- -- ---------- ----------- ------------ ---------------
  137. 27      Full    3.50M      SBT_TAPE    00:00:24     12-DEC-16      
  138.         BP Key: 27   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  139.         Handle: 0vrn9uvi_1_1   Media: station90-000010
  140.   List of Datafiles in backup set 27
  141.   File LV Type Ckp SCN    Ckp Time  Name
  142.   ---- -- ---- ---------- --------- ----
  143.   4       Full 1051009    12-DEC-16 +DATA/orcl/datafile/users.259.816169553

  144. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  145. ------- ---- -- ---------- ----------- ------------ ---------------
  146. 28      Full    588.75M    SBT_TAPE    00:01:04     12-DEC-16      
  147.         BP Key: 28   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  148.         Handle: 0rrn9uvh_1_1   Media: station90-000009
  149.   List of Datafiles in backup set 28
  150.   File LV Type Ckp SCN    Ckp Time  Name
  151.   ---- -- ---- ---------- --------- ----
  152.   1       Full 1051009    12-DEC-16 +DATA/orcl/datafile/system.256.816169553

  153. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  154. ------- ---- -- ---------- ----------- ------------ ---------------
  155. 29      Full    98.25M     SBT_TAPE    00:01:23     12-DEC-16      
  156.         BP Key: 29   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  157.         Handle: 0trn9uvh_1_1   Media: station90-000009
  158.   List of Datafiles in backup set 29
  159.   File LV Type Ckp SCN    Ckp Time  Name
  160.   ---- -- ---- ---------- --------- ----
  161.   3       Full 1051009    12-DEC-16 +DATA/orcl/datafile/undotbs1.258.816169553

  162. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  163. ------- ---- -- ---------- ----------- ------------ ---------------
  164. 30      Full    393.00M    SBT_TAPE    00:01:40     12-DEC-16      
  165.         BP Key: 30   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  166.         Handle: 0srn9uvh_1_1   Media: station90-000010
  167.   List of Datafiles in backup set 30
  168.   File LV Type Ckp SCN    Ckp Time  Name
  169.   ---- -- ---- ---------- --------- ----
  170.   2       Full 1051009    12-DEC-16 +DATA/orcl/datafile/sysaux.257.816169553

  171. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  172. ------- ---- -- ---------- ----------- ------------ ---------------
  173. 31      Full    69.25M     SBT_TAPE    00:01:59     12-DEC-16      
  174.         BP Key: 31   Status: EXPIRED  Compressed: NO  Tag: 4T_WHOLE_INCR0
  175.         Handle: 0urn9uvi_1_1   Media: station90-000009
  176.   List of Datafiles in backup set 31
  177.   File LV Type Ckp SCN    Ckp Time  Name
  178.   ---- -- ---- ---------- --------- ----
  179.   5       Full 1051009    12-DEC-16 +DATA/orcl/datafile/example.265.816169651

  180. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  181. ------- ---- -- ---------- ----------- ------------ ---------------
  182. 32      Full    9.50M      SBT_TAPE    00:00:16     12-DEC-16      
  183.         BP Key: 32   Status: EXPIRED  Compressed: NO  Tag: TAG20161212T161439
  184.         Handle: c-1343950367-20161212-00   Media: station90-000009
  185.   SPFILE Included: Modification time: 12-DEC-16
  186.   SPFILE db_unique_name: ORCL
  187.   Control File Included: Ckp SCN: 1051009      Ckp time: 12-DEC-16

  188. RMAN> list copy;

  189. specification does not match any datafile copy in the repository
  190. specification does not match any control file copy in the repository
  191. List of Archived Log Copies for database with db_unique_name ORCL
  192. =====================================================================

  193. Key     Thrd Seq     S Low Time
  194. ------- ---- ------- - ---------
  195. 9       1    17      A 11-DEC-13
  196.         Name: +FRA/orcl/archivelog/2017_05_13/thread_1_seq_17.262.943874229


  197. RMAN> list backup;

  198. specification does not match any backup in the repository

  199. RMAN> show exclude;

  200. RMAN configuration parameters for database with db_unique_name ORCL are:
  201. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';

  202. RMAN> backup database ;

  203. Starting backup at 13-MAY-17
  204. allocated channel: ORA_SBT_TAPE_1
  205. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  206. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  207. allocated channel: ORA_SBT_TAPE_2
  208. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
  209. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  210. file 2 is excluded from whole database backup
  211. channel ORA_SBT_TAPE_1: starting full datafile backup set
  212. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  213. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  214. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  215. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  216. channel ORA_SBT_TAPE_2: starting full datafile backup set
  217. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  218. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  219. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  220. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
  221. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
  222. piece handle=14s44oaj_1_1 tag=TAG20170513T111946 comment=API Version 2.0,MMS Version 10.4.0.4
  223. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  224. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
  225. piece handle=13s44oai_1_1 tag=TAG20170513T111946 comment=API Version 2.0,MMS Version 10.4.0.4
  226. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:36
  227. Finished backup at 13-MAY-17

  228. Starting Control File and SPFILE Autobackup at 13-MAY-17
  229. piece handle=c-1343950367-20170513-00 comment=API Version 2.0,MMS Version 10.4.0.4
  230. Finished Control File and SPFILE Autobackup at 13-MAY-17

  231. RMAN> show exclude;

  232. RMAN configuration parameters for database with db_unique_name ORCL are:
  233. CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX';

  234. RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'SYSAUX' clear;

  235. Tablespace SYSAUX will be included in future whole database backups
  236. old RMAN configuration parameters are successfully deleted

  237. RMAN> show exclude;

  238. RMAN configuration parameters for database with db_unique_name ORCL are:
  239. RMAN configuration has no stored or default parameters

  240. RMAN> backup database ;

  241. Starting backup at 13-MAY-17
  242. using channel ORA_SBT_TAPE_1
  243. using channel ORA_SBT_TAPE_2
  244. channel ORA_SBT_TAPE_1: starting full datafile backup set
  245. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  246. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  247. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  248. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  249. channel ORA_SBT_TAPE_2: starting full datafile backup set
  250. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  251. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  252. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  253. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  254. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
  255. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
  256. piece handle=16s44odp_1_1 tag=TAG20170513T112129 comment=API Version 2.0,MMS Version 10.4.0.4
  257. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  258. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
  259. piece handle=17s44odp_1_1 tag=TAG20170513T112129 comment=API Version 2.0,MMS Version 10.4.0.4
  260. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
  261. Finished backup at 13-MAY-17

  262. Starting Control File and SPFILE Autobackup at 13-MAY-17
  263. piece handle=c-1343950367-20170513-01 comment=API Version 2.0,MMS Version 10.4.0.4
  264. Finished Control File and SPFILE Autobackup at 13-MAY-17

  265. RMAN> list backup;


  266. List of Backup Sets
  267. ===================


  268. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  269. ------- ---- -- ---------- ----------- ------------ ---------------
  270. 33      Full    167.50M    SBT_TAPE    00:00:17     13-MAY-17      
  271.         BP Key: 33   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T111946
  272.         Handle: 14s44oaj_1_1   Media: station90-000010
  273.   List of Datafiles in backup set 33
  274.   File LV Type Ckp SCN    Ckp Time  Name
  275.   ---- -- ---- ---------- --------- ----
  276.   3       Full 1056529    13-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
  277.   5       Full 1056529    13-MAY-17 +DATA/orcl/datafile/example.265.816169651

  278. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  279. ------- ---- -- ---------- ----------- ------------ ---------------
  280. 34      Full    592.25M    SBT_TAPE    00:00:26     13-MAY-17      
  281.         BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T111946
  282.         Handle: 13s44oai_1_1   Media: station90-000009
  283.   List of Datafiles in backup set 34
  284.   File LV Type Ckp SCN    Ckp Time  Name
  285.   ---- -- ---- ---------- --------- ----
  286.   1       Full 1056527    13-MAY-17 +DATA/orcl/datafile/system.256.816169553
  287.   4       Full 1056527    13-MAY-17 +DATA/orcl/datafile/users.259.816169553

  288. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  289. ------- ---- -- ---------- ----------- ------------ ---------------
  290. 35      Full    9.50M      SBT_TAPE    00:00:16     13-MAY-17      
  291.         BP Key: 35   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112022
  292.         Handle: c-1343950367-20170513-00   Media: station90-000009
  293.   SPFILE Included: Modification time: 13-MAY-17
  294.   SPFILE db_unique_name: ORCL
  295.   Control File Included: Ckp SCN: 1056606      Ckp time: 13-MAY-17

  296. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  297. ------- ---- -- ---------- ----------- ------------ ---------------
  298. 36      Full    658.00M    SBT_TAPE    00:00:20     13-MAY-17      
  299.         BP Key: 36   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112129
  300.         Handle: 16s44odp_1_1   Media: station90-000009
  301.   List of Datafiles in backup set 36
  302.   File LV Type Ckp SCN    Ckp Time  Name
  303.   ---- -- ---- ---------- --------- ----
  304.   1       Full 1056703    13-MAY-17 +DATA/orcl/datafile/system.256.816169553
  305.   5       Full 1056703    13-MAY-17 +DATA/orcl/datafile/example.265.816169651

  306. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  307. ------- ---- -- ---------- ----------- ------------ ---------------
  308. 37      Full    495.25M    SBT_TAPE    00:00:25     13-MAY-17      
  309.         BP Key: 37   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112129
  310.         Handle: 17s44odp_1_1   Media: station90-000010
  311.   List of Datafiles in backup set 37
  312.   File LV Type Ckp SCN    Ckp Time  Name
  313.   ---- -- ---- ---------- --------- ----
  314.   2       Full 1056705    13-MAY-17 +DATA/orcl/datafile/sysaux.257.816169553
  315.   3       Full 1056705    13-MAY-17 +DATA/orcl/datafile/undotbs1.258.816169553
  316.   4       Full 1056705    13-MAY-17 +DATA/orcl/datafile/users.259.816169553

  317. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  318. ------- ---- -- ---------- ----------- ------------ ---------------
  319. 38      Full    9.50M      SBT_TAPE    00:00:16     13-MAY-17      
  320.         BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20170513T112154
  321.         Handle: c-1343950367-20170513-01   Media: station90-000009
  322.   SPFILE Included: Modification time: 13-MAY-17
  323.   SPFILE db_unique_name: ORCL
  324.   Control File Included: Ckp SCN: 1056735      Ckp time: 13-MAY-17

  325. RMAN> show all;

  326. RMAN configuration parameters for database with db_unique_name ORCL are:
  327. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  328. CONFIGURE BACKUP OPTIMIZATION ON;
  329. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  330. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  331. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  332. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  333. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  334. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  335. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  336. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  337. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  338. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  339. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  340. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  341. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  342. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  343. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  344. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  345. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  346. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  347. RMAN> CONFIGURE COMPRESSION ALGORITHM low AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;

  348. RMAN-00571: ===========================================================
  349. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  350. RMAN-00571: ===========================================================
  351. RMAN-00558: error encountered while parsing input commands
  352. RMAN-01009: syntax error: found "low": expecting one of: "clear, double-quoted-string, single-quoted-string"
  353. RMAN-01007: at line 1 column 33 file: standard input

  354. RMAN>

  355. RMAN> ONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;

  356. RMAN-00571: ===========================================================
  357. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  358. RMAN-00571: ===========================================================
  359. RMAN-00558: error encountered while parsing input commands
  360. RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
  361. RMAN-01008: the bad identifier was: ONFIGURE
  362. RMAN-01007: at line 2 column 1 file: standard input

  363. RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ;

  364. new RMAN configuration parameters:
  365. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
  366. new RMAN configuration parameters are successfully stored

  367. RMAN> show all;

  368. RMAN configuration parameters for database with db_unique_name ORCL are:
  369. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  370. CONFIGURE BACKUP OPTIMIZATION ON;
  371. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  372. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  373. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  374. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  375. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  376. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  377. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  378. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  379. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  380. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  381. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  382. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  383. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  384. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  385. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  386. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
  387. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  388. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  389. RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO compressed BACKUPSET;

  390. old RMAN configuration parameters:
  391. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  392. new RMAN configuration parameters:
  393. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
  394. new RMAN configuration parameters are successfully stored
  395. released channel: ORA_SBT_TAPE_1
  396. released channel: ORA_SBT_TAPE_2

  397. RMAN> backup database ;

  398. Starting backup at 13-MAY-17
  399. allocated channel: ORA_SBT_TAPE_1
  400. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  401. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  402. allocated channel: ORA_SBT_TAPE_2
  403. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
  404. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  405. channel ORA_SBT_TAPE_1: starting compressed full datafile backup set
  406. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  407. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  408. input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
  409. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  410. channel ORA_SBT_TAPE_2: starting compressed full datafile backup set
  411. channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
  412. input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
  413. input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
  414. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  415. channel ORA_SBT_TAPE_2: starting piece 1 at 13-MAY-17
  416. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
  417. piece handle=19s44op7_1_1 tag=TAG20170513T112735 comment=API Version 2.0,MMS Version 10.4.0.4
  418. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
  419. channel ORA_SBT_TAPE_2: finished piece 1 at 13-MAY-17
  420. piece handle=1as44op7_1_1 tag=TAG20170513T112735 comment=API Version 2.0,MMS Version 10.4.0.4
  421. channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
  422. Finished backup at 13-MAY-17

  423. Starting Control File and SPFILE Autobackup at 13-MAY-17
  424. piece handle=c-1343950367-20170513-02 comment=API Version 2.0,MMS Version 10.4.0.4
  425. Finished Control File and SPFILE Autobackup at 13-MAY-17

  426. RMAN> show all
  427. 2> ;

  428. RMAN configuration parameters for database with db_unique_name ORCL are:
  429. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  430. CONFIGURE BACKUP OPTIMIZATION ON;
  431. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  432. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  433. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  434. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  435. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  436. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
  437. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  438. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  439. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  440. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  441. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  442. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  443. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  444. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  445. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  446. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
  447. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  448. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  449. RMAN> CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE clear;

  450. RMAN-00571: ===========================================================
  451. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  452. RMAN-00571: ===========================================================
  453. RMAN-00558: error encountered while parsing input commands
  454. RMAN-01009: syntax error: found "clear": expecting one of: "as, for, optimize, ;"
  455. RMAN-01007: at line 1 column 86 file: standard input

  456. RMAN> CONFIGURE COMPRESSION ALGORITHM  clear;

  457. old RMAN configuration parameters:
  458. CONFIGURE COMPRESSION ALGORITHM 'LOW' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
  459. RMAN configuration parameters are successfully reset to default value

  460. RMAN> show all;

  461. RMAN configuration parameters for database with db_unique_name ORCL are:
  462. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  463. CONFIGURE BACKUP OPTIMIZATION ON;
  464. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  465. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  466. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  467. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  468. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  469. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
  470. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  471. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  472. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  473. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  474. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  475. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  476. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  477. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  478. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  479. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  480. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  481. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  482. RMAN> CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;

  483. old RMAN configuration parameters:
  484. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
  485. new RMAN configuration parameters:
  486. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  487. new RMAN configuration parameters are successfully stored
  488. released channel: ORA_SBT_TAPE_1
  489. released channel: ORA_SBT_TAPE_2

  490. RMAN> run {
  491. 2> set COMPRESSION ALGORITHM 'HIGH' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
  492. 3> backup as compressed backupset  tablespace system ;
  493. 4> }

  494. RMAN-00571: ===========================================================
  495. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  496. RMAN-00571: ===========================================================
  497. RMAN-03032: this option of set command needs to be used outside of a run block

  498. RMAN> run {
  499. 2>   set COMPRESSION ALGORITHM 'HIGH';
  500. 3> backup as compressed backupset  tablespace system ;
  501. 4> }

  502. RMAN-00571: ===========================================================
  503. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  504. RMAN-00571: ===========================================================
  505. RMAN-03032: this option of set command needs to be used outside of a run block

  506. RMAN> run {
  507. 2>  SET COMPRESSION ALGORITHM 'HIGH';
  508. 3> backup as compressed backupset  tablespace system ;
  509. 4> }

  510. RMAN-00571: ===========================================================
  511. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  512. RMAN-00571: ===========================================================
  513. RMAN-03032: this option of set command needs to be used outside of a run block

  514. RMAN> backup as compressed backupset  tablespace system ;

  515. Starting backup at 13-MAY-17
  516. allocated channel: ORA_SBT_TAPE_1
  517. channel ORA_SBT_TAPE_1: SID=15 device type=SBT_TAPE
  518. channel ORA_SBT_TAPE_1: Oracle Secure Backup
  519. allocated channel: ORA_SBT_TAPE_2
  520. channel ORA_SBT_TAPE_2: SID=80 device type=SBT_TAPE
  521. channel ORA_SBT_TAPE_2: Oracle Secure Backup
  522. channel ORA_SBT_TAPE_1: starting compressed full datafile backup set
  523. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  524. input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
  525. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  526. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
  527. piece handle=1cs44p3n_1_1 tag=TAG20170513T113311 comment=API Version 2.0,MMS Version 10.4.0.4
  528. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
  529. Finished backup at 13-MAY-17

  530. Starting Control File and SPFILE Autobackup at 13-MAY-17
  531. piece handle=c-1343950367-20170513-03 comment=API Version 2.0,MMS Version 10.4.0.4
  532. Finished Control File and SPFILE Autobackup at 13-MAY-17

  533. RMAN> show all;

  534. RMAN configuration parameters for database with db_unique_name ORCL are:
  535. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
  536. CONFIGURE BACKUP OPTIMIZATION ON;
  537. CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
  538. CONFIGURE CONTROLFILE AUTOBACKUP ON;
  539. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  540. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
  541. CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
  542. CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  543. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  544. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  545. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  546. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
  547. CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  548. CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(OB_MEDIA_FAMILY=station90)';
  549. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  550. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  551. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  552. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  553. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  554. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default

  555. RMAN> CONFIGURE ENCRYPTION FOR DATABASE on;

  556. new RMAN configuration parameters:
  557. CONFIGURE ENCRYPTION FOR DATABASE ON;
  558. new RMAN configuration parameters are successfully stored

  559. RMAN> backup tablespace users;

  560. Starting backup at 13-MAY-17
  561. using channel ORA_SBT_TAPE_1
  562. using channel ORA_SBT_TAPE_2
  563. channel ORA_SBT_TAPE_1: starting full datafile backup set
  564. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  565. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  566. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  567. RMAN-00571: ===========================================================
  568. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  569. RMAN-00571: ===========================================================
  570. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/13/2017 12:01:13
  571. ORA-19914: unable to encrypt backup
  572. ORA-28365: wallet is not open

  573. RMAN> set encrypt on identified by  oracle123;

  574. RMAN-00571: ===========================================================
  575. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  576. RMAN-00571: ===========================================================
  577. RMAN-00558: error encountered while parsing input commands
  578. RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, autobackup, auxiliary, auxname, backup, command, compression, controlfile, database, dbid, decryption, echo, encryption, high, incarnation, maxcorrupt, maxseq, newname, nocfau, restore, snapshot, to restore point, until restore point, until"
  579. RMAN-01008: the bad identifier was: encrypt
  580. RMAN-01007: at line 1 column 5 file: standard input

  581. RMAN> set encryption on identified by  oracle123;

  582. executing command: SET encryption

  583. RMAN> set encryption on identified by  oracle123  only;

  584. executing command: SET encryption

  585. RMAN> backup tablespace users;

  586. Starting backup at 13-MAY-17
  587. using channel ORA_SBT_TAPE_1
  588. using channel ORA_SBT_TAPE_2
  589. channel ORA_SBT_TAPE_1: starting full datafile backup set
  590. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  591. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  592. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  593. channel ORA_SBT_TAPE_1: finished piece 1 at 13-MAY-17
  594. piece handle=1fs44qps_1_1 tag=TAG20170513T120204 comment=API Version 2.0,MMS Version 10.4.0.4
  595. channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
  596. Finished backup at 13-MAY-17

  597. Starting Control File and SPFILE Autobackup at 13-MAY-17
  598. piece handle=c-1343950367-20170513-04 comment=API Version 2.0,MMS Version 10.4.0.4
  599. Finished Control File and SPFILE Autobackup at 13-MAY-17

  600. RMAN> set encryption on identified by  oracle123 ;

  601. executing command: SET encryption

  602. RMAN> backup tablespace users;

  603. Starting backup at 13-MAY-17
  604. using channel ORA_SBT_TAPE_1
  605. using channel ORA_SBT_TAPE_2
  606. channel ORA_SBT_TAPE_1: starting full datafile backup set
  607. channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
  608. input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
  609. channel ORA_SBT_TAPE_1: starting piece 1 at 13-MAY-17
  610. RMAN-00571: ===========================================================
  611. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  612. RMAN-00571: ===========================================================
  613. RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 05/13/2017 12:03:05
  614. ORA-19914: unable to encrypt backup
  615. ORA-28365: wallet is not open

  616. RMAN> exit


  617. Recovery Manager complete.
  618. [oracle@station90 ~]$ cd
  619. [oracle@station90 ~]$ sqlplus /nolog

  620. SQL*Plus: Release 11.2.0.1.0 Production on Sat May 13 12:04:22 2017

  621. Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  622. SQL> conn / as sysdba
  623. Connected.
  624. SQL> select  * from v$encryption_wallet;

  625. WRL_TYPE
  626. --------------------
  627. WRL_PARAMETER
  628. --------------------------------------------------------------------------------
  629. STATUS
  630. ------------------
  631. file
  632. /u01/app/oracle/admin/orcl/wallet
  633. CLOSED


  634. SQL> alter system set encryption key identified by oracle456;

  635. System altered.

  636. SQL> select  * from v$encryption_wallet;

  637. WRL_TYPE
  638. --------------------
  639. WRL_PARAMETER
  640. --------------------------------------------------------------------------------
  641. STATUS
  642. ------------------
  643. file
  644. /u01/app/oracle/admin/orcl/wallet
  645. OPEN


  646. SQL>
复制代码
  1. SELECT filename, status, bytes
  2.     FROM   v$block_change_tracking;


  3. SELECT file#, avg(datafile_blocks),
  4.            avg(blocks_read),
  5.            avg(blocks_read/datafile_blocks)
  6.                * 100 AS PCT_READ_FOR_BACKUP,
  7.            avg(blocks)
  8.    FROM   v$backup_datafile
  9.    WHERE  used_change_tracking = 'YES'
  10.    AND    incremental_level > 0
  11.    and file#=4
  12.     GROUP  BY file#;
  13.    
  14.     select   s.segment_name,s.bytes/1024/1024
  15.       from dba_segments s
  16.       where s.owner='HR' and s.segment_name='T_BIG';
复制代码



回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-29 19:38 , Processed in 0.044726 second(s), 24 queries .

快速回复 返回顶部 返回列表