OraFAQ Forum: Backup & Recovery » Fully automated TSPITR with RMAN

Home » RDBMS Server » Backup & Recovery » Fully automated TSPITR with RMAN

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Fully automated TSPITR with RMAN [message #202082]

Wed, 08 November 2006 02:51

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

Report message to a moderator

Re: Fully automated TSPITR with RMAN [message #202085 is a reply to message #202082]

Wed, 08 November 2006 02:57

Mahesh Rajendran
Messages: 10707
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

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.

Report message to a moderator

Re: Fully automated TSPITR with RMAN [message #202089 is a reply to message #202088]

Wed, 08 November 2006 03:04

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I have just edited the previous post.

Report message to a moderator

Re: Fully automated TSPITR with RMAN [message #202091 is a reply to message #202089]

Wed, 08 November 2006 03:14

Mahesh Rajendran
Messages: 10707
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