Printable View
I have my database running in archive mode and I am trying to recover a table while running RMAN on the command line and this does not seem to be working for me.
Can somebody outline the steps (with syntax) that I need to take to recover the table.
Thanks in advance for all that answer
you cant recover tables with rman, rman deals with blocks, datafiles and tablespaces
thanks, can you provide me with an outline on how to recover a tablespace or datafile?
might be an idea to explain what you are trying to do
I have a varchar2 column in a table, which contains binary data. We chose varchar2's columns based on how the RDBMS stores values for varchars as opposed to blobs. At least historically, blobs were stored separately and I was concerned about access times especially in light of the fact that we use select *. In addition, to
change varchar2 to blobs or raws at this point is not worth the development time.
Now we are porting our application to Oracle 10G I want to verify if RMAN can restore a table that has binary data in a varchar2 column without any data translation. So what I tried doing is placing one table that has varchar2 column with binary data into its own tablespace.
I backed up the tablespace using RMAN.
I went into SQLPLUS and dropped the tablespace including contents
I tried restoring the tablespace via RMAN and I was not succesful.
My database is in archive mode but I know I missing some step/(s) on the restoration side. That is where I need a bit of assitance.
Any help and exact syntax would be appreciated.
Thanks in advance to all who answer this post
You may have to restore using backup control file as the current control file doesn't have entry for dropped tablespace. Can you paste you rman script?
doesnt matter what the data is, rman will restore it
might be helpful to know what you did
rman> backup tablespace pbh'
sqlplus sys/"sys as sysdba"
sqlplus > drop tablespace pbh including contents;
rman> restore tablespace pbh;
Starting restore at 10-AUG-06
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=138 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/10/2006 15:01:11
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "PBH"
So you are trying to restore the tablespace just like you were trying to do here ??
The answer will be the same !!!
This message shows that you are connecting RMAN thru target database control file and not thru recovery catalog.Quote:
Originally Posted by BeefStu
If you use recovery catalog, when you execute your backup,
then use recovery catalog, before executing the restore command.
If you execute your backup command using target database control file, then chances are, those entries have been aged out. And that is why your restore command no longer recognized by RMAN.
:D
The error has nothing to do with the use of a recovery catalog or not and whether the entries are expired from the control file. It is the error you would expect to encounter if you simply DROP a tablespace and then go into RMAN and issue a restore tablespace <tablespace_name>, which is what the OP is doing.
Code:C:\>rman target /
Recovery Manager: Release 9.2.0.6.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ORCL9 (DBID=3074164973)
RMAN> restore tablespace test_restore;
Starting restore at 11-AUG-06
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=9 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/11/2006 08:19:12
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEST_RESTORE"
RMAN>