Home » RDBMS Server » Backup & Recovery » RMAN Error (Linux, ORACLE 11G)
RMAN Error [message #537355] Tue, 27 December 2011 22:37 Go to next message
zutty
Messages: 45
Registered: December 2011
Member
run { allocate channel c1 type disk
2> maxpiecesize=200M format='/u01/app/oracle/df_%U.bak';
3> backup tablespace domain;
4> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=133 device type=DISK

Starting backup at 27-DEC-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/27/2011 09:54:47
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "DOMAIN"
Re: RMAN Error [message #537356 is a reply to message #537355] Tue, 27 December 2011 22:39 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
how to solve this error?
Re: RMAN Error [message #537357 is a reply to message #537355] Tue, 27 December 2011 22:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
bcm@bcm-laptop:~/old$ oerr rman 6019
6019, 1, "could not translate tablespace name \"%s\""
// *Cause:  An error occurred while looking up the specified tablespace name
//          in the recovery catalog or target database control file.
// *Action: This error is accompanied by other errors describing the reason
//          for the failure.  Ensure that the tablespace is entered correctly.
//          If the tablespace was added recently, then a RESYNC CATALOG must
//          be done to update the recovery catalog.
Re: RMAN Error [message #537393 is a reply to message #537357] Wed, 28 December 2011 02:10 Go to previous messageGo to next message
ashishs
Messages: 40
Registered: May 2011
Member

use
register database
resync catalog
command on rman prompt to register your target database with recvoery catalog
Re: RMAN Error [message #537397 is a reply to message #537356] Wed, 28 December 2011 02:21 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
RMAN> backup tablespace domain;

Starting backup at 28-DEC-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/28/2011 08:20:47
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "DOMAIN"

RMAN> sql 'create tablespace domain datafile size 1m';

sql statement: create tablespace domain datafile size 1m

RMAN> backup tablespace domain;

Starting backup at 28-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=C:\APP\JOHN\ORADATA\ORCL\DATAFILE\O1_MF_DOMAIN_7HONC2CL_.DBF
channel ORA_DISK_1: starting piece 1 at 28-DEC-11
channel ORA_DISK_1: finished piece 1 at 28-DEC-11
piece handle=C:\APP\JOHN\FAST_RECOVERY_AREA\ORCL\BACKUPSET\2011_12_28\O1_MF_NNNDF_TAG20111228T082058_7HONCBW7_.BKP tag=TAG20111228T082058 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 28-DEC-11

RMAN>
Re: RMAN Error [message #537515 is a reply to message #537397] Thu, 29 December 2011 02:25 Go to previous messageGo to next message
zutty
Messages: 45
Registered: December 2011
Member
RMAN> sql 'create tablespace domain datafile size 1m';

using target database control file instead of recovery catalog
sql statement: create tablespace domain datafile size 1m
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 12/28/2011 13:50:39
RMAN-11003: failure during parse/execution of SQL statement: create tablespace domain datafile size 1m
ORA-02236: invalid file name
Re: RMAN Error [message #537519 is a reply to message #537515] Thu, 29 December 2011 02:43 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
zutty, you have completely missed the point. I demonstated that your problem is that you were trying to backup a tablespace that does not exist. What do you want to do about that?
Think, man!
Re: RMAN Error [message #537525 is a reply to message #537519] Thu, 29 December 2011 03:02 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Think, man!


IMF task?

Regards
Michel
Previous Topic: start all database
Next Topic: Recover drop table
Goto Forum:
  


Current Time: Thu Mar 28 07:48:30 CDT 2024