开启辅助访问

Bo's Oracle Station

Bo's Oracle Station»社区 › 培训进行时（结课后图标变灰，但是欢迎继续发帖！） › 4072-12c管理类OCP认证班第二期 › 课程第30次（2017-05-16星期二）
返回列表 发新帖
查看: 1851|回复: 0

课程第30次（2017-05-16星期二）

[复制链接]
botang

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2017-5-17 09:41:51 | 显示全部楼层 |阅读模式
上完1Z0-053第5/6章
预习备份恢复视频
1Z0-052共19章（上完12章），1Z0-053共21章（上完10章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的22章
  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

  7. SQL*Plus: Release 11.2.0.1.0 Production on Sun May 20 19:42:50 2018

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

  11. SQL> conn / as sysdba
  12. Connected.
  13. SQL> show parameter db_name

  15. NAME                                     TYPE         VALUE
  16. ------------------------------------ ----------- ------------------------------
  17. db_name                              string         rcat
  18. SQL> select open_mode from v$database;

  20. OPEN_MODE
  21. --------------------
  22. READ WRITE

  24. SQL> exit
  25. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  26. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  27. [oracle@station90 ~]$ cd  /u01/app/oracle/oradata/
  28. [oracle@station90 oradata]$ ls
  29. rcat
  30. [oracle@station90 oradata]$ cd rcat/
  31. [oracle@station90 rcat]$ ls
  32. control01.ctl  rcat01.dbf  redo02.log  sysaux01.dbf  temp01.dbf     users01.dbf
  33. example01.dbf  redo01.log  redo03.log  system01.dbf  undotbs01.dbf
  34. [oracle@station90 rcat]$ rm -i temp01.dbf
  35. rm：是否删除普通文件 "temp01.dbf"？y
  36. [oracle@station90 rcat]$ ls -l /u01/app/oracle/oradata/rcat/temp01.dbf
  37. ls: 无法访问/u01/app/oracle/oradata/rcat/temp01.dbf: 没有那个文件或目录
  38. [oracle@station90 rcat]$ sqlplus /nolog

  40. SQL*Plus: Release 11.2.0.1.0 Production on Sun May 20 19:44:18 2018

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

  44. SQL> conn hr/oracle_4U
  45. ERROR:
  46. ORA-28000: the account is locked


  49. SQL> conn hr/oracle_4U
  50. Connected.
  51. SQL> select  * from employees a , employees b , employees c , employees d order 1 ,2,3,4,5;
  52. select        * from employees a , employees b , employees c , employees d order 1 ,2,3,4,5
  53.                                                                            *
  54. ERROR at line 1:
  55. ORA-00924: missing BY keyword


  58. SQL> select  * from employees a , employees b , employees c , employees d order by 1 ,2,3,4,5;
  59. select        * from employees a , employees b , employees c , employees d order by 1 ,2,3,4,5
  60.                *
  61. ERROR at line 1:
  62. ORA-01116: error in opening database file 201
  63. ORA-01110: data file 201: '/u01/app/oracle/oradata/rcat/temp01.dbf'
  64. ORA-27041: unable to open file
  65. Linux-x86_64 Error: 2: No such file or directory
  66. Additional information: 3


  69. SQL> /
  70. select        * from employees a , employees b , employees c , employees d order by 1 ,2,3,4,5
  71.                *
  72. ERROR at line 1:
  73. ORA-01013: user requested cancel of current operation



  77. SQL> conn / as sysdba

  79. SQL> conn / as sysdba
  80. Connected.
  81. SQL> archive log list;
  82. Database log mode               No Archive Mode
  83. Automatic archival               Disabled
  84. Archive destination               USE_DB_RECOVERY_FILE_DEST
  85. Oldest online log sequence     6
  86. Current log sequence               8
  87. SQL> shutdown immediate
  88. Database closed.
  89. Database dismounted.
  90. ORACLE instance shut down.
  91. SQL> startup mount
  92. ORACLE instance started.

  94. Total System Global Area 1603411968 bytes
  95. Fixed Size                    2213776 bytes
  96. Variable Size                  436209776 bytes
  97. Database Buffers         1157627904 bytes
  98. Redo Buffers                    7360512 bytes
  99. Database mounted.
  100. SQL> alter database archivelog ;

  102. Database altered.

  104. SQL> alter database open ;

  106. Database altered.

  108. SQL> begin
  109.   2    for i in 1..10000
  110.   3    loop
  111.   4      update employees set salary=salary+1 where employee_id=100;
  112.   5    end loop;
  113.   6    commit;
  114.   7  end;
  115.   8  /
  116.     update employees set salary=salary+1 where employee_id=100;
  117.            *
  118. ERROR at line 4:
  119. ORA-06550: line 4, column 12:
  120. PL/SQL: ORA-00942: table or view does not exist
  121. ORA-06550: line 4, column 5:
  122. PL/SQL: SQL Statement ignored


  125. SQL> conn hr/oracle_4U
  126. Connected.
  127. SQL> begin
  128.   2   for i in 1..100000
  129.   3   loop
  130.   4    update employees set salary=salary+1 where employee_id=100;
  131.   5   end loop;
  132.   6  commit;
  133.   7  end;
  134.   8  /

  136. PL/SQL procedure successfully completed.

  138. SQL> exit
  139. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  140. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  141. [oracle@station90 rcat]$ rman target  /

  143. Recovery Manager: Release 11.2.0.1.0 - Production on Sun May 20 20:15:12 2018

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

  147. connected to target database: RCAT (DBID=590260915)

  149. RMAN> show all;

  151. using target database control file instead of recovery catalog
  152. RMAN configuration parameters for database with db_unique_name RCAT are:
  153. CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
  154. CONFIGURE BACKUP OPTIMIZATION OFF; # default
  155. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
  156. CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
  157. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
  158. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
  159. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  160. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
  161. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
  162. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
  163. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
  164. CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
  165. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
  166. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_rcat.f'; # default

  168. RMAN> backup  incremental level 0 database ;

  170. Starting backup at 20-MAY-18
  171. allocated channel: ORA_DISK_1
  172. channel ORA_DISK_1: SID=11 device type=DISK
  173. channel ORA_DISK_1: starting incremental level 0 datafile backup set
  174. channel ORA_DISK_1: specifying datafile(s) in backup set
  175. input datafile file number=00001 name=/u01/app/oracle/oradata/rcat/system01.dbf
  176. input datafile file number=00002 name=/u01/app/oracle/oradata/rcat/sysaux01.dbf
  177. input datafile file number=00005 name=/u01/app/oracle/oradata/rcat/example01.dbf
  178. input datafile file number=00006 name=/u01/app/oracle/oradata/rcat/rcat01.dbf
  179. input datafile file number=00003 name=/u01/app/oracle/oradata/rcat/undotbs01.dbf
  180. input datafile file number=00004 name=/u01/app/oracle/oradata/rcat/users01.dbf
  181. channel ORA_DISK_1: starting piece 1 at 20-MAY-18
  182. channel ORA_DISK_1: finished piece 1 at 20-MAY-18
  183. piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd0_TAG20180520T201530_fj2sq2m7_.bkp tag=TAG20180520T201530 comment=NONE
  184. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
  185. channel ORA_DISK_1: starting incremental level 0 datafile backup set
  186. channel ORA_DISK_1: specifying datafile(s) in backup set
  187. including current control file in backup set
  188. including current SPFILE in backup set
  189. channel ORA_DISK_1: starting piece 1 at 20-MAY-18
  190. channel ORA_DISK_1: finished piece 1 at 20-MAY-18
  191. piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_ncsn0_TAG20180520T201530_fj2sqblt_.bkp tag=TAG20180520T201530 comment=NONE
  192. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  193. Finished backup at 20-MAY-18

  195. RMAN> backup  incremental level 1 database ;

  197. Starting backup at 20-MAY-18
  198. using channel ORA_DISK_1
  199. channel ORA_DISK_1: starting incremental level 1 datafile backup set
  200. channel ORA_DISK_1: specifying datafile(s) in backup set
  201. input datafile file number=00001 name=/u01/app/oracle/oradata/rcat/system01.dbf
  202. input datafile file number=00002 name=/u01/app/oracle/oradata/rcat/sysaux01.dbf
  203. input datafile file number=00005 name=/u01/app/oracle/oradata/rcat/example01.dbf
  204. input datafile file number=00006 name=/u01/app/oracle/oradata/rcat/rcat01.dbf
  205. input datafile file number=00003 name=/u01/app/oracle/oradata/rcat/undotbs01.dbf
  206. input datafile file number=00004 name=/u01/app/oracle/oradata/rcat/users01.dbf
  207. channel ORA_DISK_1: starting piece 1 at 20-MAY-18
  208. channel ORA_DISK_1: finished piece 1 at 20-MAY-18
  209. piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd1_TAG20180520T201545_fj2sqkt1_.bkp tag=TAG20180520T201545 comment=NONE
  210. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
  211. channel ORA_DISK_1: starting incremental level 1 datafile backup set
  212. channel ORA_DISK_1: specifying datafile(s) in backup set
  213. including current control file in backup set
  214. including current SPFILE in backup set
  215. channel ORA_DISK_1: starting piece 1 at 20-MAY-18
  216. channel ORA_DISK_1: finished piece 1 at 20-MAY-18
  217. piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_ncsn1_TAG20180520T201545_fj2sqown_.bkp tag=TAG20180520T201545 comment=NONE
  218. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  219. Finished backup at 20-MAY-18

  221. RMAN> list backup of database;


  224. List of Backup Sets
  225. ===================


  228. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  229. ------- ---- -- ---------- ----------- ------------ ---------------
  230. 1       Incr 0  1.05G      DISK        00:00:07     20-MAY-18      
  231.         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20180520T201530
  232.         Piece Name: /u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd0_TAG20180520T201530_fj2sq2m7_.bkp
  233.   List of Datafiles in backup set 1
  234.   File LV Type Ckp SCN    Ckp Time  Name
  235.   ---- -- ---- ---------- --------- ----
  236.   1    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/system01.dbf
  237.   2    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/sysaux01.dbf
  238.   3    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/undotbs01.dbf
  239.   4    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/users01.dbf
  240.   5    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/example01.dbf
  241.   6    0  Incr 1080567    20-MAY-18 /u01/app/oracle/oradata/rcat/rcat01.dbf

  243. BS Key  Type LV Size       Device Type Elapsed Time Completion Time
  244. ------- ---- -- ---------- ----------- ------------ ---------------
  245. 3       Incr 1  72.00K     DISK        00:00:01     20-MAY-18      
  246.         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20180520T201545
  247.         Piece Name: /u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd1_TAG20180520T201545_fj2sqkt1_.bkp
  248.   List of Datafiles in backup set 3
  249.   File LV Type Ckp SCN    Ckp Time  Name
  250.   ---- -- ---- ---------- --------- ----
  251.   1    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/system01.dbf
  252.   2    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/sysaux01.dbf
  253.   3    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/undotbs01.dbf
  254.   4    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/users01.dbf
  255.   5    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/example01.dbf
  256.   6    1  Incr 1080587    20-MAY-18 /u01/app/oracle/oradata/rcat/rcat01.dbf

  258. RMAN> exit


  261. Recovery Manager complete.
  262. [oracle@station90 rcat]$ sqlplus /nolog

  264. SQL*Plus: Release 11.2.0.1.0 Production on Sun May 20 20:16:43 2018

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

  268. SQL> conn hr/oracle_4U
  269. Connected.
  270. SQL> begin
  271.   2     for i in 1..100000
  272.   3     loop
  273.   4       update employees set salary=salary+1 where employee_id=101;
  274.   5     end loop;
  275.   6    commit;
  276.   7  end;
  277.   8  /

  279. PL/SQL procedure successfully completed.

  281. SQL> conn / as sysdba
  282. Connected.
  283. SQL> shutdown immediate
  284. Database closed.
  285. Database dismounted.
  286. ORACLE instance shut down.
  287. SQL> startup
  288. ORACLE instance started.

  290. Total System Global Area 1603411968 bytes
  291. Fixed Size                    2213776 bytes
  292. Variable Size                  436209776 bytes
  293. Database Buffers         1157627904 bytes
  294. Redo Buffers                    7360512 bytes
  295. Database mounted.
  296. ORA-03113: end-of-file on communication channel
  297. Process ID: 2753
  298. Session ID: 919 Serial number: 5


  301. SQL> conn / as sysdba
  302. Connected to an idle instance.
  303. SQL> startup mount
  304. ORACLE instance started.

  306. Total System Global Area 1603411968 bytes
  307. Fixed Size                    2213776 bytes
  308. Variable Size                  436209776 bytes
  309. Database Buffers         1157627904 bytes
  310. Redo Buffers                    7360512 bytes
  311. Database mounted.
  312. SQL> alter database open ;
  313. alter database open
  314. *
  315. ERROR at line 1:
  316. ORA-03113: end-of-file on communication channel
  317. Process ID: 2815
  318. Session ID: 919 Serial number: 5


  321. SQL> conn / as sysdba
  322. Connected to an idle instance.
  323. SQL> startup mount
  324. ORACLE instance started.

  326. Total System Global Area 1603411968 bytes
  327. Fixed Size                    2213776 bytes
  328. Variable Size                  436209776 bytes
  329. Database Buffers         1157627904 bytes
  330. Redo Buffers                    7360512 bytes
  331. Database mounted.
  332. SQL> exit
  333. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
  334. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  335. [oracle@station90 rcat]$ rman target /

  337. Recovery Manager: Release 11.2.0.1.0 - Production on Sun May 20 20:19:27 2018

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

  341. connected to target database: RCAT (DBID=590260915, not open)

  343. RMAN> restore database ;

  345. Starting restore at 20-MAY-18
  346. using target database control file instead of recovery catalog
  347. allocated channel: ORA_DISK_1
  348. channel ORA_DISK_1: SID=310 device type=DISK

  350. channel ORA_DISK_1: starting datafile backup set restore
  351. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  352. channel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/rcat/system01.dbf
  353. channel ORA_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/rcat/sysaux01.dbf
  354. channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/rcat/undotbs01.dbf
  355. channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/rcat/users01.dbf
  356. channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/rcat/example01.dbf
  357. channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/rcat/rcat01.dbf
  358. channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd0_TAG20180520T201530_fj2sq2m7_.bkp
  359. channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd0_TAG20180520T201530_fj2sq2m7_.bkp tag=TAG20180520T201530
  360. channel ORA_DISK_1: restored backup piece 1
  361. channel ORA_DISK_1: restore complete, elapsed time: 00:00:08
  362. Finished restore at 20-MAY-18

  364. RMAN> recover database;

  366. Starting recover at 20-MAY-18
  367. using channel ORA_DISK_1
  368. channel ORA_DISK_1: starting incremental datafile backup set restore
  369. channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  370. destination for restore of datafile 00001: /u01/app/oracle/oradata/rcat/system01.dbf
  371. destination for restore of datafile 00002: /u01/app/oracle/oradata/rcat/sysaux01.dbf
  372. destination for restore of datafile 00003: /u01/app/oracle/oradata/rcat/undotbs01.dbf
  373. destination for restore of datafile 00004: /u01/app/oracle/oradata/rcat/users01.dbf
  374. destination for restore of datafile 00005: /u01/app/oracle/oradata/rcat/example01.dbf
  375. destination for restore of datafile 00006: /u01/app/oracle/oradata/rcat/rcat01.dbf
  376. channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd1_TAG20180520T201545_fj2sqkt1_.bkp
  377. channel ORA_DISK_1: piece handle=/u01/app/oracle/flash_recovery_area/RCAT/backupset/2018_05_20/o1_mf_nnnd1_TAG20180520T201545_fj2sqkt1_.bkp tag=TAG20180520T201545
  378. channel ORA_DISK_1: restored backup piece 1
  379. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

  381. starting media recovery
  382. media recovery failed
  383. RMAN-00571: ===========================================================
  384. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  385. RMAN-00571: ===========================================================
  386. RMAN-03002: failure of recover command at 05/20/2018 20:20:25
  387. ORA-00283: recovery session canceled due to errors
  388. RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
  389. start
  390. ORA-00283: recovery session canceled due to errors
  391. ORA-00313: open failed for members of log group 3 of thread 1
  392. ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/rcat/redo03.log'
  393. ORA-27037: unable to obtain file status
  394. Linux-x86_64 Error: 2: No such file or directory
  395. Additional information: 3

  397. RMAN> exit


  400. Recovery Manager complete.
  401. [oracle@station90 rcat]$ sqlplus /nolog

  403. SQL*Plus: Release 11.2.0.1.0 Production on Sun May 20 20:21:01 2018

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

  407. SQL> conn / as sysdba
  408. Connected.
  409. SQL> recover database until cancel;
  410. ORA-00279: change 1080587 generated at 05/20/2018 20:15:45 needed for thread 1
  411. ORA-00289: suggestion :
  412. /u01/app/oracle/flash_recovery_area/RCAT/archivelog/2018_05_20/o1_mf_1_9_%u_.arc
  413. ORA-00280: change 1080587 for thread 1 is in sequence #9


  416. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

  418. ORA-00308: cannot open archived log
  419. '/u01/app/oracle/flash_recovery_area/RCAT/archivelog/2018_05_20/o1_mf_1_9_%u_.ar
  420. c'
  421. ORA-27037: unable to obtain file status
  422. Linux-x86_64 Error: 2: No such file or directory
  423. Additional information: 3


  426. SQL> recover database until cancel;
  427. ORA-00279: change 1080587 generated at 05/20/2018 20:15:45 needed for thread 1
  428. ORA-00289: suggestion :
  429. /u01/app/oracle/flash_recovery_area/RCAT/archivelog/2018_05_20/o1_mf_1_9_%u_.arc
  430. ORA-00280: change 1080587 for thread 1 is in sequence #9


  433. Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
  434. cancel
  435. Media recovery cancelled.
  436. SQL> alter database open ;
  437. alter database open
  438. *
  439. ERROR at line 1:
  440. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


  443. SQL> alter database open resetlogs;

  445. Database altered.

  447. SQL> alter system switch logfile;

  449. System altered.

  451. SQL> /

  453. System altered.

  455. SQL> alter system checkpoint;

  457. System altered.

  459. SQL> alter database clear logfile group 1;

  461. Database altered.

  463. SQL>
  464. SQL>
复制代码
  1. select  * from dba_temp_files;

  3. alter tablespace temp add tempfile '/u01/app/oracle/oradata/rcat/temp02.dbf'
  4. size 30M  autoextend on;

  6. alter tablespace temp  drop tempfile '/u01/app/oracle/oradata/rcat/temp01.dbf';

  8. alter user hr identified by oracle_4U account unlock;

  10. ----

  12. select  * from v$log;

  14. select  * from v$logfile;
  15. -----
  16. alter system checkpoint;

  18. alter database clear logfile group 2;

  20. -------------------
复制代码



回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-11-22 11:20 , Processed in 0.036368 second(s), 24 queries .

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