API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 6th, 2016
665
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.88 KB | None | 0 0
raw download clone embed print report
  1.  
  2. SQL*Plus: Release 12.1.0.2.0 Production on Sun Nov 6 18:15:34 2016
  3.  
  4. Copyright (c) 1982, 2014, Oracle. All rights reserved.
  5.  
  6. Enter user-name: sys as sysdba
  7. Enter password:
  8.  
  9. Connected to:
  10. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
  11. With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
  12. and Unified Auditing options
  13.  
  14. SQL> select log_mode from v$database;
  15.  
  16. LOG_MODE
  17. ------------
  18. ARCHIVELOG
  19.  
  20. SQL> alter database open;
  21. alter database open
  22. *
  23. ERROR at line 1:
  24. ORA-01531: a database already open by the instance
  25.  
  26.  
  27. SQL> select supplemental_log_data_min from v$database;
  28.  
  29. SUPPLEME
  30. --------
  31. YES
  32.  
  33. SQL> show parameter utl_file_dir
  34.  
  35. NAME TYPE VALUE
  36. ------------------------------------ ----------- ------------------------------
  37. utl_file_dir string
  38. SQL> Create Pfile from SPfile;
  39.  
  40. File created.
  41.  
  42. SQL> shutdown immediate;
  43. Database closed.
  44. Database dismounted.
  45. ORACLE instance shut down.
  46. SQL> select name, value from v$parameter where name like 'utl_file_dir';
  47. select name, value from v$parameter where name like 'utl_file_dir'
  48. *
  49. ERROR at line 1:
  50. ORA-01034: ORACLE not available
  51. Process ID: 0
  52. Session ID: 0 Serial number: 0
  53.  
  54.  
  55. ERROR:
  56. ORA-01034: ORACLE not available
  57. Process ID: 0
  58. Session ID: 0 Serial number: 0
  59.  
  60.  
  61. SQL> startup mount
  62. ORACLE instance started.
  63.  
  64. Total System Global Area 5117050880 bytes
  65. Fixed Size 3056232 bytes
  66. Variable Size 1040190872 bytes
  67. Database Buffers 4060086272 bytes
  68. Redo Buffers 13717504 bytes
  69. Database mounted.
  70. SQL> select name, value from v$parameter where name like 'utl_file_dir';
  71.  
  72. NAME
  73. --------------------------------------------------
  74. VALUE
  75. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  76. utl_file_dir
  77.  
  78.  
  79.  
  80. SQL> shutdown immediate;
  81. ORA-01109: database not open
  82.  
  83.  
  84. Database dismounted.
  85. ORACLE instance shut down.
  86. SQL> startup pfile='C:\app\Oracle12\product\12.1.0\dbhome_1\database\INItorcl.ORA';
  87. ORACLE instance started.
  88.  
  89. Total System Global Area 5117050880 bytes
  90. Fixed Size 3056232 bytes
  91. Variable Size 1040190872 bytes
  92. Database Buffers 4060086272 bytes
  93. Redo Buffers 13717504 bytes
  94. Database mounted.
  95. Database opened.
  96. SQL> show parameter utl_file_dir
  97.  
  98. NAME TYPE VALUE
  99. ------------------------------------ ----------- ------------------------------
  100. utl_file_dir string C:\app\backup\logmnr
  101. SQL> select supplemental_log_data_min from v$database;
  102.  
  103. SUPPLEME
  104. --------
  105. YES
  106.  
  107. SQL> show parameter db_recovery_file_dest;
  108.  
  109. NAME TYPE VALUE
  110. ------------------------------------ ----------- ------------------------------
  111. db_recovery_file_dest string
  112. db_recovery_file_dest_size big integer 0
  113. SQL> Alter system set db_recovery_file_dest_size=20G;
  114.  
  115. System altered.
  116.  
  117. SQL> Alter system set db_recovery_file_dest='C:\app\backup';
  118.  
  119. System altered.
  120.  
  121. SQL> begin
  122. 2 dbms_logmnr_d.build(
  123. 3 dictionary_filename => 'dictionary.ora',
  124. 4 dictionary_location => 'C:\app\backup\logmnr',
  125. 5 options => dbms_logmnr_d.store_in_flat_file);
  126. 6 end;
  127. 7 /
  128.  
  129. PL/SQL procedure successfully completed.
  130.  
  131. SQL> conn test/test@pdborcl
  132. ERROR:
  133. ORA-01033: ORACLE initialization or shutdown in progress
  134. Process ID: 0
  135. Session ID: 0 Serial number: 0
  136.  
  137.  
  138. Warning: You are no longer connected to ORACLE.
  139. SQL> conn test/test@pdborcl
  140. ERROR:
  141. ORA-01033: ORACLE initialization or shutdown in progress
  142. Process ID: 0
  143. Session ID: 0 Serial number: 0
  144.  
  145.  
  146. SQL> conn sys as sysdba
  147. Enter password:
  148. Connected.
  149. SQL> conn sys@pdborcl as sysdba
  150. Enter password:
  151. Connected.
  152. SQL> Create user test identified by test
  153. 2 Default tablespace users
  154. 3 Temporary tablespace temp
  155. 4 Quota unlimited on users;
  156. Create user test identified by test
  157. *
  158. ERROR at line 1:
  159. ORA-01109: database not open
  160.  
  161.  
  162. SQL> Grant create session, create procedure to test;
  163. Grant create session, create procedure to test
  164. *
  165. ERROR at line 1:
  166. ORA-01109: database not open
  167.  
  168.  
  169. SQL> Grant execute on list_libraries to test;
  170. Grant execute on list_libraries to test
  171. *
  172. ERROR at line 1:
  173. ORA-01109: database not open
  174.  
  175.  
  176. SQL> alter pluggable database pdborcl open read write;
  177.  
  178. Pluggable database altered.
  179.  
  180. SQL> conn test/test@pdborcl
  181. Connected.
  182. SQL> exec sys.list_libraries('NOUSER''||test.get_dba() --');
  183. BEGIN sys.list_libraries('NOUSER''||test.get_dba() --'); END;
  184.  
  185. *
  186. ERROR at line 1:
  187. ORA-06598: insufficient INHERIT PRIVILEGES privilege
  188. ORA-06512: at "TEST.GET_DBA", line 1
  189. ORA-06512: at "SYS.LIST_LIBRARIES", line 9
  190. ORA-06512: at line 1
  191.  
  192.  
  193. SQL> conn sys as sysdba
  194. Enter password:
  195. Connected.
  196. SQL> alter system switch logfile;
  197.  
  198. System altered.
  199.  
  200. SQL> begin
  201. 2 dbms_logmnr.add_logfile( LogFileName =>’C:/app/backup/archive/ARC0000000240_0922032286.0001’,
  202. 3 options => DBMS_LOGMNR.NEW);
  203. 4 end;
  204. 5 /
  205.  
  206. PL/SQL procedure successfully completed.
  207.  
  208. SQL> begin
  209. 2 dbms_logmnr.add_logfile( LogFileName =>
  210. 3 ' C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001',
  211. 4 options => DBMS_LOGMNR.ADDFILE);
  212. 5 end;
  213. 6 /
  214. begin
  215. *
  216. ERROR at line 1:
  217. ORA-01284: file C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001 cannot be opened
  218. ORA-00308: cannot open archived log ' C:/app/backup/CDB1/archivelog/2016_10_31/ ARC0000000241_0922032286.0001'
  219. ORA-27041: unable to open file
  220. OSD-04002: unable to open file
  221. O/S-Error: (OS 123) The filename, directory name, or volume label syntax is incorrect.
  222. ORA-06512: at "SYS.DBMS_LOGMNR", line 68
  223. ORA-06512: at line 2
  224.  
  225.  
  226. SQL> begin
  227. 2 dbms_logmnr.add_logfile( LogFileName =>
  228. 3 'C:/app/backup/archive/ARC0000000241_0922032286.0001',
  229. 4 options => DBMS_LOGMNR.ADDFILE);
  230. 5 end;
  231. 6 /
  232.  
  233. PL/SQL procedure successfully completed.
  234.  
  235. SQL> begin
  236. 2 dbms_logmnr.add_logfile( LogFileName =>
  237. 3 'C:/app/backup/archive/ARC0000000242_0922032286.0001',
  238. 4 options => DBMS_LOGMNR.ADDFILE);
  239. 5 end;
  240. 6 /
  241.  
  242. PL/SQL procedure successfully completed.
  243.  
  244. SQL> begin
  245. 2 dbms_logmnr.start_logmnr( options => dbms_logmnr.dict_from_redo_logs +
  246. 3 dbms_logmnr.ddl_dict_tracking +
  247. 4 dbms_logmnr.print_pretty_sql);
  248. 5 end;
  249. 6 /
  250. begin
  251. *
  252. ERROR at line 1:
  253. ORA-01371: Complete LogMiner dictionary not found
  254. ORA-06512: at "SYS.DBMS_LOGMNR", line 58
  255. ORA-06512: at line 2
  256.  
  257.  
  258. SQL> Execute dbms_logmnr.start_logmnr( -
  259. > DICTFILENAME => 'C:\app\backup\logmnr\dictionary.ora');
  260.  
  261. PL/SQL procedure successfully completed.
  262.  
  263. SQL> Select username, operation, sql_redo, sql_undo from v$logmnr_contents where username =’TEST’;
  264.  
  265. no rows selected
  266.  
  267. SQL> Select username, operation, sql_redo, sql_undo from v$logmnr_contents where username =’UNKNOWN’;
  268.  
  269. no rows selected
  270.  
  271. SQL> SELECT
  272. 2 name
  273. 3 , TO_CHAR(first_time, 'DD-MON-YYYY HH24:MI:SS') first_time
  274. 4 FROM
  275. 5 v$archived_log
  276. 6 WHERE
  277. 7 name IS NOT NULL
  278. 8 ORDER BY
  279. 9 sequence#;
  280.  
  281. NAME FIRST_TIME
  282. -------------------------------------------------- --------------------
  283. C:\APP\BACKUP\ARCHIVE\ARC0000000213_0922032286.000 03-NOV-2016 15:41:59
  284. 1
  285.  
  286. C:\APP\BACKUP\ARCHIVE\ARC0000000214_0922032286.000 03-NOV-2016 16:46:55
  287. 1
  288.  
  289. C:\APP\BACKUP\ARCHIVE\ARC0000000215_0922032286.000 03-NOV-2016 16:52:16
  290. 1
  291.  
  292. C:\APP\BACKUP\ARCHIVE\ARC0000000216_0922032286.000 03-NOV-2016 17:04:33
  293. 1
  294.  
  295. NAME FIRST_TIME
  296. -------------------------------------------------- --------------------
  297.  
  298. C:\APP\BACKUP\ARCHIVE\ARC0000000217_0922032286.000 03-NOV-2016 18:04:11
  299. 1
  300.  
  301. C:\APP\BACKUP\ARCHIVE\ARC0000000218_0922032286.000 03-NOV-2016 18:08:54
  302. 1
  303.  
  304. C:\APP\BACKUP\ARCHIVE\ARC0000000219_0922032286.000 03-NOV-2016 18:13:25
  305. 1
  306.  
  307. C:\APP\BACKUP\ARCHIVE\ARC0000000220_0922032286.000 03-NOV-2016 18:14:01
  308.  
  309. NAME FIRST_TIME
  310. -------------------------------------------------- --------------------
  311. 1
  312.  
  313. C:\APP\BACKUP\ARCHIVE\ARC0000000221_0922032286.000 03-NOV-2016 18:14:46
  314. 1
  315.  
  316. C:\APP\BACKUP\ARCHIVE\ARC0000000222_0922032286.000 03-NOV-2016 18:16:06
  317. 1
  318.  
  319. C:\APP\BACKUP\ARCHIVE\ARC0000000223_0922032286.000 03-NOV-2016 18:21:04
  320. 1
  321.  
  322.  
  323. NAME FIRST_TIME
  324. -------------------------------------------------- --------------------
  325. C:\APP\BACKUP\ARCHIVE\ARC0000000224_0922032286.000 03-NOV-2016 18:21:10
  326. 1
  327.  
  328. C:\APP\BACKUP\ARCHIVE\ARC0000000225_0922032286.000 03-NOV-2016 18:21:22
  329. 1
  330.  
  331. C:\APP\BACKUP\ARCHIVE\ARC0000000226_0922032286.000 03-NOV-2016 22:36:54
  332. 1
  333.  
  334. C:\APP\BACKUP\ARCHIVE\ARC0000000227_0922032286.000 03-NOV-2016 22:42:57
  335. 1
  336.  
  337. NAME FIRST_TIME
  338. -------------------------------------------------- --------------------
  339.  
  340. C:\APP\BACKUP\ARCHIVE\ARC0000000228_0922032286.000 03-NOV-2016 23:00:51
  341. 1
  342.  
  343. C:\APP\BACKUP\ARCHIVE\ARC0000000229_0922032286.000 03-NOV-2016 23:41:58
  344. 1
  345.  
  346. C:\APP\BACKUP\ARCHIVE\ARC0000000230_0922032286.000 04-NOV-2016 14:09:59
  347. 1
  348.  
  349. C:\APP\BACKUP\ARCHIVE\ARC0000000231_0922032286.000 04-NOV-2016 21:42:25
  350.  
  351. NAME FIRST_TIME
  352. -------------------------------------------------- --------------------
  353. 1
  354.  
  355. C:\APP\BACKUP\ARCHIVE\ARC0000000232_0922032286.000 04-NOV-2016 22:10:12
  356. 1
  357.  
  358. C:\APP\BACKUP\ARCHIVE\ARC0000000233_0922032286.000 04-NOV-2016 23:08:40
  359. 1
  360.  
  361. C:\APP\BACKUP\ARCHIVE\ARC0000000234_0922032286.000 05-NOV-2016 02:00:46
  362. 1
  363.  
  364.  
  365. NAME FIRST_TIME
  366. -------------------------------------------------- --------------------
  367. C:\APP\BACKUP\ARCHIVE\ARC0000000235_0922032286.000 05-NOV-2016 11:22:27
  368. 1
  369.  
  370. C:\APP\BACKUP\ARCHIVE\ARC0000000236_0922032286.000 05-NOV-2016 11:27:36
  371. 1
  372.  
  373. C:\APP\BACKUP\ARCHIVE\ARC0000000237_0922032286.000 05-NOV-2016 12:55:34
  374. 1
  375.  
  376. C:\APP\BACKUP\ARCHIVE\ARC0000000238_0922032286.000 05-NOV-2016 20:00:23
  377. 1
  378.  
  379. NAME FIRST_TIME
  380. -------------------------------------------------- --------------------
  381.  
  382. C:\APP\BACKUP\ARCHIVE\ARC0000000239_0922032286.000 05-NOV-2016 22:00:30
  383. 1
  384.  
  385. C:\APP\BACKUP\ARCHIVE\ARC0000000240_0922032286.000 06-NOV-2016 16:25:41
  386. 1
  387.  
  388. C:\APP\BACKUP\ARCHIVE\ARC0000000241_0922032286.000 06-NOV-2016 17:53:00
  389. 1
  390.  
  391. C:\APP\BACKUP\ARCHIVE\ARC0000000242_0922032286.000 06-NOV-2016 18:03:44
  392.  
  393. NAME FIRST_TIME
  394. -------------------------------------------------- --------------------
  395. 1
  396.  
  397.  
  398. 30 rows selected.
  399.  
  400. SQL> COLUMN name FORMAT A66 HEAD "Log File Name"
  401. SQL> COLUMN first_time FORMAT A23 HEAD "First Time"
  402. SQL> COLUMN name FORMAT A66 HEAD "Log File Name"
  403. SQL> COLUMN name FORMAT A66 HEAD "Log File Name"
  404. SQL> SELECT
  405. 2 name
  406. 3 , TO_CHAR(first_time, 'DD-MON-YYYY HH24:MI:SS') first_time
  407. 4 FROM
  408. 5 v$archived_log
  409. 6 WHERE
  410. 7 name IS NOT NULL
  411. 8 ORDER BY
  412. 9 sequence#;
  413.  
  414. Log File Name First Time
  415. ------------------------------------------------------------------ -----------------------
  416. C:\APP\BACKUP\ARCHIVE\ARC0000000213_0922032286.0001 03-NOV-2016 15:41:59
  417. C:\APP\BACKUP\ARCHIVE\ARC0000000214_0922032286.0001 03-NOV-2016 16:46:55
  418. C:\APP\BACKUP\ARCHIVE\ARC0000000215_0922032286.0001 03-NOV-2016 16:52:16
  419. C:\APP\BACKUP\ARCHIVE\ARC0000000216_0922032286.0001 03-NOV-2016 17:04:33
  420. C:\APP\BACKUP\ARCHIVE\ARC0000000217_0922032286.0001 03-NOV-2016 18:04:11
  421. C:\APP\BACKUP\ARCHIVE\ARC0000000218_0922032286.0001 03-NOV-2016 18:08:54
  422. C:\APP\BACKUP\ARCHIVE\ARC0000000219_0922032286.0001 03-NOV-2016 18:13:25
  423. C:\APP\BACKUP\ARCHIVE\ARC0000000220_0922032286.0001 03-NOV-2016 18:14:01
  424. C:\APP\BACKUP\ARCHIVE\ARC0000000221_0922032286.0001 03-NOV-2016 18:14:46
  425. C:\APP\BACKUP\ARCHIVE\ARC0000000222_0922032286.0001 03-NOV-2016 18:16:06
  426. C:\APP\BACKUP\ARCHIVE\ARC0000000223_0922032286.0001 03-NOV-2016 18:21:04
  427.  
  428. Log File Name First Time
  429. ------------------------------------------------------------------ -----------------------
  430. C:\APP\BACKUP\ARCHIVE\ARC0000000224_0922032286.0001 03-NOV-2016 18:21:10
  431. C:\APP\BACKUP\ARCHIVE\ARC0000000225_0922032286.0001 03-NOV-2016 18:21:22
  432. C:\APP\BACKUP\ARCHIVE\ARC0000000226_0922032286.0001 03-NOV-2016 22:36:54
  433. C:\APP\BACKUP\ARCHIVE\ARC0000000227_0922032286.0001 03-NOV-2016 22:42:57
  434. C:\APP\BACKUP\ARCHIVE\ARC0000000228_0922032286.0001 03-NOV-2016 23:00:51
  435. C:\APP\BACKUP\ARCHIVE\ARC0000000229_0922032286.0001 03-NOV-2016 23:41:58
  436. C:\APP\BACKUP\ARCHIVE\ARC0000000230_0922032286.0001 04-NOV-2016 14:09:59
  437. C:\APP\BACKUP\ARCHIVE\ARC0000000231_0922032286.0001 04-NOV-2016 21:42:25
  438. C:\APP\BACKUP\ARCHIVE\ARC0000000232_0922032286.0001 04-NOV-2016 22:10:12
  439. C:\APP\BACKUP\ARCHIVE\ARC0000000233_0922032286.0001 04-NOV-2016 23:08:40
  440. C:\APP\BACKUP\ARCHIVE\ARC0000000234_0922032286.0001 05-NOV-2016 02:00:46
  441.  
  442. Log File Name First Time
  443. ------------------------------------------------------------------ -----------------------
  444. C:\APP\BACKUP\ARCHIVE\ARC0000000235_0922032286.0001 05-NOV-2016 11:22:27
  445. C:\APP\BACKUP\ARCHIVE\ARC0000000236_0922032286.0001 05-NOV-2016 11:27:36
  446. C:\APP\BACKUP\ARCHIVE\ARC0000000237_0922032286.0001 05-NOV-2016 12:55:34
  447. C:\APP\BACKUP\ARCHIVE\ARC0000000238_0922032286.0001 05-NOV-2016 20:00:23
  448. C:\APP\BACKUP\ARCHIVE\ARC0000000239_0922032286.0001 05-NOV-2016 22:00:30
  449. C:\APP\BACKUP\ARCHIVE\ARC0000000240_0922032286.0001 06-NOV-2016 16:25:41
  450. C:\APP\BACKUP\ARCHIVE\ARC0000000241_0922032286.0001 06-NOV-2016 17:53:00
  451. C:\APP\BACKUP\ARCHIVE\ARC0000000242_0922032286.0001 06-NOV-2016 18:03:44
  452.  
  453. 30 rows selected.
  454.  
  455. SQL> BEGIN
  456. 2 DBMS_LOGMNR.START_LOGMNR (
  457. 3 DictFileName => 'C:\app\backup\logmnr\dictionary.ora'
  458. 4 );
  459. 5 END;
  460. 6 /
  461.  
  462. PL/SQL procedure successfully completed.
  463.  
  464. SQL>
  465. SQL> COLUMN username FORMAT A8
  466. SQL> COLUMN operation FORMAT A9
  467. SQL> COLUMN sql_redo FORMAT A25 WORD_WRAPPED
  468. SQL> COLUMN sql_undo FORMAT A25 WORD_WRAPPED
  469. SQL> COLUMN timestamp FORMAT A20
  470. SQL> Select username, operation, sql_redo, sql_undo from v$logmnr_contents where username =’TEST’;
  471.  
  472. no rows selected
  473.  
  474. SQL> create tablespace rcatbs
  475. 2 datafile 'C:\app\oracle\oradata\orcl\pdbor\rcat01.dbf' size 25M
  476. 3 reuse;
  477. create tablespace rcatbs
  478. *
  479. ERROR at line 1:
  480. ORA-01543: tablespace 'RCATBS' already exists
  481.  
  482.  
  483. SQL> create tablespace rcatbs2
  484. 2 datafile 'C:\app\oracle\oradata\orcl\pdbor\rcat01.dbf' size 25M
  485. 3 reuse;
  486. create tablespace rcatbs2
  487. *
  488. ERROR at line 1:
  489. ORA-01119: error in creating database file 'C:\app\oracle\oradata\orcl\pdbor\rcat01.dbf'
  490. ORA-27040: file create error, unable to create file
  491. OSD-04002: unable to open file
  492. O/S-Error: (OS 3) The system cannot find the path specified.
  493.  
  494.  
  495. SQL> create tablespace rcatbs2
  496. 2 datafile 'C:\app\Oracle12\oradata\orcl\pdborcl\rcat01.dbf' size 25M
  497. 3 reuse;
  498.  
  499. Tablespace created.
  500.  
  501. SQL> CREATE USER rcatowner2 IDENTIFIED BY rcat2
  502. 2 DEFAULT TABLESPACE rcatbs2
  503. 3 QUOTA UNLIMITED ON rcatbs2;
  504. CREATE USER rcatowner2 IDENTIFIED BY rcat2
  505. *
  506. ERROR at line 1:
  507. ORA-65096: invalid common user or role name
  508.  
  509.  
  510. SQL> drop user rcatowner;
  511. drop user rcatowner
  512. *
  513. ERROR at line 1:
  514. ORA-01918: user 'RCATOWNER' does not exist
  515.  
  516.  
  517. SQL> conn sys as sysdba
  518. Enter password:
  519. Connected.
  520. SQL> CREATE USER rcatowner2 IDENTIFIED BY rcat2
  521. 2 DEFAULT TABLESPACE rcatbs2
  522. 3 QUOTA UNLIMITED ON rcatbs2;
  523. CREATE USER rcatowner2 IDENTIFIED BY rcat2
  524. *
  525. ERROR at line 1:
  526. ORA-65096: invalid common user or role name
  527.  
  528.  
  529. SQL> conn sys@pdborcl as sysdba
  530. Enter password:
  531. Connected.
  532. SQL> CREATE USER rcatowner2 IDENTIFIED BY rcat2
  533. 2 DEFAULT TABLESPACE rcatbs2
  534. 3 QUOTA UNLIMITED ON rcatbs2;
  535. CREATE USER rcatowner2 IDENTIFIED BY rcat2
  536. *
  537. ERROR at line 1:
  538. ORA-00959: tablespace 'RCATBS2' does not exist
  539.  
  540.  
  541. SQL> create tablespace rcatbs2
  542. 2 datafile 'C:\app\Oracle12\oradata\orcl\pdborcl\rcat01.dbf' size 25M
  543. 3 reuse;
  544. create tablespace rcatbs2
  545. *
  546. ERROR at line 1:
  547. ORA-01537: cannot add file 'C:\app\Oracle12\oradata\orcl\pdborcl\rcat01.dbf' - file already part of database
  548.  
  549.  
  550. SQL> conn sys as sysdba;
  551. Enter password:
  552. Connected.
  553. SQL> drop rcatbs2;
  554. drop rcatbs2
  555. *
  556. ERROR at line 1:
  557. ORA-00950: invalid DROP option
  558.  
  559.  
  560. SQL> drop tablespace rcatbs2;
  561.  
  562. Tablespace dropped.
  563.  
  564. SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(-
  565. > OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
  566. BEGIN DBMS_LOGMNR.START_LOGMNR( OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); END;
  567.  
  568. *
  569. ERROR at line 1:
  570. ORA-01292: no log file has been specified for the current LogMiner session
  571. ORA-06512: at "SYS.DBMS_LOGMNR", line 58
  572. ORA-06512: at line 1
  573.  
  574.  
  575. SQL> begin
  576. 2 dbms_logmnr.add_logfile( LogFileName =>’C:/app/backup/archive/ARC0000000240_0922032286.0001’,
  577. 3 options => DBMS_LOGMNR.NEW);
  578. 4 end;
  579. 5 /
  580.  
  581. PL/SQL procedure successfully completed.
  582.  
  583. SQL> begin
  584. 2 dbms_logmnr.add_logfile( LogFileName =>
  585. 3 'C:/app/backup/archive/ARC0000000241_0922032286.0001',
  586. 4 options => DBMS_LOGMNR.ADDFILE);
  587. 5 end;
  588. 6 /
  589.  
  590. PL/SQL procedure successfully completed.
  591.  
  592. SQL>
  593. SQL> begin
  594. 2 dbms_logmnr.add_logfile( LogFileName =>
  595. 3 'C:/app/backup/archive/ARC0000000242_0922032286.0001',
  596. 4 options => DBMS_LOGMNR.ADDFILE);
  597. 5 end;
  598. 6 /
  599.  
  600. PL/SQL procedure successfully completed.
  601.  
  602. SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(-
  603. > OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
  604. BEGIN DBMS_LOGMNR.START_LOGMNR( OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); END;
  605.  
  606. *
  607. ERROR at line 1:
  608. ORA-16331: container "SALES" is not open
  609. ORA-06512: at "SYS.DBMS_LOGMNR", line 58
  610. ORA-06512: at line 1
  611.  
  612.  
  613. SQL> alter pluggable database sales open read write;
  614.  
  615. Pluggable database altered.
  616.  
  617. SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(-
  618. > OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
  619.  
  620. PL/SQL procedure successfully completed.
  621.  
  622. SQL> Select username, operation, sql_redo, sql_undo from v$logmnr_contents where username =’TEST’;
  623.  
  624. USERNAME OPERATION SQL_REDO SQL_UNDO
  625. -------- --------- ------------------------- -------------------------
  626. TEST START set transaction read
  627. write;
  628.  
  629. TEST UPDATE update "SYS"."USER$" set update "SYS"."USER$" set
  630. "SPARE6" = "SPARE6" =
  631. TO_DATE('07-NOV-16', TO_DATE('03-NOV-16',
  632. 'DD-MON-RR') where 'DD-MON-RR') where
  633. "USER#" = '130' and "USER#" = '130' and
  634. "SPARE6" = "SPARE6" =
  635. TO_DATE('03-NOV-16', TO_DATE('07-NOV-16',
  636. 'DD-MON-RR') and ROWID = 'DD-MON-RR') and ROWID =
  637.  
  638. USERNAME OPERATION SQL_REDO SQL_UNDO
  639. -------- --------- ------------------------- -------------------------
  640. 'AAAAAKAABAAAADXAAO'; 'AAAAAKAABAAAADXAAO';
  641.  
  642. TEST COMMIT commit;
  643.  
  644. SQL>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!