-
rman status
Hi,
The below Query doesnt show the % completed status.It always shows 0.But the time now keeps changing..and the backup finishes in the nor mal speed as it has to do.
select sid, serial#, context, round(sofar/totalwork*100,2) "% Complete", substr(to_char(sysdate,'ddmmyy hh24:mi:ss'),1,15) "Time Now", elapsed_seconds from v$session_longops where substr(opname,1,4)='RMAN'
Oracle version 8.1.7.0.0 on AIX 4.3.2
Did anyone faced like this.
Regards,
Vinod
-
Do you have timed_statistics on?
Jeff Hunter
-
No..timed_statistics=false
Regards,
Vinod
-
Originally posted by vinodkmg
No..timed_statistics=false
Regards,
Vinod
Set it to TRUE and try again.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|