Oracle resize datafile in standby when its in mount stage

Oracle 10.2.0.1
Linux EL5

I have configured standby database for testing. Now i have a problem that my users tablespace in standby got filled and its giving error message like

ORA-01237: cannot extend datafile 4
ORA-01110: data file 4: '/u01/app/oracle/oradata/orcl/users01.dbf'

Now i have to autoextend the datafile 4 in standby.how to do it in mount stage?

When i try to open the database for resizing the datafile, i am getting the below error..

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'

Any other options ? please advice..

TIA,

Oracle resize datafile when database is mount

I need resize datafile when database is mount not open(I recover database).Is it posible? ...

Oracle Resize Datafile

Is it necessary to take a datafile (or it's corresponding tablespace) offline before increasing the size of the datafile (with the ALTER DATABASE databasename DATAFILE '/location/of/datafile.dbf' RESIZE command)? Or can I just resize the datafile without doing anything special? ...

Oracle RESIZE DATAFILE

On Oracle 7.3 can I resize datafile from 1900 Mb to 1500Mb during the db is open? ...

Oracle resize datafile size error

helloplease guide mei have a tablespace that has one datafile this tablespace total size is 60MBand used space in this tablespace is 0.1875MB i want reduce size of this tablespace and i execute this command:ALTER DATABSE DATAFILE 'i:\ora_data\alitbs1f1.dbf' RESIZE 10M;but i receive this error:ORA-03 ...

Oracle Resize datafile or add new?

Good day,I have been reading a few posts on datafiles, but still have a few questions...Running 10g on Windows 2003 (shudder). One of our tablespaces in particular is getting stuffed. I have run the recommended segment adviser utility to compact it however I just need to add space. I have read about ...

Oracle resize datafile?

I want resize from 10Gb to 5Gbyte,because I just delete user schema so it used just 8%, I want to effesiency.Thanks ORA-03297: FILE contains used data beyond requested RESIZE value Details:ALTER DATABASE DATAFILE 'C:\APP\ADMINISTRATOR\ORADATA\IPDB\SYSTEM01.DBF'RESIZE 5120MError AT line 2ORA-03297: F ...

Oracle Resize datafile

I have oracle 10g with ASM running on AIX unix. I over allocated space in one of the tablespace and wanted to resize the data file. But before doing that I want to know the High Water Mark and resize the datafiles accordingly. Can someone tell me how to find the HWM and how to calculate the size bas ...

Oracle add datafile standby (STANDBY_FILE_MANAGEMENT is set to MANUAL)

Assume STANDBY_FILE_MANAGEMENT is set to MANUALandI want to add a datafile to primary database. According to following link:I have to take the tablespace offline,etc..Is there any other way, without taking the tablespace to offline mode. http://download.oracle.com/docs/cd/B10501_01/server.920/a96653 ...

Oracle Can't Resize Datafile

Because the usage rate of disk space is up to 100%, I want to decrease the size of datafile to release disk space. Before resizing, I checked the free space using the following SQL:SELECT A.TABLESPACE_NAME, B.FILE_NAME, SUM(A.BYTES) Free, B.BYTES TotalFROM DBA_FREE_SPACE A, DBA_DATA_FILES BWHERE A.F ...

Oracle Tablespace Datafile Resize ORA-03297

In one of our tablespace constituting 4 datafiles, has got some data which is as follows :SEGMENT_NAME SEGMENT_TYPE ------------------SYS_C004044 INDEXSYS_C004315 INDEXPROJECTRELEASE_INDEX1 INDEXSYS_C0019289 INDEXXAK1WBSHIERARCHY INDEXSYS_IL0000033038C00047$$ LOBINDEXSYS_IL0000033086C00013$$ LOBINDE ...

Oracle Add/resize datafile

Can we add a datafile to an oracle 8.1.7 dictionary managed database while the database is up and running? Can you please brief the steps? Also, can we resize? ...

Oracle Add Datafile in Logical Standby Database

I have add one datafile in our primary RAC DB. We had logical standby database with file management is equal to manual. Both the primary RAC and logical standby db have the different storage structure. When the archive applied on the logical standby database its throws the error " error in creating ...

Oracle Resizing datafile in a Physical Standby

I have created a physical standby db for testing. One of the tests was to resize a dbf on the primary, knowing that the file could not extend on the standby due to space limitations. This has caused arch files not to be applied to the standby db. How is a situation like this resolved? Do I need to r ...

Oracle Resizing datafile in a Physical Standby

I have created a physical standby db for testing. One of the tests was to resize a dbf on the primary, knowing that the file could not extend on the standby due to space limitations. This has caused arch files not to be applied to the standby db. How is a situation like this resolved? Do I need to r ...

Oracle restore datafile to standby database

i have a standby database which use raw devices under solaris 9.and a primary database which use filesystem under solaris 9 too.recently i have a problem which is nologging issue. see ML 290161.1my question is how we know that when restore to raw devices through rman, will it replace file in the raw ...

Oracle Temp file information on mount stage

I am restored cold backup.recreate controlfile.now i am on mount stage.while creating controlfile there is no tempfile mentioned.but when i am doing alter database open it is asking for temp tablespace.in controlfile there is no informationfor tempfile as i recreated.Can you please tell me where fro ...

Oracle cann't resize datafile in 10g

i am facing this problem:the size of datafile '+DG1/orcl/datafile/erp01.dbf' is 8798m.but only 4822m(54.81%) was in use.so i want to resize this datafile to smaller size:SQL> alter database datafile '+DG1/orcl/datafile/erp01.dbf' resize 7000m;ERROR at line 1:ORA-03297: file contains used data bey ...

Oracle syntax to resize datafile in 10g

syntax to resize datafile in 10g ...

Oracle Resize the datafile

I have a partitioned table which have 90 partitions and 64 subpartitions in each partitions.This each 64 subpartitions are placed in the 64 tablespace.my table structureCREATE TABLE CDR (SERVICE_TYPE NUMBER(20,0) NOT NULL,CDR_CATEGORY NUMBER(20,0) DEFAULT 1 NOT NULL,IS_COMPLETE NUMBER(20) NOT NULL,I ...

Oracle lock during resize datafile

During the execution of an "ALTER DATABASE DATAFILE <FILE#> RESIZE <SIZE> " query does Oracle puts some kind of a lock on that datafile or make it unavaliable for use (till the resize is complete) ? Or is it just possible to use the datafile normally during the execution of the "ALTER DA ...

Oracle add or resize datafile

My db is Oracle 8.1.7. Recently I found one of my tablespace is used about to 80%.The tablespace has 3 4g-size-datafile. What should I do ? Add a new datafile or resize the datafiles?Which one better? ...

Unable to Resize datafile Oracle 9i.

I am facing very strange problem in our customer testbed. The customer data file grows to till 8GB having 80 Lac records. We deleted approximately 70Lac records but we are not able to re size the data file. When i checked the free space in the file, it shows 0.Can you please let me know how to re si ...

Oracle Could not resize Datafile

In one of my database, one of the datafile of a tablespace is of size 7.45GB. The used space is 1.18GB and the free space is 6.27 GB. But when I try to resize it to 1.5 GB, it gives error "ORA-03297: file contains used data beyond requested RESIZE value". When I click on minimum size (in TOAD), it s ...

Oracle Relocating datafiles on standby database after mount point on stanby is ful

We have a physical standby database.The location of datafiles on primary database are at /oracle/oradata/ and the location of datafiles on standby database are at /oracle/oradata/Now we are facing a situation of mount mount getting full on standby database so we need to move some tablespaces to anot ...

Oracle Move datafile on Primary not replicted on Standby Database

I'm using an automated script to move datafiles between partitions on my standby database, this ensures that only recent data is on the faster fibre channel disks, and older data is on SATA disks.The commands it uses:1. alter tablepspace offline;2. unix command to mv data file from one partition to ...

Oracle Database still in mount stage after Cold BAckup-Backup Job shows Succeeded

Hi,I have more than 30 databases which I'm managing through Grid Control and created jobs to take the backup from Grid Control only.The recent problem I'm facing is after takeing the Cold backup of the database, the databaseare suppose to be opened which is the last task of the Backup Jobs ,Though t ...

Oracle Drop existing undo tablespace and create a new one at the mount stage

I wish to drop the existing undo tablespace and create a new at the the MOUNT stage.Please guide with the steps. ...

Oracle creating datafile in standby

HiEven STANDBY_FILE_MANAGEMENT is manuel; datafile is always created in standby.If I add a datafile to one of the tablespace in the primary database, I notice that the datafile is also created in standby side like:/oracle/product/9.2.0/dbs/UNNAMED00005 Then I change the name of the datafile :alter d ...

Oracle Standby has no mount point

I am curious about what would happen when i add a datafile in primary database but there is not equivalent mount point at standby. Say the primary is at /u01/test/test01.dbf, What will happen if there is no /u01 at standby. Is it possible to create a mount point at primary with out creating it at st ...