standby

[ams-jamali]

Hi Rey, I used as

SQL> alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
2 as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

I have checked status in v$datafile and rechecked the path everything is correct.What to do further?

[reydp]

you need to copy the file from prod, before executing the sql.

[ams-jamali]

I did as you said(copied from prod to stdby),but same err.


SQL> alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
2 as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

[reydp]

TRY TO DOUBLECHECK the filename:
alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';

[pareshjavkar]

I guess check parameter standby_file_management parameter in init/spfile of standby instance.

When you set the STANDBY_FILE_MANAGEMENT initialization parameter to AUTO, use of the following SQL statements is not allowed:
· ALTER DATABASE RENAME
· ALTER DATABASE ADD/DROP LOGFILE
· ALTER DATABASE ADD/DROP STANDBY LOGFILE MEMBER
· ALTER DATABASE CREATE DATAFILE AS

SO, if it is AUTO, change it MANUAL and then retry the command.

Thanks

[ams-jamali]

Yes..,File management is set in AUTO mode.
So,I will change in pfile,then i will use this command.

[ams-jamali]

rey.. i have corrected my mistake but results in same err.

alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
as '/mnt/db/oracle/oradata/ISDB/isdata10.dbf'
alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
*
ERROR at line 1:
ORA-01516: nonexistent log file, datafile, or tempfile
"/mnt/db/oracle/oradata/ISDB/isdata11.dbf"

then used
alter system set standby_file_management='manual'
then
show parameter standby
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest string /mnt/backup/arch
standby_file_management string manual

then i did the above process...
but same error.

[waitecj]

Do me a favour:

$ cd /mnt/db/oracle/oradata/ISDB

$ ls -ltr isdata11.dbf

[pareshjavkar]

Do me a favour:

$ cd /mnt/db/oracle/oradata/ISDB

$ ls -ltr isdata11.dbf

I bet its not there, that is what the error states ...

[waitecj]

I bet its not there, that is what the error states ...

Indeed.