Home » RDBMS Server » Backup & Recovery » Restoration throuh Rman (9.2.0.7.0 red hat 3)
icon8.gif  Restoration throuh Rman [message #308648] Tue, 25 March 2008 02:27 Go to next message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member
Hi

I am new to rman I had taken the rman backup.

and I want to restore it on another server

i will be very thankful if any one provide detailed steps

restoring and recovering the database

run
{
ALLOCATE CHANNEL c1 DEVICE TYPE DISK MAXOPENFILES=1;
BACKUP FORMAT '/backup/backupset/HB_%d_%s_%T.BKUP' FILESPERSET=2 database;
BACKUP FORMAT '/backup/backupset/CF_%d_%s_%T.BKUP' CURRENT CONTROLFILE;
sql 'Alter system archive log current';
BACKUP FORMAT '/backup/backupset/ARCH_%d_%s_%T.BKUP' archivelog from time 'sysdate-2' ;
sql 'Alter database backup controlfile to trace';
}


Thanks for your help as always

[Updated on: Tue, 25 March 2008 02:34]

Report message to a moderator

Re: Restoration throuh Rman [message #308654 is a reply to message #308648] Tue, 25 March 2008 02:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can restore or clone
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmrecov002.htm#sthref723
Re: Restoration throuh Rman [message #308669 is a reply to message #308654] Tue, 25 March 2008 02:59 Go to previous messageGo to next message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member

Hi Mahesh

Thanks for your reply

i had done the folling steps

I had started the database in nomount

startup nomount


alter database mount;

rman target / nocatalog

restore database;

channel ORA_DISK_1: reading from backup piece /data1/oracle/Rman_Backup/2fjaudqp_1_1
ORA-19870: error reading backup piece /data1/oracle/Rman_Backup/2fjaudqp_1_1
ORA-19505: failed to identify file "/data1/oracle/Rman_Backup/2fjaudqp_1_1"
ORA-27037: unable to obtain file status

do i need to set newname for all the datafile

or db_file_name_convert

log_file_name_convert is fine

Please suggest

Re: Restoration throuh Rman [message #308671 is a reply to message #308648] Tue, 25 March 2008 03:03 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
rman target / nocatalog


remove nocatalog option and try.
Re: Restoration throuh Rman [message #308725 is a reply to message #308648] Tue, 25 March 2008 05:23 Go to previous messageGo to next message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member
Hi any suggestion

channel ORA_DISK_1: reading from backup piece /backup1/hotbackup/HB_O102UAT_37_20080325.BKUP
ORA-19870: error reading backup piece /backup1/hotbackup/HB_O102UAT_37_20080325.BKUP
ORA-19505: failed to identify file "/backup1/hotbackup/HB_O102UAT_37_20080325.BKUP"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory

please suggest its a high priority
Re: Restoration throuh Rman [message #308736 is a reply to message #308648] Tue, 25 March 2008 05:40 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

have you copied the backup pieces to the new server including all the archivelog files etc?

Re: Restoration throuh Rman [message #308752 is a reply to message #308725] Tue, 25 March 2008 06:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
/backup1 should be accessible from the node you are execute RMAN (the other node).
just nfsmount the /backup1 to other server.
Re: Restoration throuh Rman [message #308903 is a reply to message #308736] Tue, 25 March 2008 22:11 Go to previous messageGo to next message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member
yes i have copied
Re: Restoration throuh Rman [message #308904 is a reply to message #308752] Tue, 25 March 2008 22:12 Go to previous message
praveenparachuri
Messages: 7
Registered: March 2008
Junior Member
yes its having the access an permissions

Thank you

Previous Topic: clone database using hot backup on windows
Next Topic: Datablock corruption on PA-RISC plataform
Goto Forum:
  


Current Time: Thu Dec 08 00:07:12 CST 2016

Total time taken to generate the page: 0.09591 seconds