ORA - 01665

Solution

On Primary Database
C:\Windows\system32>sqlplus sys/<password> as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 14 12:31:15 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database create standby controlfile as 'D:\oracle\oradata\sjcstnd\controlfile\stanctl.ctl';
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
On Standby Database
C:\Windows\system32>set oracle_sid=sjcstnd
C:\Windows\system32>sqlplus sys/<password> as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 14 12:31:59 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:\Windows\system32>d:
D:\>cd oracle
D:\oracle>cd oradata
D:\oracle\oradata>dir
 Volume in drive D is Secondary
 Volume Serial Number is 0ABF-0E1D
 Directory of D:\oracle\oradata
21/04/2013  13:06    <DIR>          .
21/04/2013  13:06    <DIR>          ..
21/04/2013  12:50    <DIR>          archive
09/05/2013  09:48    <DIR>          sjcstnd
07/05/2013  14:20    <DIR>          sjctest
               0 File(s)              0 bytes
               5 Dir(s)  433,725,743,104 bytes free
D:\oracle\oradata>cd sjcstnd\controlfile
D:\oracle\oradata\sjcstnd\controlfile>dir
 Volume in drive D is Secondary
 Volume Serial Number is 0ABF-0E1D
 Directory of D:\oracle\oradata\sjcstnd\controlfile
14/05/2013  12:33    <DIR>          .
14/05/2013  12:33    <DIR>          ..
14/05/2013  12:32         7,094,272 control01OLD.ctl
14/05/2013  12:32         7,094,272 control02OLD.ctl
14/05/2013  12:32         7,094,272 control03OLD.ctl
14/05/2013  12:31         7,159,808 STANCTL.CTL
               4 File(s)     28,442,624 bytes
               2 Dir(s)  433,725,743,104 bytes free
D:\oracle\oradata\sjcstnd\controlfile>move STANCTL.CTL CONTROL01.CTL
        1 file(s) moved.
D:\oracle\oradata\sjcstnd\controlfile>COPY CONTROL01.CTL CONTROL02.CTL
        1 file(s) copied.
D:\oracle\oradata\sjcstnd\controlfile>COPY CONTROL02.CTL CONTROL03.CTL
        1 file(s) copied.
D:\oracle\oradata\sjcstnd\controlfile>set oracle_sid=sjcstnd
D:\oracle\oradata\sjcstnd\controlfile>sqlplus sys/<password> as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 14 12:36:15 2013
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount pfile='C:\oracle\product\10.2.0\db_1\database\INITsjcstnd.ora';
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2066080 bytes
Variable Size             385878368 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14708736 bytes
SQL>  create spfile from pfile='C:\oracle\product\10.2.0\db_1\database\INITsjcstnd.ora';
File created.
SQL> shutdown immediate;
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size                  2066080 bytes
Variable Size             385878368 bytes
Database Buffers         1207959552 bytes
Redo Buffers               14708736 bytes
Database mounted.
SQL> alter database recover managed standby database disconnect from session;
Database altered.
SQL>