Drop & recreate temp tablespace while creating logical stby db
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Jul 2004 09:29:57 -0400
Dear List,
Is there any particular reason why do we have to drop and recreate temporary
tablespace while creating logical stby db?
The document says as below..
4.2.16 Create a New Temporary File for the Logical Standby Database
The temporary files, which were included as a part of the closed backup
operation on the primary database, are not viable on the logical standby
database. (It is not necessary to copy temporary files from the primary
database to the logical standby database.)
To identify and drop obsolete temporary files, perform the following steps
on the logical standby database.
Step 1 Identify the current temporary files.
On the logical standby database, issue the following query to identify the
current temporary files for the standby database:
SQL> SELECT * FROM V$TEMPFILE;
no rows selected
If this query returns "no rows selected" as shown in the example, skip step
2 and go to step 3.
Step 2 Drop each current temporary file from the standby database.
Drop each current temporary file from the standby database, as follows:
SQL> ALTER DATABASE TEMPFILE 'tempfilename' DROP;
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Drop & recreate temp tablespace while creating logical stby db
