RMAN backup recovery [message #630475] |
Mon, 29 December 2014 02:35 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
Hi,
I have a RAC(2 nodes) 11gR2. Both nodes are configured with TDPO and we are backup to tape TSM.
On TSM server scan name is configured..And It is tested that backup from node A can be restored on node B.
Now we have a test environment and TDPO is configured with scan name to TSM server. But we are unable to restore the RMAN backup to our new test environment...
error
RMAN-03002
RMAN-06172
no autobackup found...
Please help me if I can do something of TSM Server or Oracle Server.
Regards,
|
|
|
|
Re: RMAN backup recovery [message #630546 is a reply to message #630478] |
Tue, 30 December 2014 02:16 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
Clearly mentioned as
I have RMAN backup spfile+controlfile+database+archivelog on TSM server taken using TDPO client.
Now I want to recover it on New Servers....
Please help me.
|
|
|
|
Re: RMAN backup recovery [message #630643 is a reply to message #630548] |
Thu, 01 January 2015 10:50 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
ok I did restore ...
But how much I can recover...
thread 1 or thread 2...
Second question I restore controlfile which is old so further archivelog backups are not catalog in controlfile which I restore from backup.
Now how to catalog backup which are not in controlfile catalog from tsm server.
|
|
|
|
|
|
Re: RMAN backup recovery [message #631237 is a reply to message #630646] |
Sun, 11 January 2015 02:56 |
smunir362
Messages: 310 Registered: September 2007
|
Senior Member |
|
|
Thanks,
Now I am able to recover from tsm and I can catalog from tsm..
Well
Now I am able to restore/rcover using until SCN and until SEQUENCE...
I can use RMAN>list backup of archivelog all;
From output I can determine the SCN and Sequence..
But How can I restore/recover using until time My concern is How can I determine the point of time from avaliable backup.
|
|
|
Re: RMAN backup recovery [message #631238 is a reply to message #631237] |
Sun, 11 January 2015 03:00 |
|
Michel Cadot
Messages: 68732 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
I don't understand the question "list" also gives you the times.
Also please post the command you executed to catalog, restore and recover from TSM so it will be helpful for future readers.
[Updated on: Sun, 11 January 2015 03:01] Report message to a moderator
|
|
|
|
Re: RMAN backup recovery [message #631240 is a reply to message #631239] |
Sun, 11 January 2015 03:06 |
|
Michel Cadot
Messages: 68732 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Yes.
Quote:Also please post the command you executed to catalog, restore and recover from TSM so it will be helpful for future readers.
|
|
|