Home » RDBMS Server » Backup & Recovery » rman hotbackup (oracle 10g)
rman hotbackup [message #416219] Fri, 31 July 2009 04:41 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

I have 2 databases in open mode. One is for production and one for testing internally.

i have taken a hotbackup from the production database n want to restore it on the test db. I will then configured the test db on standby mode.

all the activity i had performed on the test db is outline below:

Startup nomount pfile=/oracle/pfile/initcnp1.ora;
Alter database mount;

Rman target /

Catalog backuppiece '/orabkup/filename;

Restore database;

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /data1/cnp/system.dbf
restoring datafile 00002 to /data1/cnp/undotbs2.dbf
restoring datafile 00003 to /data1/cnp/sysaux01.dbf
restoring datafile 00004 to /data2/cnp/arch.dbf
restoring datafile 00005 to /data1/cnp/cms.dbf
restoring datafile 00006 to /data2/cnp/cnp.dbf
restoring datafile 00007 to /data1/cnp/cnpind.dbf
restoring datafile 00008 to /data1/cnp/cwmlite.dbf
restoring datafile 00009 to /data1/cnp/drsys.dbf
restoring datafile 00010 to /data2/cnp/eur1.dbf
restoring datafile 00011 to /data1/cnp/indx.dbf
restoring datafile 00012 to /data1/cnp/odm.dbf
restoring datafile 00013 to /data2/cnp/portal.dbf
restoring datafile 00014 to /data1/cnp/portalind.dbf
restoring datafile 00015 to /data2/cnp/dmsdata.dbf
restoring datafile 00016 to /data1/cnp/rocdata.dbf
restoring datafile 00017 to /data1/cnp/rocind.dbf
restoring datafile 00018 to /data1/cnp/tools.dbf
restoring datafile 00019 to /data1/cnp/undotbs1.dbf
restoring datafile 00020 to /data1/cnp/users01.dbf
restoring datafile 00021 to /data2/cnp/wlportal.dbf
restoring datafile 00022 to /data2/cnp/wlportalind.dbf
restoring datafile 00023 to /data1/cnp/xdb.dbf
restoring datafile 00024 to /data2/cnp/bankdata.dbf
restoring datafile 00025 to /data2/cnp/bankind.dbf
restoring datafile 00026 to /data1/cnp/mast.dbf
restoring datafile 00027 to /data1/cnp/mccico.dbf
restoring datafile 00028 to /data2/cnp/dmsind.dbf
channel ORA_DISK_1: reading from backup piece /orabkup/db_51kh70je_1_1
ORA-19870: error reading backup piece /orabkup/db_51kh70je_1_1
ORA-19505: failed to identify file "/orabkup/db_51kh70je_1_1"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
failover to previous backup

creating datafile fno=1 name=/data1/cnp/system.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2009 11:34:06
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data1/cnp/system.dbf'


I am unable to restore the hotbackup.

Thanks,

sailesh
Re: rman hotbackup [message #416229 is a reply to message #416219] Fri, 31 July 2009 05:08 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member


>>i have taken a hotbackup from the production database n want to restore it on the test db. I

Have you taken RMAN Backup? If yes post your backup script

>>I am unable to restore the hotbackup.

Post your complete restore script

What's your database version (4 digit version)

Thanks
Re: rman hotbackup [message #416244 is a reply to message #416219] Fri, 31 July 2009 06:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10613
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It could be useful if you can post the backup script.
Make sure you are backing the archivedlogs after control.
Are both the databases in same machine?
Re: rman hotbackup [message #416270 is a reply to message #416244] Fri, 31 July 2009 07:33 Go to previous message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi,

Please see the error. I have been able to resolve the last problem. Please see the error i am getting now.

RMAN> catalog backuppiece '/orabkup/c-66200643-20090731-00';

cataloged backuppiece
backup piece handle=/orabkup/c-66200643-20090731-00 recid=230 stamp=693678435

RMAN> catalog backuppiece '/orabkup/6vklg5sq_1_1';

cataloged backuppiece
backup piece handle=/orabkup/6vklg5sq_1_1 recid=231 stamp=693678453

RMAN> catalog backuppiece '/orabkup/6tklg42r_1_1';

cataloged backuppiece
backup piece handle=/orabkup/6tklg42r_1_1 recid=232 stamp=693678478

RMAN> catalog backuppiece '/orabkup/db_6uklg42v_1_1';

cataloged backuppiece
backup piece handle=/orabkup/db_6uklg42v_1_1 recid=233 stamp=693678495

RMAN> restore database;

Starting restore at 31-JUL-09
using channel ORA_DISK_1

creating datafile fno=1 name=/data1/cnp/system.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/31/2009 16:28:32
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/data1/cnp/system.dbf'

Moreover, it is not a permission problem, as i can touch a file on the directory. futhermore, the system file is here.

Thanks,

Sailesh
Previous Topic: Incrementally updated backups
Next Topic: How to take rman level 0 backup into different location
Goto Forum:
  


Current Time: Fri Apr 18 00:19:59 CDT 2014

Total time taken to generate the page: 0.09055 seconds