RMAN Error
Hi List,
I am getting the following RMAN error. Any help would be really appreciated.
RMAN script:-
==
RMAN replace script ts_system_backup
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql 'alter system switch logfile';
resync catalog;
backup tablespace system format='al_%d%t%p';
}
OUTPUT
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=7 set_stamp=508754890 creation_time=30-OCT-03
RMAN-08010: channel c1: specifying datafile(s) in backupset
RMAN-08522: input datafile fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf
RMAN-08011: including current controlfile in backupset
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-08031: released channel: c2
RMAN-08031: released channel: c3
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===
RMAN-00571: ===
RMAN-03015: error occurred in stored script ts_system_backup
RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel c1
RMAN-10035: exception raised in RPC: ORA-19502: write error on file
al_HSBC5087548901, blockno 2040833 (blocksize=512)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 52736
Additional information: 131072
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN
Recovery Manager complete.
Thanks
-tamizh
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RMAN Error
Tamizh,
You are probably running out of space in the file-system you
were located within when you invoked RMAN. It would be
better to specify a full path-name in the FORMAT= clause
(i.e. specify directory as well as filename), to make sure
that the file-system where you are creating the backupsets
is the one you intend.
Hope this helps...
-Tim
Hi List,
I am getting the following RMAN error. Any help would be
really appreciated.
RMAN script:-
==
RMAN replace script ts_system_backup
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
sql 'alter system switch logfile';
resync catalog;
backup tablespace system format='al_%d%t%p';
}
OUTPUT
RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel c1: starting full datafile backupset
RMAN-08502: set_count=7 set_stamp=508754890
creation_time=30-OCT-03 RMAN-08010: channel c1: specifying
datafile(s) in backupset RMAN-08522: input datafile
fno=1 name=/dev/vx/rdsk/dbdg10/System.dbf RMAN-08011:
including current controlfile in backupset RMAN-03026:
error recovery releasing channel resources RMAN-08031:
released channel: c1 RMAN-08031: released channel: c2
RMAN-08031: released channel: c3
RMAN-00571:
==
= RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
=== RMAN-00571:
==
= RMAN-03015: error occurred in stored script
ts_system_backup RMAN-03007: retryable error occurred
during execution of command: backup RMAN-07004: unhandled
exception during command execution on channel c1
RMAN-10035: exception raised in RPC: ORA-19502: write
error on file al_HSBC5087548901, blockno 2040833
(blocksize=512) ORA-27063: skgfospo: number of bytes
read/written is incorrect Additional information: 52736
Additional information: 131072
RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
RMAN
Recovery Manager complete.
Thanks
-tamizh
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.net --
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
http://www.fatcity.com San Diego, California--
Mailing list and web hosting services
--
--- To REMOVE yourself from this mailing list,
send an E-Mail message to: [EMAIL PROTECTED] (note
EXACT spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (or the name of
mailing list you want to be removed from). You may also
send the HELP command for other information (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RMAN error while registering the target database
Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN error while registering the target database
/dev/vx/rdsk/dbdg13/Rcatctrl.ctl Does this directory exist, does Oracle have priv's on it? Does the file already exist, and of so who owns it and what are the privs? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/25/2003 12:39 PM Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN error while registering the target database
Hi Robert, The directory does not exist. I am just trying to register the database(RMANregister database). My question is... from where did it pick up the name of the control file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl. Also i tried the same operation(register database) for different database which is running on the same box and it works fine. Thanks Sami --- Freeman Robert - IL [EMAIL PROTECTED] wrote: /dev/vx/rdsk/dbdg13/Rcatctrl.ctl Does this directory exist, does Oracle have priv's on it? Does the file already exist, and of so who owns it and what are the privs? RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/25/2003 12:39 PM Hi List, Does anyone come across this issue? What should i do to resolve this? Any help would be really appreciated. TIA RMAN register database; RMAN-03022: compiling command: register RMAN-03023: executing command: register RMAN-08006: database registered in recovery catalog RMAN-03023: executing command: full resync RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01580: error creating control backup file /dev/vx/rdsk/dbdg13/Rcatctrl.ctl ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory RMAN-10031: ORA-1580 occurred during call to DBMS_BACKUP_RESTORE.CFILEMAKEANDUSESNAPSHOT __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN error - can someone help ?
It looks like you don't have your ORACLE_SID specified correctly since, if I
read this correctly, the database you are trying to restore is on dick c:.
Set you ORACLE_SID which will be the target and try again.
HTH,
Ruth
p.s I do not have any databases on Windows so I am not sure how to set the
SID.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Prem Khanna J
Sent: Tuesday, September 16, 2003 10:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RMAN error - can someone help ?
Hi,
My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
My target destination for backup files is R:\ which resides
on Host C (WinNT).This drive R:\ is common to both Host A and B.
Things work fine accessing R:\ from both Host A and B.
I tried a TSPITR following the doc. 180436.1. It is for 8i.
Question #1: is it applicable for 9i also ?
If YES,
when i say (on Host A,the target),
run {
ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
ALLOCATE CHANNEL c1 TYPE DISK;
recover tablespace users until time TO_DATE('MAR-05-2002
11:27:00', 'MON-DD- HH:MI:SS');
}
i get the error below:
channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
released channel: a1
released channel: c1
RMAN-00571: ==
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: ==
RMAN-03002: failure of recover command at 09/16/2003 17:48:32
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) Path not found.
Question #2:
db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92);
log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata
\aux92);
why does RMAN try to restore SYSTEM01.DBF to
D:\ORACLE\ORA92\DATABASE\ ?
i have not mentioned this path anywhere in my recovery action.
Question #3:
though it is not restore path,why does RMAN's Memory script
append ;\ in the path
i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
this is where it fails.
can someone explain me where the problem is ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ruth Gramolini
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RE: RMAN error - can someone help ?
Ruth,
Set you ORACLE_SID which will be the target and try again.
c: set ORACLE_SID=AUX92
AUX92 is the name of my auxiliary instance on Host A ( target host ).
c: rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys
trace=c:\tspitr.log
where PE92 is the target on same Host A and LAT92 is my recovery catalog on a
diff. host.
This is what metalink doc. 180436.1 says:
rman target sys/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED] auxiliary /
trace=d:\tspitr.log
It looks like you don't have your ORACLE_SID specified correctly since, if I
read this correctly, the database you are trying to restore is on dick c:.
my target database is in d:\oracle\
but even then where did this path come from ??
ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
those ;\ in the path look strange and wonder oracle appends that ??
any clues Ruth.just stuck up here and not able to proceed further.
i tried it repeatedly.
Thanx once again.
Jp.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Prem Khanna J
Sent: Tuesday, September 16, 2003 10:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RMAN error - can someone help ?
Hi,
My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
My target destination for backup files is R:\ which resides
on Host C (WinNT).This drive R:\ is common to both Host A and B.
Things work fine accessing R:\ from both Host A and B.
I tried a TSPITR following the doc. 180436.1. It is for 8i.
Question #1: is it applicable for 9i also ?
If YES,
when i say (on Host A,the target),
run {
ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
ALLOCATE CHANNEL c1 TYPE DISK;
recover tablespace users until time TO_DATE('MAR-05-2002
11:27:00', 'MON-DD- HH:MI:SS');
}
i get the error below:
channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
released channel: a1
released channel: c1
RMAN-00571: ==
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: ==
RMAN-03002: failure of recover command at 09/16/2003 17:48:32
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) Path not found.
Question #2:
db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92);
log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata
\aux92);
why does RMAN try to restore SYSTEM01.DBF to
D:\ORACLE\ORA92\DATABASE\ ?
i have not mentioned this path anywhere in my recovery action.
Question #3:
though it is not restore path,why does RMAN's Memory script
append ;\ in the path
i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
this is where it fails.
can someone explain me where the problem is ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RMAN error - can someone help ?
Hi,
My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
My target destination for backup files is R:\ which resides
on Host C (WinNT).This drive R:\ is common to both Host A and B.
Things work fine accessing R:\ from both Host A and B.
I tried a TSPITR following the doc. 180436.1. It is for 8i.
Question #1: is it applicable for 9i also ?
If YES,
when i say (on Host A,the target),
run {
ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
ALLOCATE CHANNEL c1 TYPE DISK;
recover tablespace users until time TO_DATE('MAR-05-2002 11:27:00', 'MON-DD-
HH:MI:SS');
}
i get the error below:
channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 1 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
released channel: a1
released channel: c1
RMAN-00571: ==
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS =
RMAN-00571: ==
RMAN-03002: failure of recover command at 09/16/2003 17:48:32
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) Path not found.
Question #2:
db_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92);
log_file_name_convert=(d:\oracle\oradata\pe92,d:\oracle\oradata\aux92);
why does RMAN try to restore SYSTEM01.DBF to
D:\ORACLE\ORA92\DATABASE\ ?
i have not mentioned this path anywhere in my recovery action.
Question #3:
though it is not restore path,why does RMAN's Memory script append ;\ in the path
i.e.,D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
this is where it fails.
can someone explain me where the problem is ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RMAN error registering database
Danny, Many RMAN errors will show a hit when searching Metalink. I found the following related document on Metalink when I searched with the RMAN-10031 error: fact: Oracle Enterprise Edtion 8.1.7 fact: Recovery Manager (RMAN) symptom: Unable to register a database symptom: RMAN-10035: exception raised in RPC: ORA-01403: no data found symptom: RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT. CHECKBACKUPPIECE symptom: RMAN-03008: error while performing automatic resync of recovery catalog change: Upgrade to Oracle Server - Enterprise Edition 8.1.7 cause: Bug:1467871 Dummy records with status ¿D¿ inserted into BS table during backup. RMAN mishandles these records during sync of the recovery of the catalog. fix: Upgrade to Oracle Server 9i Or use following workaround: Rebuild the target database control file References: Note:1012929.6 How to Recreate the Controlfile . Hope this helped. Cherie Danny Hughes DHUGHES@knobi To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] as.com cc: Sent by: Subject: RMAN error registering database [EMAIL PROTECTED] om 05/30/02 06:43 PM Please respond to ORACLE-L when I try to register my database in RMAN, I get the following error.. RMAN-08002: starting full resync of recovery catalog RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01403: no data found RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECE does anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution. TIA Danny Hughes DBA Knobias.com 601-978-3399 x103 [EMAIL PROTECTED] www.knobias.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danny Hughes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN error registering database
Without having better information (i.e. I assume you are running Oracle between 8.1.6and 8.1.7.2), I would say that you are running into bug 1467871 fixed in 9i and patched in 8.1.7.3 and 4. The work around is to recreate your control file, thus loosing all your backup information stored in the control file. You can capture this information manually via a controlfile dump, but it isn't of much use to you (and besides that it can reoccur if you don't apply the patch). Not necessarily a horrid problem, but certainly good to move past. You should upgrade to 8.1.7.3 (or 9i) and then upgrade your catalog in order to avoid this problem in the future. You need to upgrade your catalog after applying the patchset: RMAN CONNECT CATALOG user/passwd@catalogRMAN UPGRADE CATALOG; Regards, Michael SaleAuthor: Oracle9i for Windows(R) 2000 Tips Techniques when I try to register my database in RMAN, I get the following error..RMAN-08002: starting full resync of recovery catalogRMAN-03026: error recovery releasing channel resourcesRMAN-00571: ===RMAN-00569: === ERROR MESSAGE STACK FOLLOWS ===RMAN-00571: ===RMAN-03008: error while performing automatic resync of recovery catalogRMAN-07004: unhandled exception during command execution on channel defaultRMAN-10035: exception raised in RPC: ORA-01403: no data foundRMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECEdoes anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution.TIADanny HughesDBAKnobias.com601-978-3399 x103[EMAIL PROTECTED]www.knobias.com--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Danny HughesINET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: RMAN error registering database - solved
Thanks Cherie I saw that one too...I was hoping that there was another fix rather than having to shut our production database down, but after many hours on the phone with oracle and getting nowhere, I just recrreated the control file and it did solve my problem. [EMAIL PROTECTED] 05/31/02 07:48AM Danny, Many RMAN errors will show a hit when searching Metalink. I found the following related document on Metalink when I searched with the RMAN-10031 error: fact: Oracle Enterprise Edtion 8.1.7 fact: Recovery Manager (RMAN) symptom: Unable to register a database symptom: RMAN-10035: exception raised in RPC: ORA-01403: no data found symptom: RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT. CHECKBACKUPPIECE symptom: RMAN-03008: error while performing automatic resync of recovery catalog change: Upgrade to Oracle Server - Enterprise Edition 8.1.7 cause: Bug:1467871 Dummy records with status ¿D¿ inserted into BS table during backup. RMAN mishandles these records during sync of the recovery of the catalog. fix: Upgrade to Oracle Server 9i Or use following workaround: Rebuild the target database control file References: Note:1012929.6 How to Recreate the Controlfile . Hope this helped. Cherie Danny Hughes DHUGHES@knobi To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] as.com cc: Sent by: Subject: RMAN error registering database [EMAIL PROTECTED] om 05/30/02 06:43 PM Please respond to ORACLE-L when I try to register my database in RMAN, I get the following error.. RMAN-08002: starting full resync of recovery catalog RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01403: no data found RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECE does anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution. TIA Danny Hughes DBA Knobias.com 601-978-3399 x103 [EMAIL PROTECTED] www.knobias.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danny Hughes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail
RMAN error registering database
when I try to register my database in RMAN, I get the following error.. RMAN-08002: starting full resync of recovery catalog RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03008: error while performing automatic resync of recovery catalog RMAN-07004: unhandled exception during command execution on channel default RMAN-10035: exception raised in RPC: ORA-01403: no data found RMAN-10031: ORA-1403 occurred during call to DBMS_RCVCAT.CHECKBACKUPPIECE does anyone know how to get around this problem...I have an ITAR open with oracle right now and wanted to try this forum while I am waiting on a resolution. TIA Danny Hughes DBA Knobias.com 601-978-3399 x103 [EMAIL PROTECTED] www.knobias.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danny Hughes INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN error while TSPITR
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RMAN error while TSPITR
Hi,
I had problems duplicating to a point in time and the workaround was to
set
the nls_date_format on OS level
so I started my script with export NLS_DATE_FORMAT=format mask and that
fixed my problem
Jack
Sona [EMAIL PROTECTED]@fatcity.com on 31-01-2002 01:11:30
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON
DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06136: ORACLE error from auxiliary database: ORA-01841: (full) year
must be between -4713 and +, and not be 0
RMAN-06097: text of failing SQL statement: select to_date('JAN 30 2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
NLS_DATE_FORMAT is set to MON DD HH24:MI:SS for the target database.
I even tried this but got the same error.
run
{
set until time '30-JAN-2002 14:53:56';
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
release channel c1;
}
Any ideas about this one?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de
verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.
Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos
Re: RMAN error while TSPITR
What do i set the NLS_DATE_FORMAT as? I tried setting it as
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
But got this error :
ksh: HH24:MI:SS: is not an identifier
Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i
still get the same error.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 10:38 AM
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RMAN error while TSPITR
Hi,
I had problems duplicating to a point in time and the workaround was to
set
the nls_date_format on OS level
so I started my script with export NLS_DATE_FORMAT=format mask and that
fixed my problem
Jack
Sona [EMAIL PROTECTED]@fatcity.com on 31-01-2002 01:11:30
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON
DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06136: ORACLE error from auxiliary database: ORA-01841: (full) year
must be between -4713 and +, and not be 0
RMAN-06097: text of failing SQL statement: select to_date('JAN 30 2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
NLS_DATE_FORMAT is set to MON DD HH24:MI:SS for the target database.
I even tried this but got the same error.
run
{
set until time '30-JAN-2002 14:53:56';
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
release channel c1;
}
Any ideas about this one?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.
Indien
RE: RMAN error while TSPITR
you should set it as such :
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
you were missing the double quotes
regards
ReedK
-Original Message-
Sent: Thursday, January 31, 2002 3:50 PM
To: Multiple recipients of list ORACLE-L
What do i set the NLS_DATE_FORMAT as? I tried setting it as
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
But got this error :
ksh: HH24:MI:SS: is not an identifier
Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i
still get the same error.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 10:38 AM
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RMAN error while TSPITR
Hi,
I had problems duplicating to a point in time and the workaround was to
set
the nls_date_format on OS level
so I started my script with export NLS_DATE_FORMAT=format mask and that
fixed my problem
Jack
Sona [EMAIL PROTECTED]@fatcity.com on 31-01-2002 01:11:30
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON
DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06136: ORACLE error from auxiliary database: ORA-01841: (full) year
must be between -4713 and +, and not be 0
RMAN-06097: text of failing SQL statement: select to_date('JAN 30 2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
NLS_DATE_FORMAT is set to MON DD HH24:MI:SS for the target database.
I even tried this but got the same error.
run
{
set until time '30-JAN-2002 14:53:56';
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
release channel c1;
}
Any ideas about this one?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst
Young, niet toegestaan. Ernst Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht
Re: RMAN error while TSPITR
Sujatha,
I tried doing that but it failed
Set the NLS_DATE_FORMAT=DD-MON- HH24:MI:SS at OS level.
RMAN script is
run
{
set until time '30-JAN-2002 14:53:56';
allocate clone channel c1 type disk;
allocate clone channel c2 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
}
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
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: allocate
RMAN-06136: ORACLE error from auxiliary database: ORA-01858: a non-numeric
character was found where a numeric was expected
RMAN-06097: text of failing SQL statement: select to_date('30-JAN-2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
Am I missing something? I also set the nls_date_format for the target
database to DD-MON- HH24:MI:SS
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 3:40 PM
Sona,
Try setting the NLS_DATE_FORMAT=DD-MON- 24HH:MI:SS at the OS level.
Then in your RMAN script you should specify the point in time date as
follows:
set until time '31-JAN-2002 23:05:00';
It should work (I've tested it).
Regards,
Sujatha
-Original Message-
Sent: Friday, 1 February 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
What do i set the NLS_DATE_FORMAT as? I tried setting it as
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
But got this error :
ksh: HH24:MI:SS: is not an identifier
Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i
still get the same error.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 10:38 AM
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: RMAN error while TSPITR
Hi,
I had problems duplicating to a point in time and the workaround was to
set
the nls_date_format on OS level
so I started my script with export NLS_DATE_FORMAT=format mask and that
fixed my problem
Jack
Sona [EMAIL PROTECTED]@fatcity.com on 31-01-2002 01:11:30
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON
DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06136: ORACLE error from auxiliary database: ORA-01841: (full) year
must be between -4713 and +, and not be 0
RMAN-06097: text of failing SQL statement: select to_date('JAN 30 2002
14:53:56') from sys.dual
RMAN-06099: error occurred
RE: RMAN error while TSPITR
Sona,
Try this in your rman script
set until time to_date('30-JAN-2002 12:00:00' ,'dd-mon- hh24:mi:ss');
Make sure you have the NLS_DATE_FORMAT set too.
Sujatha
-Original Message-
Sent: Friday, 1 February 2002 11:45 AM
To: Multiple recipients of list ORACLE-L
Sujatha,
I tried doing that but it failed
Set the NLS_DATE_FORMAT=DD-MON- HH24:MI:SS at OS level.
RMAN script is
run
{
set until time '30-JAN-2002 14:53:56';
allocate clone channel c1 type disk;
allocate clone channel c2 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
}
RMAN-03022: compiling command: set
RMAN-03022: compiling command: allocate
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: allocate
RMAN-06136: ORACLE error from auxiliary database: ORA-01858: a non-numeric
character was found where a numeric was expected
RMAN-06097: text of failing SQL statement: select to_date('30-JAN-2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
Am I missing something? I also set the nls_date_format for the target
database to DD-MON- HH24:MI:SS
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 3:40 PM
Sona,
Try setting the NLS_DATE_FORMAT=DD-MON- 24HH:MI:SS at the OS level.
Then in your RMAN script you should specify the point in time date as
follows:
set until time '31-JAN-2002 23:05:00';
It should work (I've tested it).
Regards,
Sujatha
-Original Message-
Sent: Friday, 1 February 2002 9:50 AM
To: Multiple recipients of list ORACLE-L
What do i set the NLS_DATE_FORMAT as? I tried setting it as
export NLS_DATE_FORMAT=MON DD HH24:MI:SS
But got this error :
ksh: HH24:MI:SS: is not an identifier
Setting it to export NLS_DATE_FORMAT=MON-DD-HH24:MI:SS worked but i
still get the same error.
Sona
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 31, 2002 10:38 AM
IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway.
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/30/02 11:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: RMAN error while TSPITR
Hi,
I had problems duplicating to a point in time and the workaround was to
set
the nls_date_format on OS level
so I started my script with export NLS_DATE_FORMAT=format mask and that
fixed my problem
Jack
Sona [EMAIL PROTECTED]@fatcity.com on 31-01-2002 01:11:30
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON
DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013
RMAN error while TSPITR
Hi,
I encountered the following error while performing TSPITR using RMAN
Below is the script being executed
run
{
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf';
recover tablespace admin until time to_date('JAN 30 2002 14:53:56','MON DD
HH24:MI:SS');
}
Teh error stack is as follows
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c1
RMAN-08500: channel c1: sid=9 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03022: compiling command: recover
RMAN-03027: printing stored script: Memory Script
{
# set the until clause
set until time 'JAN 30 2002 14:53:56';
# restore the controlfile
restore clone controlfile to clone_cf;
# replicate the controlfile
replicate clone controlfile from clone_cf;
# mount the controlfile
sql clone 'alter database mount clone database';
# archive current online log for tspitr to a resent until time
sql 'alter system archive log current';
# resync catalog after controlfile restore
resync catalog;
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: set
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c1
RMAN-00571: ===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03002: failure during compilation of command
RMAN-03013: command type: IRESTORE
RMAN-06136: ORACLE error from auxiliary database: ORA-01841: (full) year
must be between -4713 and +, and not be 0
RMAN-06097: text of failing SQL statement: select to_date('JAN 30 2002
14:53:56') from sys.dual
RMAN-06099: error occurred in source file: krmk.pc, line: 4354
NLS_DATE_FORMAT is set to MON DD HH24:MI:SS for the target database.
I even tried this but got the same error.
run
{
set until time '30-JAN-2002 14:53:56';
allocate channel c1 type disk;
set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf';
recover tablespace admin;
release channel c1;
}
Any ideas about this one?
TIA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sona
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RMAN error
HI
I trying to recoverfrom loss of all
controlfiles and a datafile which was not backed upusing RMAN
.
these are the steps i followed
startup nomount
These are the RMAN commands
executed.
{allocate channel c1 type disk;restore
controlfile;sql 'alter database mount';restore database;recover
database;release channel c1;}
the recover fails wit the following error
RMAN-03022: compiling command:
recover(2)
RMAN-03022: compiling command:
recover(3)RMAN-03023: executing command: recover(3)RMAN-08054:
starting media recovery
RMAN-03022: compiling command:
recover(4)RMAN-03026: error recovery releasing channel
resourcesRMAN-08031: released channel: c1RMAN-00571:
===RMAN-00569: =
ERROR MESSAGE STACK FOLLOWS ===RMAN-00571:
===RMAN-03015:
error occurred in stored script case14RMAN-03002: failure during
compilation of commandRMAN-03013: command type: recoverRMAN-03002:
failure during compilation of commandRMAN-03013: command type:
recover(4)RMAN-06003: ORACLE error from target database: ORA-19634:
filename required for this functionORA-06512: at
"SYS.X$DBMS_BACKUP_RESTORE", line 1977ORA-06512: at line 1RMAN-06097:
text of failing SQL statement: begin :valrc := sys . dbms_backup_restore .
validateArchivedLog ( :recid , :stamp , :fname , :thd , :seq , :resetscn ,
:lowscn , :blksize ) ; end ;RMAN-06099: error occurred in source file:
krmk.pc, line: 8517
Does anyone have any idea what this error is
about?
I think in this case the recovery is failiing
while trying to recover the non-existent datafile.But how would one know
looking at this error stack.
If we perform recovery without RMAN ,Oracle would
normally give a decent error
like
ORA-00283:
recovery session canceled due to errors
ORA-01244:
unnamed datafile(s) added to controlfile by media recovery
but
with RMAN the error stack given is totally vague. Has anyone encountered this
one?
TIA
