Home » RDBMS Server » Backup & Recovery » RMAN hotbackup
RMAN hotbackup [message #402232] Fri, 08 May 2009 02:50 Go to next message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

Before taking an RMAN hotbackup, i have done a resync catalog on my catalog database from my production db.

Then i have taken a hotbackup on the production db. The backup ends successfully.

the problem is when i am restoring on my standby db, the new tablespaces that i created on the production db is not present. But during the backup process, the new tablespaces were included.

May be each time, it is referencing to an old controlfile.

Please help.


Sailesh
Re: RMAN hotbackup [message #402236 is a reply to message #402232] Fri, 08 May 2009 02:58 Go to previous message
sailesh
Messages: 72
Registered: September 2007
Location: MAURITIUS
Member
Hi all,

please see my logs:

RMAN> run
2> {
3> backup current controlfile for standby;
4> backup database format '/orabkup/db_%U';
5> backup current controlfile for standby;
6> }
7> exit
Starting backup at 08-MAY-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=970 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-MAY-09
channel ORA_DISK_1: finished piece 1 at 08-MAY-09
piece handle=/orabkup/4tkeg06l_1_1 tag=TAG20090508T050004 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-MAY-09

Starting backup at 08-MAY-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=/data2/cnp/cnp.dbf
input datafile fno=00016 name=/data1/cnp/rocdata.dbf
input datafile fno=00007 name=/data1/cnp/cnpind.dbf
input datafile fno=00017 name=/data1/cnp/rocind.dbf
input datafile fno=00001 name=/data1/cnp/system.dbf
input datafile fno=00020 name=/data1/cnp/users01.dbf
input datafile fno=00003 name=/data1/cnp/sysaux01.dbf
input datafile fno=00019 name=/data1/cnp/undotbs1.dbf
input datafile fno=00005 name=/data1/cnp/cms.dbf
input datafile fno=00027 name=/data1/cnp/mccico.dbf
input datafile fno=00002 name=/data1/cnp/undotbs2.dbf
input datafile fno=00026 name=/data1/cnp/mast.dbf
input datafile fno=00014 name=/data1/cnp/portalind.dbf
input datafile fno=00023 name=/data1/cnp/xdb.dbf
input datafile fno=00008 name=/data1/cnp/cwmlite.dbf
input datafile fno=00011 name=/data1/cnp/indx.dbf
input datafile fno=00018 name=/data1/cnp/tools.dbf
input datafile fno=00009 name=/data1/cnp/drsys.dbf
input datafile fno=00012 name=/data1/cnp/odm.dbf
input datafile fno=00024 name=/data2/cnp/bankdata.dbf
input datafile fno=00025 name=/data2/cnp/bankind.dbf
input datafile fno=00004 name=/data2/cnp/arch.dbf
input datafile fno=00013 name=/data2/cnp/portal.dbf
input datafile fno=00010 name=/data2/cnp/eur1.dbf
input datafile fno=00021 name=/data2/cnp/wlportal.dbf
input datafile fno=00015 name=/data2/cnp/dmsdata.dbf
input datafile fno=00028 name=/data2/cnp/dmsind.dbf

input datafile fno=00022 name=/data2/cnp/wlportalind.dbf
channel ORA_DISK_1: starting piece 1 at 08-MAY-09
channel ORA_DISK_1: finished piece 1 at 08-MAY-09
piece handle=/orabkup/db_4ukeg06o_1_1 tag=TAG20090508T050008 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:29:07
Finished backup at 08-MAY-09

Starting backup at 08-MAY-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including standby control file in backupset
channel ORA_DISK_1: starting piece 1 at 08-MAY-09
channel ORA_DISK_1: finished piece 1 at 08-MAY-09
piece handle=/orabkup/4vkeg1td_1_1 tag=TAG20090508T052916 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-MAY-09

Starting Control File Autobackup at 08-MAY-09
piece handle=/orabkup/c-66200643-20090508-00 comment=NONE
Finished Control File Autobackup at 08-MAY-09


The one in BOLD is the newly created tablespaces.

here is the logs fro recovery, where the newly created tablespaces are missing:

SUN1@ORLEAN#rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Fri May 8 11:25:42 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: CNP (DBID=66200643, not open)

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

using target database control file instead of recovery catalog
cataloged backuppiece
backup piece handle=/orabkup/c-66200643-20090507-00 recid=89 stamp=686316387

RMAN> catalog backuppiece '/orabkup/4rkeecfv_1_1';

cataloged backuppiece
backup piece handle=/orabkup/4rkeecfv_1_1 recid=90 stamp=686316503

RMAN> catalog backuppiece '/orabkup/db_4qkeeanp_1_1';

cataloged backuppiece
backup piece handle=/orabkup/db_4qkeeanp_1_1 recid=91 stamp=686316543

RMAN> catalog backuppiece '/orabkup/4pkeeanl_1_1';

cataloged backuppiece
backup piece handle=/orabkup/4pkeeanl_1_1 recid=92 stamp=686316574

RMAN> restore database;

Starting restore at 08-MAY-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1644 devtype=DISK

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 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
channel ORA_DISK_1: reading from backup piece /orabkup/db_4qkeeanp_1_1


Previous Topic: Incomplete Recovery -- until cancel
Next Topic: obtaining last SCN generated for crashed database ?
Goto Forum:
  


Current Time: Wed Dec 07 16:16:12 CST 2016

Total time taken to generate the page: 0.06717 seconds