oracle folder full

[Former Member]

Hi ,

when im doin client copy the oracle/sid/oraarch folder is becoming full

ECC6.0 nonides , database oracle 10g

Free space in c: is 2 gb

free space in drive d: is 160 gb

any alternate solution to change the path.....

thanks&regards

pavankumar

[Former Member · Accepted solution]

Hi guys ,

is it recommended to change parameter

init<SID>.ora file and change parameter:log_archive_dest = <path to D drive>.

im not sure abt it

thanks&reagrds

pavnkumar

[Former Member · Accepted solution]

is it recommended to change parameter

init<SID>.ora file and change parameter:log_archive_dest = <path to D drive>.

It still doesn't solve your problem.

You need to setup your backup/archive routines, if you just change the directory the problem will arise again.

Regarding the comment:

It is always recommended to deactivate log archiving before client copy otherwise it will fill up the archive log destination rapidly with unnecessary. Here is the steps to do that.

No, it is not always recommended.

Logs are indeed created during client copy, but it all depends if you copy a full client or just the customizing. I never switch off logging when performing client copy of customizing and/or users/profiles.

If you environment is setup correctly with brbackup and brarchive, it will work!

Please be aware that the instructions you got for switching the log on and off does not include the database backup. If you switch off the logging mechanism, you get a gap in the logs.

You should always perform a full database backup after the logs have been switched on again.

[Former Member]

You hav not setup your backup routines for the system.

The database archives the logs to this directory.

You have to perform full offline and/or online backups with brbackup and then, on a regular basis archive the logs in oraarch with brarchive.

By looking at your question, I'd say you need to get in contact with an database administrator.

It's not easy to describe the setup in a forum.

As a start, you can read the [SAP Database Guide: Oracle|http://help.sap.com/saphelp_nw70/helpdata/en/42/51b3144a1211d182b80000e829fbfe/frameset.htm].

[Former Member]

Pls check your log_archive% parameters. It will help you to resolve the prob.

[Former Member]

We can deactivate archive logging, please check Note:489690 - CC INFO: Copying large production clients, else if you want to change the destination of archive please check Note: 391.

Regards,

Sreenivas .Y

[Former Member]

It is always recommended to deactivate log archiving before client copy otherwise it will fill up the archive log destination rapidly with unnecessary. Here is the steps to do that.

1) Shutdown the database using Shutdown immediate. SQL> shutdown immediate;

2) Mount the database using startup mount. SQL> startup mount;

3) SQL> Alter database noarchivelog;

4) SQL> Alter database open;

After you finish the client copy activate the archive log.

1) Shutdown the database using Shutdown immediate. SQL> shutdown immediate;

2) Mount the database using startup mount. SQL> startup mount;

3) SQL> Alter database archivelog;

4) SQL> Alter database open;

Rgds,

SK