This post is more than 5 years old
5 Posts
0
3473
May 29th, 2008 06:00
RMAN restore fails.
Hi,
I have dropped a Oracle table and want to restore that from my backup.
I have tried the following RMAN script but landed up with errors. Even after configuring the NSR_DEBUG_File it says the NMO error is lost.
Please help.
Wr
Ram
RMan recovery Script.
C:\>rman @ orclres1.rman
Recovery Manager: Release 9.0.1.1.1 - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
RMAN> connect target sys/oracle@mydemo
2> run {
3> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_DEBUG_FILE=C:\restore.log
)';
4> send 'NSR_ENV=(NSR_SERVER=nwrkwin2k3dc.mydemo.com, NSR_CLIENT=documentum.myde
mo.com, NSR_GROUP=default)';
5> sql 'alter tablespace users offline immediate';
6> restore tablespace users;
7> recover tablespace users;
8> sql 'alter tablespace users online';
9> release channel t1;
10>
11> }
12>
13>
14>
connected to target database: MYDEMO (DBID=974975544)
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=8 devtype=SBT_TAPE
channel t1: NMO v4.5.0.0
sent command to channel: t1
sql statement: alter tablespace users offline immediate
Starting restore at 29-MAY-08
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to F:\ORACLE\ORADATA\MYDEMO\USERS01.DBF
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 05/29/2008 17:58:37
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-12004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file ORA-19511: Error received from media manager layer, error text: The NMO error message has been lost. Please set NSR_DEBUG_FILE and run NMO
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Recovery Manager complete.
I have dropped a Oracle table and want to restore that from my backup.
I have tried the following RMAN script but landed up with errors. Even after configuring the NSR_DEBUG_File it says the NMO error is lost.
Please help.
Wr
Ram
RMan recovery Script.
C:\>rman @ orclres1.rman
Recovery Manager: Release 9.0.1.1.1 - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
RMAN> connect target sys/oracle@mydemo
2> run {
3> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_DEBUG_FILE=C:\restore.log
)';
4> send 'NSR_ENV=(NSR_SERVER=nwrkwin2k3dc.mydemo.com, NSR_CLIENT=documentum.myde
mo.com, NSR_GROUP=default)';
5> sql 'alter tablespace users offline immediate';
6> restore tablespace users;
7> recover tablespace users;
8> sql 'alter tablespace users online';
9> release channel t1;
10>
11> }
12>
13>
14>
connected to target database: MYDEMO (DBID=974975544)
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=8 devtype=SBT_TAPE
channel t1: NMO v4.5.0.0
sent command to channel: t1
sql statement: alter tablespace users offline immediate
Starting restore at 29-MAY-08
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to F:\ORACLE\ORADATA\MYDEMO\USERS01.DBF
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 05/29/2008 17:58:37
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03006: non-retryable error occurred during execution of command: IRESTORE
RMAN-12004: unhandled exception during command execution on channel t1
RMAN-10035: exception raised in RPC: ORA-27192: skgfcls: sbtclose2 returned error - failed to close file ORA-19511: Error received from media manager layer, error text: The NMO error message has been lost. Please set NSR_DEBUG_FILE and run NMO
RMAN-10031: ORA-19583 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPPIECE
Recovery Manager complete.
0 events found
No Events found!
ble1
6 Operator
•
14.4K Posts
•
56.2K Points
0
May 30th, 2008 05:00
Hemant-I97jT
1 Rookie
•
117 Posts
1
May 29th, 2008 06:00
The information in this article applies to:
RMAN Tablespace Point-in-time Recovery (TSPITR).
Symptom(s)
~~~~~~~~~~
You are using RMAN to perform a tablespace point-in-time recovery (TSPITR) and it fails with
the following errors:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failure during compilation of command
RMAN-03013: command type: host
RMAN-06135: error executing host command:
Additional information: 256
Additional information: 10
Change(s)
~~~~~~~~~~
You are using temporary tablespaces with tempfiles.
Cause
~~~~~~~
If you are using RMAN TSPITR with backups of a database that has temporary tablespaces
containing tempfiles, you will run into this error. The main cause of this error is
the export command failing. If you check the RMAN log, you will notice RMAN
trying to execute commands similar to the ones shown below:
host 'exp userid =\"sys/oracle@aux81 as sysdba\" point_in_time_recover=y
tablespaces=USERS file=tspitr_a.dmp';
If you try to run this command manually at OS prompt, you get the following errors:
...
About to export Tablespace Point-in-time Recovery objects ...
EXP-00008: ORACLE error 3217 encountered
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
ORA-06512: at "SYS.DBMS_PITR", line 600
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully
Since the host command 'exp' fails, RMAN reports RMAN-03013 error.
This error is due to Bug 1656080.
Bug 1656080
Abstract: ORA-3217 TSPITR CLONE EXPORT, PRIMARY DB HAS TEMPORARY TABLESPACE TEMPFILES
Fixed in release: 9.2
Fix
~~~~
The bug is fixed in Oracle release 9.2
Backports exist on top of 8.1.7 and 9.0.x for certain platforms.
Workaround:
Drop all temporary tablespace tempfiles before backing up the controlfile, which
is not very practical.
References
~~~~~~~~~~~
Note 109979.1 - "RMAN: Tablespace Point In Time Recovery (TSPITR) Procedure."
Hemant-I97jT
1 Rookie
•
117 Posts
0
May 29th, 2008 06:00
ramkumar3
5 Posts
0
May 30th, 2008 05:00
Now the restore is succeding. Please see the cmd output given below.
C:\>rman @ orclres1.rman
Recovery Manager: Release 9.0.1.1.1 - Production
(c) Copyright 2001 Oracle Corporation. All rights reserved.
RMAN> connect target sys/oracle@mydemo
2> run {
3> allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_DEBUG_FILE=C:\restore.log
)';
4> send 'NSR_ENV=(NSR_SERVER=nwrkwin2k3dc.mydemo.com, NSR_CLIENT=documentum.myde
mo.com, NSR_GROUP=default)';
5> sql 'alter tablespace users offline immediate';
6> restore tablespace users;
7> recover tablespace users;
8> sql 'alter tablespace users online';
9> release channel t1;
10>
11> }
12>
13>
14>
connected to target database: MYDEMO (DBID=974975544)
using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=10 devtype=SBT_TAPE
channel t1: NMO v4.5.0.0
sent command to channel: t1
sql statement: alter tablespace users offline immediate
Starting restore at 30-MAY-08
channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to F:\ORACLE\ORADATA\MYDEMO\USERS01.DBF
channel t1: restored backup piece 1
piece handle=MYDEMO_0ejhlmor_1_1 tag=ORCLFULL params=NULL
channel t1: restore complete
Finished restore at 30-MAY-08
Starting recover at 30-MAY-08
starting media recovery
archive log thread 1 sequence 5 is already on disk as file F:\ORACLE\ORA90\RDBMS
\ARC00005.001
archive log thread 1 sequence 6 is already on disk as file F:\ORACLE\ORA90\RDBMS
\ARC00006.001
archive log thread 1 sequence 7 is already on disk as file F:\ORACLE\ORA90\RDBMS
\ARC00007.001
archive log filename=F:\ORACLE\ORA90\RDBMS\ARC00005.001 thread=1 sequence=5
media recovery complete
Finished recover at 30-MAY-08
sql statement: alter tablespace users online
released channel: t1
Recovery Manager complete.
But still if i check my table doesnt exists. I am new to oracle, is there anything i am missing out. Please help