alter database backup controlfile to trace
执行后察看trace文件,为什么没有controlfile的做成sql呢
trace文件生成的内容如下TKPROF: Release 8.1.7.0.0 - Production on 金 Aug 14 10:46:53 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.Trace file: c:\ORA03868.TRC
Sort options: default********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: c:\ORA03868.TRC
Trace file compatibility: 8.00.04
Sort options: default 1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
55 lines in trace file.
执行后察看trace文件,为什么没有controlfile的做成sql呢
trace文件生成的内容如下TKPROF: Release 8.1.7.0.0 - Production on 金 Aug 14 10:46:53 2009(c) Copyright 2000 Oracle Corporation. All rights reserved.Trace file: c:\ORA03868.TRC
Sort options: default********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: c:\ORA03868.TRC
Trace file compatibility: 8.00.04
Sort options: default 1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
55 lines in trace file.
是意思,那个指令会生成2个trace文件么?
我是看的udump下面的那个
那你试试这个语句好了,直接把备份写到确定的文件上:alter database backup controlfile to trace as 'd:\control_bak.txt';
报ora-00933 sql未正确结束的错误