Moving Trace Files To Archive Location?

Aug 20, 2012

I am using Oracle RAC 11gR2.I am planing to move my old trace files to an archive location.

I have the below questions concerning the users and groups used by Oracle RAC when moving the trace files.It is related to the permissions but it is about oracle behavior.

The trace files of database (oracle user) are created as below:

284 -rw-r-----    1 oracle   asmadmin     283571 Aug 20 18:08 PPRD1_mmon_13893716.trc
   4 -rw-r-----    1 oracle   asmadmin        125 Aug 20 18:10 PPRD1_gcr0_11730998.trm
   4 -rw-r-----    1 oracle   asmadmin       2833 Aug 20 18:10 PPRD1_gcr0_11730998.trc
580 -rw-r-----    1 oracle   asmadmin     588489 Aug 20 18:12 PPRD1_lmhb_15859792.trm


when moving the files using the oracle user it will be created as oracle:oinstall and not oracle:asmadmin since asmadmin is not a group of the oracle user.

1. How oracle created my trace and log files with permission oracle:asmadmin?

2. How should I move these files? I moved it using the Oracle user and it was created as oracle:oinstall with Operating system error "unable to duplicate owner and mode after move"

View 5 Replies


Server Administration :: Oracle 10gR2 RAC - Moving Archivelog Location

May 25, 2010

We have oracle 10gR2 RAC with ASM running on HP-UX. The archivelogs are located in a NFS filesystem and we want to move this into ASM.

View 1 Replies View Related

How To Find Previous Path Location Of Archive Log

Apr 15, 2013

Practicing in VM. My question is, I deleted the physical files of the database on Sunday but I'm having physical files backup on Friday. firstly i done restore, Performing incomplete recovery , I'm getting error like "Cannot open Archive log"

On Saturday, I changed path of archive log but I'm not aware of archive previous path location. How can we find previous path location of archive log?

View 6 Replies View Related

Forms :: Copy Files From One Location To Another In 6i

Sep 9, 2008

I want to copy files from one location to another in forms6i on when button pressed.i m using the following code.

cpf_source VARCHAR2(500) := 'c: est.txt';
cpf_target VARCHAR2(500) := 'c:data';

But i press the button it generates FRM-40734,

internal Error : PL/SQL error occurred.

View 5 Replies View Related

Opening Permissions To Trace Files?

Nov 15, 2010

un-documented parameter _trace_files_public / I want to set this to true so my app team can review trace files. better way to proceed to open read permissions for non oracle users.

View 2 Replies View Related

Server Administration :: Moving OMF Files In ASM

Mar 13, 2013

The steps to move OMF files in ASM. I tried the following and was not successful.

RMAN> switch database to copy;

datafile 1 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/system.357.809972853"
datafile 2 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/sysaux.363.809972837"
datafile 3 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs1.365.809972737"
datafile 4 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/users.361.809972859"
datafile 5 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs2.360.809972761"
datafile 6 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs3.359.809972787"
datafile 7 switched to datafile copy "+DATA01/pa01pod_im1l059p/datafile/undotbs4.358.809972811"

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/13/2013 16:30:05
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

RMAN> alter database open;

so switch worked reset logs says can't use it there so I just try to open and it just hangs.

View 1 Replies View Related

SQL & PL/SQL :: Moving Files After Using UTL_FILE Package?

Feb 21, 2013

We have a p/slq procedure that reads a *.txt file using the UTL_FILE package. The contents of the file are then inserted into a database table.

At the end of the procedure we close the open file using UTL_FILE.FCLOSE.

There is a program (non-oracle)that attempts to move the file to a new location after being read into Oracle. The problem is that the application cannot move the file as the file is locked. ie message displays that the file is open and cannot be moved to a new location.

Is there anything else that we are missing besides the UTL_FILE.FCLOSE.

View 5 Replies View Related

Moving Files On Physical Standby Database?

Oct 19, 2011

We're currently in a situation where the primary database server fs size does not match the standby database server fs size.

Standby database filesystem is almost 100% utilized, and we suggested to move some of the datafiles first to avoid threshold alerts and archive gaps.

Now, if we're gonna move datafiles on the physical standby, I believe the process would be stop managed redo apply -> shutdown standby -> OS move -> startup mount -> alter rename -> start managed redo apply. Is this correct? If not, how?

Also, would it have an effect if the controlfiles of primary and standby do not match because of the movement?

View 1 Replies View Related

RMAN :: Moving Backup Files From Disk

Jul 18, 2013

Accidentally without checking the channel allocation I have given the backup archivelog from sequence until sequence with delete input. This backup piece went to the disk but it should go to Tape.I know that we can catalog this backup piece but I want to move this backup files in disk to Tape using RMAN. Is there anyway or I have to lie with Backup team or OS team for this file movement?

View 4 Replies View Related

Write PL/Sql Stored Procedure To Move Files From One Location To Another?

May 17, 2007

I need to write a PL/Sql stored procedure to move files from one location to another. I need to move files that are older than 30 days. Is there any Oracle package I can use to move the files on the basis of its creation date.

View 3 Replies View Related

Backup & Recovery :: Data Files Backed Up To FRA Instead Of Specified Location?

Jun 24, 2013

I am trying to backup my entire database's files :

[oracle@testing-oracle-1 ~]$ rman target /
Recovery Manager: Release - Production on Mon Jun 24 16:09:54 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1341263457)
RMAN> list backup;

using target database control file instead of recovery catalog specification does not match any backup in the repository

new RMAN configuration parameters:
new RMAN configuration parameters are successfully stored
FOR DEVICE TYPE DISK TO '/u01/app/oracle/backupsets/control_files/cf_%F.BCKP';2>


I see that a backup set was created to "/u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/" , in spite of my specification.

So I asked RMAN to list all the backups I have:

RMAN> list backup;

List of Backup Sets
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
1 41.14M DISK 00:00:00 24-JUN-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130624T161025
Piece Name: /u01/app/oracle/backupsets/818957425_1_%r.BCKP


Here I see that 4 backup sets have been created.The backup sets 1 & 3 containing the archived redo logs (818957425_1_%r.BCKP and 818957451_3_%r.BCKP) are placed as I wanted in /u01/app/oracle/backupsets/ dir.

The file containing the Control File and Spfile (cf_c-1341263457-20130624-00.BCKP) is placed as I wanted in /u01/app/oracle/backupsets/control_files/ dir.However, The backup set file containing the data files(o1_mf_nnnd0_TAG20130624T161026_8wjkb2tg_.bkp) is placed under the directory /u01/app/oracle/flash_recovery_area/ORCL/backupset/2013_06_24/ ,and I don't understand why.

When I backup my database without the archived redo logs - it is saved correctly:

RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name


1. Why aren't my data files backed up to the location I specified when I backup using PLUS ARCHIVELOG syntax?

2. Why are my redo logs saved to two different backup sets and not just one?

3. Is there a way to combine backup of all files (data files, control file, spfile, redo logs & arch redo's) in one backup set, one file?

View 5 Replies View Related

Active Trace Files Deleted - How To Free Up Space

Oct 11, 2013

Some trace files were deleted with rm command. Obviously they were active and now the free space does not free up (over 9GB). How can this be fixed without database interruption?

View 4 Replies View Related

Server Administration :: Large Trace Files Generated In Udump?

Oct 24, 2011

We have Oracle 10g( RAC on AIX 5.3, there are 3 RAC instances on each node.From Oct 9th, we found one of the instance in node 1 generated a large size trace files in udump. The largest size of the trace file take up 3G. But there's only about 15G $ORACLE_BASE direcotry. After some time, we should delete some trace files for releasing the space.

Here is a part of alert log when this issue happen:

Sun Oct 9 23:18:15 2011
Errors in file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3166258.trc:
ORA-00600: internal error code, arguments: [17087], [0x70000010DF9F580], [], [], [], [], [], []
Sun Oct 9 23:18:16 2011
Trace dumping is performing id=[cdmp_20111009231816]


I checked with some trace files, I found all these files contains a huge info of processes.

View 17 Replies View Related

Does Trcsess Combine Various Trace Files In Order In Which Queries Executed

May 28, 2013

Does trcsess combine various trace files in the order in which the queries were executed?

View 3 Replies View Related

Automatic Storage Management :: Steps For Moving Files Between ASM Diskgroups In 10g Or 11g

Jan 16, 2013

the steps for moving the files between ASM diskgroups in 10g or 11g?

View 4 Replies View Related

Performance Tuning :: Script To Load Trace Files Errors To A Table?

Jul 13, 2013

I need to create a script which can fetch the error related details from Trace files regularly (may be twice a day ) to a custom table in DB.

View 3 Replies View Related

Server Administration :: User Dump / Trace Files With Huge Size In MBs

Mar 22, 2012

I am facing problem in user_dump_dest directory...I have noticed that there are a lot of trace files with huge size in MBs.I clean it and after 4 days there are 40G of size..

View 1 Replies View Related

Backup Of Archive Files

Dec 1, 2010

I am running the following command to backup my archive logs and want to keep at least two hours of .arc files on disk.

rman < connect target login/password
connect catalog login/password
show all;
sql "alter system archive log current";
backup filesperset 5 archivelog until time 'sysdate-2/24'
delete input ;
resync catalog;

On some occassions, there will not be any archive logs that meet this criteria and I get the following error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/01/2010 12:50:58
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242: specificati
on does not match any archive log in the recovery catalog

Is there anything I can do to the rman command above that will prevent this error from happening but yet keeping same functionality?

View 2 Replies View Related

Delete Archive Log Files Using RMAN

Jul 26, 2013

I am trying to remove archive log file on my standby site but I am getting the following message. There are lots of archive logs are present on the storage but rman is unable to displaying that.

RMAN> list archivelog all;

specification does not match any archived log in the repositoryRMAN> 

View 7 Replies View Related

Server Administration :: Unable To Delete Archive Files Through ASMCMD

Apr 13, 2011

we are getting below error:

ora-00257 archiver error. connect internal only until freed

when we tried to remove the unwanted arc files thro ASMCMD,we are getting below error:

ASMCMD> rm -ef 2011_04_05/
Unknown option: e
usage: rm [-rf] <name1 name2 . . .>
ASMCMD> rm -rf 2011_04_05/
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_2_seq_27215.1143.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15028: ASM file '+XCOM_BACKUP_DG/TXCOM/ARCHIVELOG/2011_04_05/thread_3_seq_21762.826.747641143' not dropped; currently being accessed (DBD ERROR: OCIStmtExecute)
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

further we checked FRA size:

SQL> select * from v$flash_recovery_area_usage;

------------ ------------------ ------------------------- ---------------

ARCHIVELOG 3.19 0 38

and checked any arc processing holding lock on arc files:

> ps -ef | grep -i ora_arc*

oracle 6989 1 0 15:07 ? 00:00:00 ora_arc0_TXCOM1
oracle 6991 1 0 15:07 ? 00:00:00 ora_arc1_TXCOM1
oracle 12246 12164 0 15:17 pts/4 00:00:00 grep -i ora_arc*
oracle 13452 1 0 Mar23 ? 00:01:07 ora_arc0_TWEBAPPS1
oracle 13454 1 0 Mar23 ? 00:00:30 ora_arc1_TWEBAPPS1
oracle 15402 1 0 Mar23 ? 00:00:50 ora_arc0_SXCOM1

[Code] ........

but we were not able to remove those .arc files from that folder. finally we have down all the instances and deleted those files manually.

View 1 Replies View Related

Backup & Recovery :: RMAN - Missing Archive Logs Files

Oct 7, 2012

We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.

We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.

View 9 Replies View Related

Server Administration :: Variable File Size For Archive Log Files

Dec 16, 2010

I'm facing problem with archive log file size, Archive logs are generated with only of 90m or 92m or 94m(Variable sizes of less than 100m), Although i had set 100m for each of my redo log file. Here i'm providing my create db script for your reference. I want to know why the log switches before it reaches 100m.Is there any connection of intial 10m for my .dbf files.

create database mydev
maxlogmembers 3
maxloghistory 100
maxdatafiles 50
maxinstances 1


View 14 Replies View Related

Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases

Mar 5, 2013

what type of storage systems used for saving archive files and backup files "especially for oracle databases"

View 5 Replies View Related

Backup & Recovery :: Changing Location Of Data And Temp Files From Auto-backup Of Control-file?

Jan 26, 2012

I have an oracle autoback of controlfile and spfile. I am trying to restore the production database using this backup, into a new server with a different directory structure.

I have completed the following steps in the restore process.

1. Creating a pfile from spfile

2. Changing the the location of cdump, udump, bdump and the control files ( there are three )

3. Then creating a spfile from this pfile

I am stuck on the next step where to rename all the datafiles and tempfile and restore the database. Following is what I did.

After mounting the database in RMAN, tried to run the following.

RMAN> run
2> {
3> allocate channel c1 device type disk
4> ;
5> @/home/oracle/rman_scripts/newloc.rman
6> SET NEWNAME FOR DATAFILE 1 TO '/u02/oradata/dorian/system01.dbf';
7> SET NEWNAME FOR DATAFILE 2 TO '/u02/oradata/dorian/undotbs01.dbf';
8> SET NEWNAME FOR DATAFILE 3 TO '/u02/oradata/dorian/sysaux01.dbf';
9> SET NEWNAME FOR DATAFILE 4 TO '/u02/oradata/dorian/users01.dbf';


I am getting the following error message.

Starting restore at 25-JAN-2012 21:26:48
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/25/2012 21:26:49
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 30
RMAN-06100: no channel to restore a backup or copy of datafile 29
RMAN-06100: no channel to restore a backup or copy of datafile 28


View 14 Replies View Related

Impdp Speed Differ From Location To Location

Oct 4, 2013

We have taken export expdp backup from prod database (primary database- Data Guard).

1.) Import impdp is very slow 10GB/Hrs on staging database (Data Guard MAXIMUM AVAILBILITY)Since Server configuration, database version and configuration, operating system everything are same as production. No blocking, locking or waiting sessions

2.)import impdp is fast 90GB/Hrs on Test standalone database and this test database is running in NOARCHIVE LOG mode with oracle standard version after that no more difference.

CPU,Memory,network and disk I/O are look normal while importing on both databases.why that much difference on import.

View 1 Replies View Related

Backup & Recovery :: RMAN Hot Backup Plus Archive Log Files?

Jan 11, 2008

I had a production db with archive logging enabled

SQL> select name,status
2 from v$archived_log;

---------------------------------------- -


So i need to restore archivelogs by using sequence

So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup

RMAN >backup database plus archivelog all delete input;

but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)

my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?

RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }

View 4 Replies View Related

Backup & Recovery :: Backup Archive Log Files

Aug 4, 2011

I have one question to clarify regarding backup.

There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?

View 10 Replies View Related

Difference Between (ocrconfig -export Location) And (ocrconfig -manualbackup Location)?

Aug 13, 2013

what is difference between "ocrconfig -export location" and "ocrconfig -manualbackup location"

View 1 Replies View Related

Precompilers, OCI & OCCI :: Make Files That Compile PC Files In Unix

Jul 31, 2008

I have written make files that compile .pc files in unix. This was for several projects that use an oralib source code directory.Just running proc on one target .pc file works fine on unix. I am trying to use proc - Oracle 10.2.0 - in windows and I keep getting:

Quote:unable to open include file
#include <stdio.h>
and other C library headers.

I am doing all development under cygwin, this way I can write a makefile just like under unix instead of using nmake.All C library headers are in /usr/include When I run proc on Solaris as that:

proc program.pc
No problems, and I do get program.c.

However in windows I get the previous error message. I have tried to do proc include=/user/include program.pc and proc include=/user/include parse=full program.pc but I still get the same error message.

View 3 Replies View Related

Know If Database Files Are On File System Or Raw Files?

Oct 11, 2012

How can I know if database files are on file system or raw files?

View 4 Replies View Related

Copyrights 2005-15, All rights reserved