RE: RMAN duplicate RAC to single instance - how to not duplicate redo threads and temp tablspace

Not sure about the threads of redo BUT regarding:

" Also, I wondered if it was possible to have the duplicate NOT create the TEMP tablespace as part of the duplicate?"

1. Set your UNTIL TIME to a *future* date and the RMAN duplicate will "fail" at the end
2. At this point your auxiliary database is an exact copy of your target database (DBID and all)
3. Now, if you don't use an RMAN catalog, the DBID is not a problem but if you *do* use an RMAN catalog and both the TARGET & AUXILIARY database are going to be stored in the catalog, then you *must* use NID to change the DBID of the AUXILIARY db - the one you created. To do this: 1. set (or export) ORACLE_SID=SID_NAME 2. Mount database 3. nid target=/ 4. Follow prompts and open database resetlogs;
4. At this point you have 0 temp tablespace data files
5. The TEMP tablespace is still part of the database however so you can a.) add datafiles to the tablespace, or b.) drop and recreate the tablespace as you want
6. To add datafiles to the temp tablespace after this approach (but I think the file has to exist - not sure if a touch/fsutil command would work here though): ALTER TABLESPACE TEMP ADD TEMPFILE '/filesystem/filename.dbf' SIZE 1000M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE 8000M ;
7. Probably you would want to drop/recreate the temp tablespace with the size you want.

HTH Chris Taylor

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of neil campbell Sent: Wednesday, March 28, 2012 12:01 AM To: Oracle List
Subject: RMAN duplicate RAC to single instance - how to not duplicate redo threads and temp tablspace

Hi all,

Using 11.2.0.2 and trying to work out if I can do an RMAN duplicate from 4 node RAC to single instance without the duplicate generating the 4 threads of redo?

Also, I wondered if it was possible to have the duplicate NOT create the TEMP tablespace as part of the duplicate?

I am running the duplicate as part of an automated script, and it is a simple statement as follows

     duplicate database PROD to TEST pfile='/u01/app/oracle/test/pfile.test' backup location='/orabackup'

This works very well, but the reason behind the requirement to not create additional threads and TEMP tablespace is the limited amount of space in the TEST environment at the moment. Removing the threads and TEMP tablespace would free up 48 Gb as the test environment doesn't run the batch jobs that use all that TEMP space.

Open to suggestions...

Thanks
Neil                                                

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Mar 28 2012 - 06:56:32 CDT