Oracle 11G OCP 1Z0-053 572
(572)What is the proper procedure to recover a lost tempfile?
A. Restore the backup copy of the tempfile from the backup media.
B. Re-create the tempfile with the create tempfile command.
C. Copy an existing tempfile from another database.
D. Re-create the tempfile with the create tablespace command.
E. Re-create the tempfile with the alter tablespace command.
答案:(E)
解析:
臨時資料檔案丟失,並不會影響到資料庫的正常執行。
可以使用alter tablespace temp add tempfile'/u01/app/oracle/oradata/test0924/temp01.dbf'size 10m
這樣的語句來重新建立臨時資料檔案。
在我的11.2.0.3環境裡,我刪除/u01/app/oracle/oradata/test0924/temp01.dbf,之後重新啟動資料庫,資料庫又自動恢復了temp01.dbf。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1319568/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11G OCP 1Z0-053 600Oracle
- Oracle 11G OCP 1Z0-053 581Oracle
- Oracle 11G OCP 1Z0-053 582Oracle
- Oracle 11G OCP 1Z0-053 583Oracle
- Oracle 11G OCP 1Z0-053 584Oracle
- Oracle 11G OCP 1Z0-053 585Oracle
- Oracle 11G OCP 1Z0-053 586Oracle
- Oracle 11G OCP 1Z0-053 587Oracle
- Oracle 11G OCP 1Z0-053 588Oracle
- Oracle 11G OCP 1Z0-053 589Oracle
- Oracle 11G OCP 1Z0-053 590Oracle
- Oracle 11G OCP 1Z0-053 591Oracle
- Oracle 11G OCP 1Z0-053 592Oracle
- Oracle 11G OCP 1Z0-053 593Oracle
- Oracle 11G OCP 1Z0-053 594Oracle
- Oracle 11G OCP 1Z0-053 595Oracle
- Oracle 11G OCP 1Z0-053 596Oracle
- Oracle 11G OCP 1Z0-053 597Oracle
- Oracle 11G OCP 1Z0-053 598Oracle
- Oracle 11G OCP 1Z0-053 563Oracle
- Oracle 11G OCP 1Z0-053 564Oracle
- Oracle 11G OCP 1Z0-053 565Oracle
- Oracle 11G OCP 1Z0-053 566Oracle
- Oracle 11G OCP 1Z0-053 567Oracle
- Oracle 11G OCP 1Z0-053 568Oracle
- Oracle 11G OCP 1Z0-053 569Oracle
- Oracle 11G OCP 1Z0-053 570Oracle
- Oracle 11G OCP 1Z0-053 571Oracle
- Oracle 11G OCP 1Z0-053 573Oracle
- Oracle 11G OCP 1Z0-053 574Oracle
- Oracle 11G OCP 1Z0-053 575Oracle
- Oracle 11G OCP 1Z0-053 576Oracle
- Oracle 11G OCP 1Z0-053 578Oracle
- Oracle 11G OCP 1Z0-053 579Oracle
- Oracle 11G OCP 1Z0-053 580Oracle
- Oracle 11G OCP 1Z0-053 545Oracle
- Oracle 11G OCP 1Z0-053 546Oracle
- Oracle 11G OCP 1Z0-053 547Oracle