Skip to Main Content
  • Questions
  • How to recover a part of a database without knowing its structure.

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Daniel.

Asked: January 14, 2020 - 8:09 am UTC

Last updated: January 15, 2020 - 7:40 am UTC

Version: 12.1

Viewed 1000+ times

You Asked

Hi
I want to recover only one tablespace from an old bd with many tablespaces.
I have a rman backup without a catalog.

I restored the control file, mounted the bd, but I can't exclude tablespaces from the restore because I don't know they names.

The only way is to take a list of data files from a "backup control file to trace", "set new name" and restore the entire bd or there is a way to get the list of tablespaces from controlfile and do a "restore the database skip tablespaces"?

Thank you very much.

and Connor said...

If you have your control file, then presumably you have your database in a MOUNT state. You can view v$tablespace and match it to v$datafile on CON_ID (if necessary) and ts#

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 4294964736 bytes
Fixed Size                  9037312 bytes
Variable Size            1140850688 bytes
Database Buffers         2600468480 bytes
Redo Buffers                7737344 bytes
In-Memory Area            536870912 bytes
Database mounted.

SQL> select * from v$tablespace order by con_id, ts#;

       TS# NAME                           INC BIG FLA ENC     CON_ID
---------- ------------------------------ --- --- --- --- ----------
         0 SYSTEM                         YES NO  YES              1
         1 SYSAUX                         YES NO  YES              1
         2 UNDOTBS1                       YES NO  YES              1
         3 TEMP                           NO  NO  YES              1
         4 USERS                          YES NO  YES              1
         0 SYSTEM                         YES NO  YES              2
         1 SYSAUX                         YES NO  YES              2
         2 UNDOTBS1                       YES NO  YES              2
         3 TEMP                           NO  NO  YES              2
         0 SYSTEM                         YES NO  YES              3
         1 SYSAUX                         YES NO  YES              3
         3 TEMP                           NO  NO  YES              3
         5 USERS                          YES NO  YES              3
         6 LARGETS                        YES NO  YES              3
         8 ASKTOM                         YES NO  YES              3
        10 SAMPLES                        YES NO  YES              3
        11 UNDO01                         YES NO  YES              3
        12 NO_ASSM                        YES NO  YES              3

18 rows selected.



Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Solved

Daniel, March 17, 2020 - 7:48 am UTC

I should have tried it ...

thanks

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database