| recovery manager problem(urgent please) [message #71460] |
Wed, 06 November 2002 01:53  |
kayode
Messages: 2
Registered: November 2002
|
Junior Member |
|
|
Hi,
can somebody plase help me on this problem. I took full
backup with recovery manager on my test database then, I deleted one of system datafile. when I decided to use my backup the following error was display.
Recovery Manager: Release 8.1.6.0.0 - Production
RMAN-06005: connected to target database: ORCL (DBID=1003297079)
RMAN-06008: connected to recovery catalog database
RMAN> report need backup days 1 database;
RMAN-03022: compiling command: report
Report of files whose recovery needs more than 1 days of archived logs
File Days Name
---- ----- -----------------------------------------------------
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: report
RMAN-06004: ORACLE error from recovery catalog database: ORA-06502: PL/SQL: numeric or value error: number precision too large
ORA-06512: at "RMAN.DBMS_RCVMAN", line 3148
ORA-06512: at "RMAN.DBMS_RCVMAN", line 3720
ORA-06512: at "RMAN.DBMS_RCVMAN", line 7834
ORA-06512: at line 1
RMAN-06097: text of failing SQL statement: declare allCopies boolean ; begin if ( :maxact > 0 ) then allCopies := TRUE ; else allCopies := FALSE ; end if ; :rc := dbms_rcvman . computeRecoveryActions ( fno => :fno , crescn => :crescn , df_rlgscn => :rlgscn:rlgscn_i , df_rlgtime => :rlgtime:rlgtime_i , df_ckpscn => :ckpscn:ckpscn_i , offlscn => :offlscn , onlscn => :onlscn , onltime => :onltime , cleanscn => :cleanscn , clean2scn => :clean2scn , clean2time => :clean2time , allowfuzzy => FALSE , partial_rcv => FALSE , cf_scn => :cfscn:cfscn_i , cf_cret
RMAN-06099: error occurred in source file: krmk.pc, line: 21705
RMAN> exit
Recovery Manager complete.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
