@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 files ...

2010-03-11T14:01:57.696+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.196+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 parameters...

2010-03-10T20:17:20.457+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$as...

2010-03-10T20:05:31.773+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.382+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.636+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 >MHDORA0.261.6522...

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> ...

2010-03-10T13:09:22.946+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.276+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.245+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

@Anand I hope this can help. If it' can not help...

2010-03-06T13:52:40.461+07:00

@Anand

I hope this can help.
If it' can not help.. we might check some bug about "database service" name on oracle support.

YOU ROCK! I had the same problem and dbms_service....

2010-03-06T13:30:50.006+07:00

YOU ROCK!
I had the same problem and dbms_service.stop_service WORKED LIKE A CHARM...

THANK YOU VERY MUCH DUDE>>.

-Anand

@Martha flash_cache in 11gR2 supports on OEL or S...

2010-03-06T00:41:50.708+07:00

@Martha

flash_cache in 11gR2 supports on OEL or Solaris only

If you need to test it on RHEL. Please send email to me, I'll send some step to figure out it on RHEL.

surachart at gmail dot com
-)

Surachart - I'm having difficulty following the n...

2010-03-06T00:37:13.732+07:00

Surachart -
I'm having difficulty following the necessary steps in order to enable the flash_cache in 11gR2 for Red Hat. Can you provide the list of steps you followed in order to enable it?

Thank you for the post...very interesting!

Martha Centeno

Thank You @Santosh , @Biggy2day

2010-03-05T16:38:40.963+07:00

Thank You @Santosh , @Biggy2day

Congratulation!

2010-03-05T16:32:50.257+07:00

Congratulation!

Kevin Closson (http://kevinclosson.wordpress.com) ...

2010-03-04T22:36:26.700+07:00

Kevin Closson (http://kevinclosson.wordpress.com) helped me for idea.

About Oracle ACE, that's the beginning. I still to learn + improve skills more...

-)

Hey, thanks for this demo, it's really useful and ...

2010-03-04T21:50:57.392+07:00

Hey, thanks for this demo, it's really useful and congratulations for becoming Oracle ACE!

Regards,
Sve

Surachart Opun's Blog

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

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

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

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

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

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

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

What about Oracle version on production (HOTBACKUP...

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

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

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

>ASMCMD> cd datafile >ASMCMD> ls >MHDORA0.261.6522...

Hi Surachart, This is my structure now. ASMCMD> ...

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

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

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

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

@Anand I hope this can help. If it' can not help...

YOU ROCK! I had the same problem and dbms_service....

@Martha flash_cache in 11gR2 supports on OEL or S...

Surachart - I'm having difficulty following the n...

Thank You @Santosh , @Biggy2day

Congratulation!

Kevin Closson (http://kevinclosson.wordpress.com) ...

Hey, thanks for this demo, it's really useful and ...