Topic: Backup & Recovery >> Recover the drop tablespace
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Recover the drop tablespace |
| |
Posted: Mar 06, 2008 02:59:02 PM |
Total Post: 46
Joined: Sep, 2007
|
hi
all plz help me to slove this prob.
i m using oracle 9i.
my prob is recover the droped tablespace.
my steps as folows:
1. CREATE TABLESPACE xyz
DATAFILE 'd:\oracle\oradata\AIDS\TEST.dbf' SIZE 500M REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
SEGMENT SPACE MANAGEMENT AUTO
PERMANENT
ONLINE;
2. i have created a table on that table space
3. and i have inserted few row.
4 then,
connect to the rman
RMAN> CONNECT CATALOG RMAN/PASSWORD@RMAN
RMAN> CONNECT TARGET SYSTEM/MANAGER@AIDS
RMAN>REGISTER DATABSE
RMAN>RESYNC CATALOG
RMAN> BACKUP TABLESPACE XYZ FORMAT 'C:\XYZ.DBF'
THEN,
SQL> DROP TABLESPACE XYZ
But now i m trying to recover the xyz tablespace through RMAN, i could not do that ,
error occured
RMAN> restore tablespace xyz
its saying that tablespace does not exit.
plz help me how to recover the tablespace.
tell me the steps by step
thnks in avance
Dwaipayan das
------------------ |
|
|
 Jolly |
| Posted: Mar 06, 2008 11:28:13 PM |  |
|
Total Post: 24
Joined: Mar, 2007
|
Startup mount
Invoke rman
restore tablespace <tablespace_name>
recover tablespace <tablespace_name>
alter database open
hope this will able to solve your problem.
|
|
|
|
|
| |
| Posted: Mar 07, 2008 12:16:51 PM | |
|
Total Post: 46
Joined: Sep, 2007
|
hi jolly
ur command is not working.
i got the following error:
RMAN> startup mount;
database is already started
RMAN> invoke rman;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter
, backup, beginline, blockrecover, catalog, change, connect, copy, create, cross
check, configure, duplicate, debug, delete, drop, exit, endinline, host, {, libr
ary, list, mount, open, print, quit, recover, register, release, replace, report
, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, s
pool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01008: the bad identifier was: invoke
RMAN-01007: at line 1 column 1 file: standard input
RMAN> restore tablespace xyz;
Starting restore at 07-MAR-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/07/2008 22:39:05
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "XYZ"
RMAN> recover tablespace xyz;
Starting recover at 07-MAR-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/07/2008 22:44:23
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespace
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "XYZ"
RMAN>
plz give me the actual solution,its urgent.plzzzzzzzzzzzzzz
|
|
|
|
|
| Jolly |
| Posted: Mar 09, 2008 05:10:09 PM | |
|
Total Post: 24
Joined: Mar, 2007
|
Hi
First step
Shutdown abort
Second step
Startup mount
Third ste[
Invoke rman means you have to connect to target database. If using recover catalog then connect your target database using rman catalog.
restore tablespace <tablespace_name>
recover tablespace <tablespace_name>
alter database open
Hope this will help you.
|
|
|
|
|
| |
| Posted: Mar 10, 2008 11:37:39 AM | |
|
Total Post: 46
Joined: Sep, 2007
|
HI JOLLY
THIS IS ALSO NOT WORKING.
I HAVE GIVEN THE COMMAND ACCORDING U.
HERE IS MY COMMAND:
SQL> CONNECT SYSTEM/MIRACLE1@AIDS AS SYSDBA;
Connected.
SQL> SHUTDOWN ABROT;
SP2-0717: illegal SHUTDOWN option
SQL> SHUTDOWN ABORT;
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 126950220 bytes
Fixed Size 453452 bytes
Variable Size 109051904 bytes
Database Buffers 16777216 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL>
............
RMAN> CONNECT CATALOG RMAN/PASSWORD@RMAN;
connected to recovery catalog database
RMAN> CONNECT TARGET SYSTEM/MIRACLE1@AIDS;
connected to target database (not started)
RMAN> CONNECT TARGET SYSTEM/MIRACLE1@AIDS;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected
RMAN> RESTORE TABLESPACE XYZ;
Starting restore at 10-MAR-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/10/2008 21:00:26
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespa
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "XYZ"
RMAN> RECOVER TABLESPACE XYZ;
Starting recover at 10-MAR-08
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/10/2008 21:01:56
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20202: tablespa
not found in the recovery catalog
RMAN-06019: could not translate tablespace name "XYZ"
RMAN>
PLZ HELP ME.......
|
|
|
|
|
| Jolly |
| Posted: Mar 10, 2008 11:13:36 PM | |
|
Total Post: 24
Joined: Mar, 2007
|
Hi
First make sure, you are trying to restore the right tablespace.. i.e check whether the tablespace is backed up and information is available in catalog.
Is the catalog in the same database being restored?
Else
You need to use TSPITR
i.e
timepoint 0-> your own business
timepoint 1-> you took a backup
timepoint 2-> tablespace is dropped.
and now at
timepoint 4-> restore to timepoint 0
Thanks
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
