Answer / lalit rana

The strategy which I follow is that I will keep one big
unwanted file (1 GB) size in /oracle/<SID>/oraarch
directory. So that incase the archive struck happens I can
immediate delete the 1 GB file and I get 1GB of space
instanteously for some time and get some time to think for
a permanentely. Or simple solution is if you have space on
disk then increase the size of your mount
point /oracle/<SID>/oraarch .

Answer / deepak

1. (planned)by increasing the space

2. (planned)taking backup

3. moving files to different location


deepak.basis.ua@gmail.com

Answer / m k hazra

have to increase free space in archiving directory.




regards,
manas k hazra

Answer / dnyaneshwar kadam

maintain sufficient free space in ORAARCH directory.

for test execute following sql statement.

SQL> alter system switch logfile;

Answer / ashwin mane

Even you have sufficient free space & you are getting error
regarding oracle archive struck the concern prob. may be
effect of a catche memory. shutdown the instance, clear the
temp, prefetch & restart the system. You can able to
successfully complete the archive.

How you will check whether database is active or not from OS level?

1 Answers  

I am attempting to complete a system copy of bw. When I try to go in to rsa1 afterwards I get the error message, "entry in inbound table already exists." What should I do to solve the problem?

0 Answers  

Hi, I want to import my Transport request from DEV. to Test system (from STMS buffer of DEV.(domain only) but I don’t want Login/PWD screen while importing from DEV to Test System. But I need login/pwd screen while importing TR from Test to PRD system. Presently I have activated all systems as a non trusted systems. If any one has idea please let me know. Thanks in advance! Regards, Raj Chavan.

5 Answers  

User wants lock ASAP then what will u do?

0 Answers  

Why there should be atleast 2 Dialog Wp per instance?

5 Answers   Satyam,

Why we execute SGEN, which Tables it modifies,will it cause DB growth? is it possible to execute SGEN later on after Golive?

0 Answers   IBM,

who is the owner of system files?

7 Answers   Infosys, Volvo,

While applying support packages, the error Table space overflow is occured? What could be done?

3 Answers  

friends ..... i hava a question, i have to assign sm36,3m37,su01 has to assign to a user with only options (display ,create).how can ia assign this to user? need quick reply......

3 Answers   Wipro,

What is ERP?

10 Answers  

After applying snote..If something goes wrong is it possible to deactivate/roll back to last applaid snote....If yes, how?

3 Answers  

How to change default password of EARLY WATCH STEP BY STEP

1 Answers