OraFAQ Forum: Backup & Recovery » Restoration throuh Rman

Home » RDBMS Server » Backup & Recovery » Restoration throuh Rman (9.2.0.7.0 red hat 3)

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

Restoration throuh Rman [message #308648]

Tue, 25 March 2008 02:27

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

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

Report message to a moderator

Re: Restoration throuh Rman [message #308669 is a reply to message #308654]

Tue, 25 March 2008 02:59

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

Report message to a moderator

Re: Restoration throuh Rman [message #308671 is a reply to message #308648]

Tue, 25 March 2008 03:03

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

rman target / nocatalog

remove nocatalog option and try.

Report message to a moderator

Re: Restoration throuh Rman [message #308725 is a reply to message #308648]

Tue, 25 March 2008 05:23

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

Report message to a moderator