-
I did what u said.. here is the output
-rw-r----- 1 oracle oinstall 2592768 2007-03-08 23:48 ctrl.ctl
-rw-r--r-- 1 oracle oinstall 20975616 2007-03-07 00:28 drsys01.dbf
-rw-r--r-- 1 oracle oinstall 152702976 2007-03-07 00:28 example01.dbf
-rw-r--r-- 1 oracle oinstall 26218496 2007-03-07 00:28 indx01.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata01.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata02.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata03.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata04.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata05.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata06.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata07.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata08.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isdata09.dbf
-rw-r----- 1 oracle oinstall 5075111936 2007-03-07 00:28 isdata10.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-05 22:37 isdata11.dbf
-rw-r----- 1 oracle oinstall 2621444096 2007-03-07 00:28 isindx015.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx01.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx02.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx03.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx04.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx05.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx06.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx07.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx08.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx09.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx10.dbf
-rw-r----- 1 oracle oinstall 2097156096 2007-03-07 00:28 isindx11.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx12.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx13.dbf
-rw-r----- 1 oracle oinstall 1992298496 2007-03-07 00:28 isindx14.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx16.dbf
-rw-r----- 1 oracle oinstall 1468010496 2007-03-07 00:28 isindx17.dbf
-rw-r--r-- 1 oracle oinstall 20975616 2007-03-07 00:28 odm01.dbf
-rw-r----- 1 oracle oinstall 209719296 2007-03-07 00:28 perfstat.dbf
-rw-r--r-- 1 oracle oinstall 356519936 2007-03-07 00:28 system01.dbf
-rw-r--r-- 1 oracle oinstall 10489856 2007-03-07 00:28 tools01.dbf
-rw-r----- 1 oracle oinstall 838864896 2007-03-07 00:28 undotbs.dbf
-rw-r--r-- 1 oracle oinstall 209719296 2007-03-07 00:28 users01.dbf
-rw-r--r-- 1 oracle oinstall 47190016 2007-03-07 00:28 xdb01.dbf
on 07-03-07 i applied archives manually in standby.after that i did
$ cd /mnt/db/oracle/oradata...
$ ls -l
So it is there...
-
what's ur O.S.? version?
/mnt are suppose to be for media device other than disk device.
/mnt/db/oracle/oradata is actually from disk device?
your error says that the file specified can't be seen by your db's controlfile.
---------------
-
-
Version
SuSE Linux - 9.2
Oracle 9i -9.2
-
i have seen your earlier post and your STANDBY_FILE_MANAGEMENT is set to AUTO. The data file should be automatically copied to the standby db when all log files(during the creation of datafile in primary db server) are archive.
---------------
-
can u copy a file from primary db to standby db manually using rcp for example?
---------------
-
I have created file in primary and that (isdata11.dbf ) file was not automatically created in standby so i copied to standby using scp.
So when i applied archive files to standby time-stamp not changed in isdata11.dbf file.So i tried to create that file in standby but it showed error.
Last edited by ams-jamali; 03-09-2007 at 07:14 AM.
Reason: to increase details
-
TRY SETTING:
alter system set standby_file_management='manual';
THEN DO THE DATAFILE thing.
---------------
-
Read This:
Adding a Tablespace and a Datafile When STANDBY_FILE_MANAGEMENT Is Set to AUTO
The following example shows the steps required to add a new datafile to the primary and standby databases when the STANDBY_FILE_MANAGEMENT initialization parameter is set to AUTO.
1. Add a new tablespace to the primary database:
SQL> CREATE TABLESPACE new_ts DATAFILE 't_db2.dbf'
2> SIZE 1m AUTOEXTEND ON MAXSIZE UNLIMITED;
2. Archive the current redo log so it will get copied to the standby database:
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
3. Verify that the new datafile was added to the primary database:
SQL> SELECT NAME FROM V$DATAFILE;
NAME
----------------------------------------------------------------------
F:\ORACLE\ORADATA\FNO\t_db1.dbf
F:\ORACLE\ORADATA\FNO\t_db2.dbf
4. Verify that the new datafile was added to the standby database:
SQL> SELECT NAME FROM V$DATAFILE;
NAME
----------------------------------------------------------------------
F:\ORACLE\ORADATA\FNO\t_db1.dbf
F:\ORACLE\ORADATA\FNO\t_db2.dbf
-
rey.. I have done that already.,but it shows the same problem,refer my previous post in this thread.
I have added datafile in primary and then i checked in standby.It doesn't added automatically so i did manually,but that datafile status shows offline.So,i try to create in standby..,So that control file will be updated and it will take that datafile which i copied from primary.
right now iam applying archive files to standby,it is working but if i try to open in read only it shows following problem.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/mnt/db/oracle/oradata/USDB/system01.dbf'
pls say whether i can rectify or better i could recreate standby.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|