Solved

TRIED TO BACKUP TABLESPACE USING RMAN SHOWS ERROR

Posted on 2006-11-18
5
637 Views
Last Modified: 2008-01-09
SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP


RMAN> backup filesperset=2 tablespace SYSTEM,UNDOTBS1,SYSAUX,TEMP,objects;

Starting backup at 18-NOV-06
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/18/2006 00:56:59
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEMP"

WHAT IS THE REASON FOR THIS ERROR??
0
Comment
Question by:dbaseek
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:dbaseek
ID: 17970845
AFTER THAT I TRIED THIS


RMAN> BACKUP FILESPERSET=2 TABLESPACE SYSTEM,UNDOTBS1,SYSAUX,TEMP,OBJECTS;

Starting backup at 18-NOV-06
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 11/18/2006 01:05:14
RMAN-03014: implicit resync of recovery catalog failed
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20020: database in
carnation not set

WHAT IS THE PROBLEM???CAN U HELP ME TO FIX THIS???
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 17972180
You don't need to backup the TEMP tablespace, so remove that from the list of tablespaces to back up.
0
 

Author Comment

by:dbaseek
ID: 17972660
how can i remove?
0
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 500 total points
ID: 17973041
Like this:
RMAN> BACKUP FILESPERSET=2 TABLESPACE SYSTEM,UNDOTBS1,SYSAUX;

or this, even simpler command, just:
RMAN> BACKUP DATABASE;

That way RMAN will figure out for you what needs to be backed up.
0
 

Author Comment

by:dbaseek
ID: 17977249
THANKS MAN
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question