OraFAQ Forum: Backup & Recovery » Rman Duplicate database issue

Home » RDBMS Server » Backup & Recovery » Rman Duplicate database issue (Oracle 10.2.0.4 Solaris 10)

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

Rman Duplicate database issue [message #450743]

Fri, 09 April 2010 01:15

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi Experts,
I need your guidance in one of the issue.
We need to duplicate database using RMAN duplicate command on ASM disks. We are having source database of around 600G size out of that 200G is of temp size. We need to restore the database to a diskgroup of size 450G.
We can skip normal tablespaces, but not able to find any option to skip temp tablespace.
Can you please suggest me some possible solution?
We are thinking to create the temporary tablespace on another diskgroup if not able to skip the temporary tablespace.
Thanks in advance for your guidance & suggestions.

Regards
Lalit

Report message to a moderator

Re: Rman Duplicate database issue [message #450744 is a reply to message #450743]

Fri, 09 April 2010 01:25

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Temp files are not backed up by RMAN.

Regards
Michel

Report message to a moderator

Re: Rman Duplicate database issue [message #450756 is a reply to message #450743]

Fri, 09 April 2010 02:04

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Great Thanks Michel for the reply.
I know that the temp files or temp tablespace is not backed up by RMAN.
But when we are duplicating the database, RMAN creates the temp files with the same size as of the backup of source database.
So, Just wondering, whether it will possible to skip that tablespace.

Regards
Lalit

Report message to a moderator

Re: Rman Duplicate database issue [message #450758 is a reply to message #450756]

Fri, 09 April 2010 02:09

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Maybe you could drop the files in source database and recreate them after duplicate.

Regards
Michel

Report message to a moderator

Re: Rman Duplicate database issue [message #450774 is a reply to message #450743]

Fri, 09 April 2010 02:55

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Thanks Michel for the prompt reply.
I will try this solution. But i guess it might not work for us as the source database is used in parallel. And without temp tablespace on source DB, we might be in big trouble as lot of operations going on source.

Regards
Lalit

Report message to a moderator

Re: Rman Duplicate database issue [message #450781 is a reply to message #450774]

Fri, 09 April 2010 03:15

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

And without temp tablespace on source DB, we might be in big trouble as lot of operations going on source.

Temp tablespace is only used if you have big sort or temporary table.
During the duplicate you could increase the "%size" parameters to allow more statements to run in memory.

Are you sure you can't skip your temporary tablespace, documentation says:

Quote:

You can exclude tablespaces from the duplicate database with the SKIP TABLESPACE clause. You can exclude any tablespace except the SYSTEM tablespace or tablespaces containing rollback or undo segments.

Regards
Michel

Report message to a moderator

Re: Rman Duplicate database issue [message #450788 is a reply to message #450743]

Fri, 09 April 2010 03:42

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi Michel,
Thanks for your suggestion. Once again valuable suggestion Smile

But we are doing lot of sort operations along with DML activities on the source database. So, i guess increasing %size might not fulfill our requirement of temp TS.
And regading the docs, i tested to skip temp tablespace but end up with errors Sad

Regards
Lalit

Report message to a moderator

Re: Rman Duplicate database issue [message #453226 is a reply to message #450743]

Wed, 28 April 2010 00:02

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi All,
Today i tested to skip temporary tablespace. I end up with the below error:

Code: [Select all] [Show/ hide]

released channel: aux12
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/27/2010 21:31:23
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "TEMP02"

While the temporary tablespace exist in the database.

Code: [Select all] [Show/ hide]

SQL>select tablespace_name from dba_temp_files;
TEMP02
TEMP02
TEMP02

The script i am using is having syntax:

Code: [Select all] [Show/ hide]

SKIP TABLESPACE TEMP02

Thanks in advance for your valuable time.

Regards
Lalit

Report message to a moderator

Re: Rman Duplicate database issue [message #455453 is a reply to message #453226]

Tue, 11 May 2010 11:41

mdba
Messages: 2
Registered: August 2009
Location: UK

Junior Member

Hi,

Can you please make sure DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT are not set and any other initialization parameters that end in _DEST, such as DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_DEST_n, to reference +DISK1 (The diskgroup)

If the nswer is yes ....then

Is the syntax that you are using is like as below -

RMAN> DUPLICATE TARGET DATABASE TO dupdb
LOGFILE GROUP 1 ('+DISK1','+DISK1') SIZE 200K,
GROUP 2 ('+DISK1','+DISK1') SIZE 200K;

If not can you please post the rman script that you are using for duplicating.

Regards,
mdba

Report message to a moderator

Re: Rman Duplicate database issue [message #455791 is a reply to message #450743]

Thu, 13 May 2010 01:08

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi mdba,
I have to set db_file_name_convert because we are refreshing the database onto the other server and on other diskgroup name.
But i am not setting the log_file_name_convert parameter, instead i am creating logfiles during rman dudplicate database command. As we are working on ASM, i faced issues by using log_file_name_convert.

Part of the script is below:

Code: [Select all] [Show/ hide]

duplicate target database to fs90stg
skip tablespace temp01
logfile
group 1 ('+DATA05/fs90stg/ONLINELOG/redo_0101.log','+DATA01/fs90stg/ONLINELOG/redo_0102.log') SIZE 500M REUSE,
group 2 ('+DATA05/fs90stg/ONLINELOG/redo_0201.log','+DATA01/fs90stg/ONLINELOG/redo_0202.log') SIZE 500M REUSE,
group 3 ('+DATA05/fs90stg/ONLINELOG/redo_0301.log','+DATA01/fs90stg/ONLINELOG/redo_0302.log') SIZE 500M REUSE,
group 4 ('+DATA05/fs90stg/ONLINELOG/redo_0401.log','+DATA01/fs90stg/ONLINELOG/redo_0402.log') SIZE 500M REUSE,
group 5 ('+DATA05/fs90stg/ONLINELOG/redo_0501.log','+DATA01/fs90stg/ONLINELOG/redo_0502.log') SIZE 500M REUSE,
group 6 ('+DATA05/fs90stg/ONLINELOG/redo_0601.log','+DATA01/fs90stg/ONLINELOG/redo_0602.log') SIZE 500M REUSE;
}

Regards
Lalit

Report message to a moderator

Previous Topic:	ASMCA Help
Next Topic:	Error after moving a datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 10 10:56:34 CDT 2025