-
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?
-
you need to copy the file from prod, before executing the sql.
---------------
-
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"
-
TRY TO DOUBLECHECK the filename:
alter database create datafile '/mnt/db/oracle/oradata/ISDB/isdata11.dbf'
as '/mnt/db/oracle/oradata/ISDB/ishdata10.dbf';
---------------
-
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
-
Yes..,File management is set in AUTO mode.
So,I will change in pfile,then i will use this command.
-
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.
-
Do me a favour:
$ cd /mnt/db/oracle/oradata/ISDB
$ ls -ltr isdata11.dbf
Assistance is Futile...
-
Originally Posted by waitecj
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 ...
-
Originally Posted by pareshjavkar
I bet its not there, that is what the error states ...
Indeed.
Assistance is Futile...
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
|