-
RMAN and recovering data
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 !!!
-
Originally Posted by BeefStu
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"
This message shows that you are connecting RMAN thru target database control file and not thru recovery catalog.
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.
---------------
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|