Home » RDBMS Server » Backup & Recovery » Rman Duplicate database issue (Oracle 10.2.0.4 Solaris 10)
Rman Duplicate database issue [message #450743] Fri, 09 April 2010 01:15 Go to next message
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

Re: Rman Duplicate database issue [message #450744 is a reply to message #450743] Fri, 09 April 2010 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 66638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Temp files are not backed up by RMAN.

Regards
Michel
Re: Rman Duplicate database issue [message #450756 is a reply to message #450743] Fri, 09 April 2010 02:04 Go to previous messageGo to next message
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

Re: Rman Duplicate database issue [message #450758 is a reply to message #450756] Fri, 09 April 2010 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 66638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you could drop the files in source database and recreate them after duplicate.

Regards
Michel
Re: Rman Duplicate database issue [message #450774 is a reply to message #450743] Fri, 09 April 2010 02:55 Go to previous messageGo to next message
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
Re: Rman Duplicate database issue [message #450781 is a reply to message #450774] Fri, 09 April 2010 03:15 Go to previous messageGo to next message
Michel Cadot
Messages: 66638
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Rman Duplicate database issue [message #450788 is a reply to message #450743] Fri, 09 April 2010 03:42 Go to previous messageGo to next message
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
Re: Rman Duplicate database issue [message #453226 is a reply to message #450743] Wed, 28 April 2010 00:02 Go to previous messageGo to next message
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:

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.
SQL>select tablespace_name from dba_temp_files;
TEMP02
TEMP02
TEMP02


The script i am using is having syntax:
SKIP TABLESPACE TEMP02


Thanks in advance for your valuable time.

Regards
Lalit
Re: Rman Duplicate database issue [message #455453 is a reply to message #453226] Tue, 11 May 2010 11:41 Go to previous messageGo to next message
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
Re: Rman Duplicate database issue [message #455791 is a reply to message #450743] Thu, 13 May 2010 01:08 Go to previous message
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:
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
Previous Topic: ASMCA Help
Next Topic: Error after moving a datafile
Goto Forum:
  


Current Time: Tue Oct 15 11:00:24 CDT 2019