RMAN [message #283326] |
Mon, 26 November 2007 13:40 |
vjeedigunta
Messages: 201 Registered: March 2005 Location: Hyderabad
|
Senior Member |
|
|
Can you please answer this .. ?
Scenario : Consider you have lost the server which hosts both your database and your catalog database… there is nothing you can do except just restore the binaries only on the server for which you want to do recovery { there is no backup of catalog server / database } and media server is available.
Q. How do we recover from this scenario , reviving the database using the just the binaries and the backupsets of this server on Netbackup / TSM?
Thanks in advance.
|
|
|
|
|
|
|
|
|
Re: RMAN [message #283435 is a reply to message #283366] |
Tue, 27 November 2007 02:30 |
|
Michel Cadot
Messages: 68716 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Here's a script I used several years ago in such a case:
set dbid=XXXXXXXX;
connect target /;
run {
startup nomount;
allocate channel t1 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/export/home/oracle/testResto/tdpo.opt)';
restore controlfile from autobackup until time = '25/06/2003 23:59:59';
allocate channel t2 type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/export/home/oracle/testResto/tdpo.opt)';
alter database mount;
set until time = '23/06/2003 20:00:00';
restore database
skip forever tablespace dwhmaintenance, dwh10ut, dwh10ui, dwh99Ut, dwh99ui;
recover database
skip forever tablespace dwhmaintenance, dwh10ut, dwh10ui, dwh99Ut, dwh99ui
delete archivelog;
release channel t2;
release channel t1;
alter database open resetlogs;
}
Regards
Michel
|
|
|