@sandeep not sure with windows path. if you need ...

2010-03-11T14:57:44.229+07:00

@sandeep

not sure with windows path.
if you need to catallog specific backup piece(this is ). you can...

CATALOG BACKUPPIECE '\\localstandby\RAC_BACKUP\';

reference:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta011.htm

Yes as i described , RMAN doesn't copy the fi...

2010-03-11T14:01:57.697+07:00

Yes as i described ,

RMAN doesn't copy the files into the server before restoring them as i assumed earlier

This is a Windows 2003 environment.
The path provided has following naming convention:

\\\
so

\\orant\RAC_BACKUP\

server_name=orant
folder_name=RAC_BACKUP

this is the place where we take our RMAN

@sandeep you have to copy backupset to standby on ...

2010-03-11T03:35:17.751+07:00

@sandeep
you have to copy backupset to standby on \\orant\rac_backup\ PATH

just make folder ... .

@Ramanath
you should have 10.2.0.1 on destination

Or try to
SQL>alter database open resetlogs upgrade;
and then run

@catupgrd.sql
@utlrp.sql

read about upgrade database (readme.html) in PATCH Folder.

Yes, there is a version mismtach with the database...

2010-03-11T01:50:08.197+07:00

Yes, there is a version mismtach with the databases.

Sources - 10.2.0.1
Destination - 10.2.0.4

Is there any way that we can bypass and proceed with the clone.

Thanks for a quick response.

Regards,
Madhu Karthik

Yes, even i verified and observed that the version...

2010-03-11T01:46:57.869+07:00

Yes, even i verified and observed that the versions of the databases are different.

Source - 10.2.0.1
Destination - 10.2.0.4

But is there any way that we can bypass and clone it further.

Thanks a lot for your quick response

Regards,
Madhu Karthik

RMAN> show all 2> ; RMAN configuration para...

2010-03-10T20:17:20.458+07:00

RMAN> show all
2> ;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 15 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\\orant\RAC_BACKUP\%F';

SQL> select path, free_mb,total_mb,state from v...

2010-03-10T20:05:31.774+07:00

SQL> select path, free_mb,total_mb,state from v$asm_disk where group_number in (
select group_number from v$asm_diskgroup where name='UNDO');

PATH
--------------------------------------------------------------------------------

FREE_MB TOTAL_MB STATE
---------- ---------- --------
\\.\ORCLDISKUNDO0
18081 21508 NORMAL
<

What about Oracle version on production (HOTBACKUP...

2010-03-10T17:51:13.529+07:00

What about Oracle version on production (HOTBACKUP) and CLONDB?

Oracle should be similar version.

Or make sure HOTBACKUP, that is oracle version in the same on clonedb...

Please check.

Good Luck

Hi Surachart, I am doing the cloning of a databas...

2010-03-10T17:41:07.383+07:00

Hi Surachart,

I am doing the cloning of a database from HOTBACKUP.
Able to create teh controlfile and then recover the database successfully.

but there after when i try to open the database with resetlogs option it is failing with the message
"SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092

2 -3 choices 1. make +UNDO diskgroup has enough s...

2010-03-10T15:22:00.073+07:00

2 -3 choices
1. make +UNDO diskgroup has enough space.
- resize undo datafiles
- move undo datafile to another DISKGROP
- check files in +UNDO diskgroup, drop/move/....

2. add disk to +UNDO diskgroup.'

3. Duplicate database, make newname undo files to other asm diskgroups.

Good Luck

One more thing I would like to let you know. RMAN...

2010-03-10T15:13:12.637+07:00

One more thing I would like to let you know.

RMAN> report schema
2> ;

Report of database schema

List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1024 SYSTEM *** +DATA/orc1/

>ASMCMD> cd datafile >ASMCMD> ls >M...

2010-03-10T14:40:27.663+07:00

>ASMCMD> cd datafile
>ASMCMD> ls
>MHDORA0.261.652294143
>UNDOTBS1.257.652291953
>UNDOTBS1.260.652293001
>UNDOTBS1.267.713189713
>UNDOTBS2.258.652292093
>UNDOTBS2.259.652293001

Can you migrate some datafiles to other DISKGROUPs?

Example:
http://surachartopun.com/2009/10/

Hi Surachart, This is my structure now. ASMCMD&g...

2010-03-10T13:09:22.947+07:00

Hi Surachart,

This is my structure now.

ASMCMD> pwd
+
ASMCMD> cd UNDO
ASMCMD> pwd
+UNDO
ASMCMD> cd lsd
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
TEMPFILE/
===========
ASMCMD> cd datafile
ASMCMD> ls
MHDORA0.261.652294143
UNDOTBS1.257.652291953
UNDOTBS1.260.652293001

I can afford to drop and recreate the disk, but wi...

2010-03-10T12:23:24.348+07:00

I can afford to drop and recreate the disk, but will it be safe and not affect my primary(orc1).

> You have to make sure no database files on +UNDO before you'll drop/recreate.

If adding disk is the only option ... what is the procedure as the SYSTEM ADMIN tasks also will be done by me :( and I'm a newbie in ASM.)

> You should ask system admin

Hi Surachart, Appreciate the quick response. Thes...

2010-03-10T11:25:45.277+07:00

Hi Surachart,
Appreciate the quick response.

These are the result of the queries you asked for :

Yes you are right !! Redundancy is External.

SQL> select name, total_mb, free_mb, required_mirror_free_mb, usable_file_mb ,ty
pe from v$asm_diskgroup where name='UNDO';

NAME TOTAL_MB FREE_MB

We will point at +UNDO Disk Group. I think you are...

2010-03-09T20:12:39.361+07:00

We will point at +UNDO Disk Group. I think you are using External redundancy.

From your query, that show FREE_MB=0

Your ASM Disk Group Full (UNDO)

please query

select name, total_mb, free_mb, required_mirror_free_mb, usable_file_mb ,type from v$asm_diskgroup where name='UNDO';

i'd like to make sure UNDO full...

Another

Hi Surachart, Thanks a lot for sharing the inform...

2010-03-09T19:42:54.246+07:00

Hi Surachart,

Thanks a lot for sharing the information.

I have a similar situation.
I was trying to create Physical Standby Database using
RMAN DUPLICATE command.. and i encountered

creating datafile fno=2 name=+UNDO
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK

Comments on Surachart Opun's Blog: ORA-15041 - ASM Disk Group Unbalanced