Adding datafile on standby database Manually.

Adding datafile on standby database Manually.

firstly we add datafile on primary server.

SQL> alter tablespace swati_ARCHIVE add datafile '/crd04/oracle/joshi/data/swati_ARCHIVE10.dbf'size 1G;

Tablespace altered.

2-But file _mangement is not auto  in standby,so we need add in manually.
3connect to rman

[oracle@nano ~]$ rman target/

Recovery Manager: Release 10.2.0.4.0 - Production on Sun Jan 4 02:17:24 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: joshi (DBID=382866142, not open)

4. RMAN> report schema;

using target database control file instead of recovery catalog
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema

48   1024     PART102              ***     /crd04/oracle/joshi_DG/data/part_v102_2.dbf
49   1024     PART102              ***     /crd03/oracle/joshi_DG/data/part_v102_2.dbf
50   0        swati_ARCHIVE       ***     /oracle/product/10.2.0/db_1/dbs/UNNAMED00050
51   4096     swati_ARCHIVE       ***     /crd03/oracle/joshi_DG/data/swati_ARCHIVE008.dbf
52   4096     OUTLN                ***     /crd04/oracle/joshi_DG/data/OUTLN001.dbf
53   2048     UNDOTBS1             ***     /crd02/oracle/joshi_DG/data/undotbs07.dbf


5.Then you can rename the datafile to what you like with the following SQL:

SQL> alter database create datafile
'/oracle/testdev/product/10.2.0.1/dbs/UNNAMED00012'
as
'/oradata/testdev/dbs/ucsc_dev01.dbf';

6.At last restart mrp process.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;