Home » RDBMS Server » Backup & Recovery » Fully automated TSPITR with RMAN
Fully automated TSPITR with RMAN [message #202082] Wed, 08 November 2006 02:51 Go to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi All,

I am performing "Fully automated TSPITR with RMAN". I am getting the following error message when I perform recovery.

Can anybody help me?

RMAN> Run
2> {
3> Restore tablespace USERS;
4> Restore tablespace TOOLS;
5> }

Starting restore at 08-NOV-06

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00009 to C:\ORACLE\ORADATA\STREAM\USERS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=E:\TEMPDEST\STD_0EI1SON6_1_1 tag=TAG20061108T131934 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 08-NOV-06

Starting restore at 08-NOV-06

using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00008 to C:\ORACLE\ORADATA\STREAM\TOOLS01.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=E:\TEMPDEST\STD_0DI1SON2_1_1 tag=TAG20061108T131930 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 08-NOV-06

RMAN> RECOVER TABLESPACE users,tools UNTIL LOGSEQ 2 THREAD 1 AUXILIARY DESTINATI
ON 'E:\PITR';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "auxiliary": expecting one of: "archivelog, chec
k, delete, from, noredo, ;"
RMAN-01007: at line 1 column 56 file: standard input


regards,
Kamalakar
Re: Fully automated TSPITR with RMAN [message #202085 is a reply to message #202082] Wed, 08 November 2006 02:57 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
RECOVER TABLESPACE users,tools UNTIL LOGSEQ 2 THREAD 1 AUXILIARY DESTINATION 'E:\PITR';



EDIT:
Ok. I see why you are doing this. With automatic TSPITR you some thingies to be preconfigured.
Refer correct documentation as said in other posts.

[Updated on: Wed, 08 November 2006 03:16]

Report message to a moderator

Re: Fully automated TSPITR with RMAN [message #202088 is a reply to message #202085] Wed, 08 November 2006 03:03 Go to previous messageGo to next message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi Mahesh,

I want to perform TSPITR with tablespace backup. This command I found in the following link:

http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmtspit003.htm

I am trying to perform TSPITR on Oracle 9i databases.

Please suggest me.

Regards,
Kamalakar.

Re: Fully automated TSPITR with RMAN [message #202089 is a reply to message #202088] Wed, 08 November 2006 03:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I have just edited the previous post.
Re: Fully automated TSPITR with RMAN [message #202091 is a reply to message #202089] Wed, 08 November 2006 03:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
ANd always refer correct documentation.
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtspit.htm#443357
For RMAN 9i methods refer the above URL.
The one you were looking earlier is for 10g. There are subtle differences that will make RMAN sing a different song. Smile
Re: Fully automated TSPITR with RMAN [message #202092 is a reply to message #202089] Wed, 08 November 2006 03:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtspit.htm#448114
Re: Fully automated TSPITR with RMAN [message #202093 is a reply to message #202091] Wed, 08 November 2006 03:17 Go to previous message
kamalakar_ora
Messages: 30
Registered: October 2006
Location: Bangalore
Member
Hi Mahesh,

Thank you very much.

Regards,
Kamalakar
Previous Topic: Cold backup script
Next Topic: Restore and recover of corrupted datafiles
Goto Forum:
  


Current Time: Mon Dec 05 02:27:43 CST 2016

Total time taken to generate the page: 0.14236 seconds