Home » RDBMS Server » Backup & Recovery » RMAN
RMAN [message #283326] Mon, 26 November 2007 13:40 Go to next message
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 #283327 is a reply to message #283326] Mon, 26 November 2007 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore the control file and configuration file, then the datafiles, then recover the database.

Regards
Michel

[Updated on: Mon, 26 November 2007 13:47]

Report message to a moderator

Re: RMAN [message #283328 is a reply to message #283326] Mon, 26 November 2007 13:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Backup and Recovery Advanced User's Guide
Backup and Recovery Basics
Backup and Recovery Quick Start Guide
Backup and Recovery Reference

All of the manuals listed above can be found at http://tahiti.oracle.com

Your answer(s) can be found in them.

[Updated on: Mon, 26 November 2007 13:46] by Moderator

Report message to a moderator

Re: RMAN [message #283330 is a reply to message #283327] Mon, 26 November 2007 13:56 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Restore from where .. ? we dont have the backups.
Re: RMAN [message #283331 is a reply to message #283330] Mon, 26 November 2007 14:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you lose the files and their backups you lose the database.
But you said:
Quote:

reviving the database using the just the binaries and the backupsets of this server on Netbackup / TSM?

Do you have or not the backups on tape?

Regards
Michel
Re: RMAN [message #283338 is a reply to message #283331] Mon, 26 November 2007 15:11 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

yes backupsets are on tape .. can you share me any link on the process you defined.. i am new to this.

Thanks.
Re: RMAN [message #283366 is a reply to message #283338] Mon, 26 November 2007 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3:
Backup and Recovery Advanced User's Guide
Backup and Recovery Basics
Backup and Recovery Quick Start Guide
Backup and Recovery Reference

Regards
Michel
Re: RMAN [message #283435 is a reply to message #283366] Tue, 27 November 2007 02:30 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Redo Log File
Next Topic: Best Method for backup of PROD environment
Goto Forum:
  


Current Time: Mon May 20 10:18:16 CDT 2024