Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Standby - Technical > Dbvisit Standby - Technical Questions or Issues

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 01-23-2008, 07:34 AM
Geofrey Rainey Geofrey Rainey is offline
Banned
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 4
Default Adding multiple datafiles to the primary database

Dbvisit has a current limitation that only one data file can be added per time. If you want to add more than one datafile to the primary database, then run Dbvisit on the primary database between adding datafiles.

For example (on the primary):
Step 1: Add datafile 1
Step 2: Run dbvisit on the primary to propagate the changes.
Step 3: Add datafile 2

When encountered the following error in standby database:

SQL> recover standby database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 16 is unknown - rename to correct file
ORA-01110: data file 16: '/opt/oracle/product/10g/db/dbs/UNNAMED00016'
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01111: name for data file 16 is unknown - rename to correct file
ORA-01110: data file 16: '/opt/oracle/product/10g/db/dbs/UNNAMED00016'

Two datafiles were added to the primary database:
+DG1/w112p/datafile/w112_data_3_01.dbf and +DG1/w112p/datafile/w112_data_3_02.dbf.

Datafile w112_data_3_02.dbf was created successfully by Dbvisit in ASM on the standby database.

To add the second datafile to the standby database. Run the following SQL command on the standby database:

SQL> alter database create datafile '/opt/oracle/product/10g/db/dbs/UNNAMED00016' as '+DG1/w112p/datafile/w112_data_3_01.dbf';

Add the following SQL to the standby database (for Oracle version 10g and higher) to ensure multiple datafiles are added to the standby database:
SQL> alter system set STANDBY_FILE_MANAGEMENT = auto;

Last edited by Arjen Visser; 01-12-2010 at 07:36 PM.
Reply With Quote
  #2  
Old 07-04-2009, 07:43 AM
Mike Donovan Mike Donovan is offline
Dbvisit Team
 
Join Date: May 2008
Posts: 201
Default RE: Adding multiple datafiles to the primary database

For step by step instructions on how to work through this process please see the Solution section in the following post:

http://www.dbvisit.com/forums/showthread.php?t=190
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 10:53 AM.