-
hi,
Sorry..!,
Specifying the path to spfile for productiondb to bounce(which is in remote).
-
Hi all,
I have checked my standby,whether it is working properly.I opened in read only mode.It showed err as..
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/ISPRO20/system01.dbf'
In the mean time my friend added a datafile in productionDB.(Actually he was doing that,I just verified standby,it shows err.What to do we don't know)
pls help us..
Last edited by ams-jamali; 03-02-2007 at 12:09 AM.
Reason: to increase details
-
create also the datafile in the standby db, before applying the arch logs.
---------------
-
startup mount the standby db,
alter database create datafile '/folder/.../datafilename.dbf';
---------------
-
hi,
I was not able to create datafile, i used
SQL> alter tablespace USRDATA add datafile
2 '/mnt/db/oracle/oradata/USDB/isdata11.dbf'
3 size 2000M autoextend on next 200 maxsize unlimited;
alter tablespace ISHDATA add datafile
*
ERROR at line 1:
ORA-01109: database not open
SQL> select status from v$instance;
STATUS
------------
MOUNTED
Pls help further.
-
alter database create datafile.....
---------------
-
I want to add datafile to that particular tablespace
So i did as
SQL> alter database create datafile '/mnt/db/oracle/oradata/USDB/isdata11.dbf'
2 size 2000M autoextend on next 200 maxsize unlimited as URSDATA;
alter database create datafile '/mnt/db/oracle/oradata/ISPRO20/ishdata11.dbf'
*
ERROR at line 1:
ORA-02000: missing AS keyword
Is there any way to create datafile file first and then add that file to tablespace.If so specify.
Last edited by ams-jamali; 03-02-2007 at 02:32 AM.
Reason: to increase details
-
it's basically like:
alter database create datafile '/folder/.../dfilename.dbf'
as
'/folder/.../dfilename.dbf';
try to experment with the syntax, there's no harm.
I'll try to see docs, or others may post the SYNTAX.
---------------
-
hi all,
can any one help me to this above senario.I want to create a file with autoextend on and add that dbf file to particular tablespace.If i create now, will it show any err.
-
it is only the file structure(physical) that is important to your standby database. You don't need to add datafile properties like autoextend etc...
create the datafile as specified above.
---------------
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
|