RMAN :: Rc-datafile Mismatch Sizes - Column Bytes Shows Data Different From Real Of Files?

Sep 26, 2012

in my catalog database I see in Rc_datafile mismatch sizes - column bytes shows data different from the real sizes of files .

Does this view updated after copy of database into catalog ?

View 4 Replies


ADVERTISEMENT

How To Calculate Sizes Of Archive / Redo In Data Warehouse DB

May 24, 2011

Before I begin, I want to clarify that I am newbie in the administration of data warehouse.I need to know how to calculate the sizes of the archive and redo on data warehouse DB, in order to make an initial sizing of the BD on disks level.

Is there a formula to calculate the size?

View 1 Replies View Related

Size Of Undo Tablespace Datafile Different From Same Files In OS

Jan 22, 2013

why total size for undotbs1 is different from the acutal data file size in Operating system.

select tablespace_name, sum(bytes/1024/1024) from dba_data_files
where tablespace_name like 'UNDO%'
group by tablespace_name;

tablespacename total size
UNDOTBS1                      2000
UNDOTBS2     7284
[code]....

View 7 Replies View Related

PL/SQL :: ORA-06525 - Length Mismatch For CHAR Or RAW Data

Nov 1, 2013

ORA-06525: Length Mismatch for CHAR or RAW dataORA-06512: at "SYS.UTL_FILE", line 127ORA-06512: at "SYS.UTL_FILE", line 1204ORA-06512: at line 14

View 20 Replies View Related

RMAN :: Backup Of A Datafile?

May 20, 2013

Suppose our database have 100 datafiles and right now rman has completed backup of 64 datafile(from file no 1 to file no 64) and in process of backup of 65 number datafile. In mean time I executed some query and it has changed the file no 55. so now my question whether rman will go and bacup this datafile(datafile no 55) again or it will leave this file as it is?

View 4 Replies View Related

Backup & Recovery :: Incomplete Recovery Shows RMAN-20207

Jan 4, 2012

when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs.

View 3 Replies View Related

Backup & Recovery :: Restore Datafile With Its Contents Without Using RMAN

Oct 13, 2011

I have no backup taken in my oracle server.Today morning i created a data file and unknowingly deleted it. Now i need to restore the datafile with its contents without using RMAN.

View 14 Replies View Related

RMAN :: How To Move Datafile Copies From Incremental Backup

May 17, 2013

As part of an incremental backup I recover copies of the tablespaces. These by default are stored in the disk backup location diskgroup. Is it possible to move these copies to another disk group / location whilst still backing up to the default disk backup location diskgroup. I know how to do it with the main datafiles but not with the copies.
e.g.

Current situation:
Original Datafiles in +DATA
Backups in +FRA
Recovered Datafile copies in +FRA

New setup to be:
Original Datafiles in +DATA
Backups in +FRA
Recovered Datafile copies in +BACKUP

View 4 Replies View Related

RMAN :: 20201 - Datafile 45 Not Found In Recovery Catalog

Aug 9, 2012

I have one database which is fully restored from client backup (RMAN). Database was up and running perfectly. By mistake I have deleted one schema/user and its tablespace using drop command. I have RMAN backup so want to restore that schema's datafile from the backup but when I run below statement it throwing error :

run {
allocate channel c1 device type disk ;
set newname for datafile 45 to '/ora/oradata/JSIP1/data.dbf';
RESTORE datafile 45;
switch datafile 45;
recover datafile 45;
SQL ' alter database datafile 45 online ' ;
}
RMAN-20201: datafile 45 not found in recovery catalog

or If I go and try to restore the tablespace of that schemas using below block it throws error:

run {
allocate channel c1 device type disk ;
RESTORE TABLESPACE DATA;
RECOVER TABLESPACE DATA;
SQL 'ALTER TABLESPACE DATA ONLINE';
}
RMAN - 20202 Tablespace not found in the recovery catalog
RMAN -06019 could not transalate tablespace name "DATA"

how to restored drop users and tablespace data from the RMAN backup.

View 11 Replies View Related

SQL & PL/SQL :: Write A Query Which Shows Data Of One Table Not Present In Other?

Apr 3, 2011

I am writing following query
SELECT DISTINCT a.list_type_code, a.list_type_name
FROM jls_list_type a, jls_list_control b
WHERE b.jalsa_srl = :jalsa_srl
AND b.list_no != a.list_type_code
ORDER BY list_type_code

I just want to display only those records from JLS_LIST_TYPE which is not present in other table JLS_LIST_CONTROL ... for this i wrote above query but it is not working.

View 9 Replies View Related

Loading Data In Person Table Through SQL Loader Shows Zero Records

Oct 1, 2011

When I am loding the data in person table through sql loder runs successfully without errors but when i check the person table it shows me zero records. Following is the details about what i done.

here are the details of data files.
1 Ahmed Baraka 1000 1.87 1-1-2000
2 John Rice 5000 2.4 10-5-1998
3 Emme Rak 2500 2.34
4 King Size 2700
5 Small Size 3000 31-3-2001

And The control File.
OPTIONS ( ERRORS=0)
LOAD DATA
INFILE '/oraeng/app/oracle/product/10.2.0/dbs/persons.dat'
BADFILE '/oraeng/app/oracle/product/10.2.0/dbs/persons.bad'
DISCARDFILE '/oraeng/app/oracle/product/10.2.0/dbs/persons.dsc'
INTO TABLE "KAILAS"."PERSONS" REPLACE
FIELDS TERMINATED BY X'9' TRAILING NULLCOLS

[code]...

View 2 Replies View Related

Recovery Manager (RMAN) :: Filename For Datafile Is Missing In Control File

Jun 15, 2012

DB:11.2.0.2.0
Oracle Apps:12.1.3
O/S:AIX 6.1 64 bits

RMAN backup throws the error:

RMAN-06169: could not read file header for datafile 40 error reason 1
RMAN-06169: could not read file header for datafile 41 error reason 1
RMAN-06169: could not read file header for datafile 40 error reason 1
released channel: oem_disk_backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/14/2012 07:54:43
[code]...

Could we skip the backup of the above missing files using RMAN -> backup database skip inaccessible;On further research, this would compromise tablespace SYSAUX recoverability...Questions:

1) What caused the above missing files to get created?
2) What is recommended: Recover the datafiles?

View 10 Replies View Related

SQL & PL/SQL :: Altering Virtual Column To Real Column?

Oct 4, 2011

Is there a way to alter an existing virtual column to set as a real column without dropping it and recreate (i have index on it, and i don't want to recreate them).

View 2 Replies View Related

AWR Report Shows Wait Time Is High But OS Shows Wait Time As Normal

Oct 2, 2012

We have a Oracle 10g database with RAC and Dataguard. When we look at the AWR report, the wait time shown by Oracle for this database is very high.

Service Time : 15.36%
Wait Time : 84.64%

This would imply Oracle is waiting for resources 85% of the time and only processing SQL queries during 15% of its non-idle time. However when we check the OS (RHEL), the iowait is only about 10% and the CPU is 80% idle. This means that that processing horsepower is available.

As such, the results between the OS and Oracle database (AWR report) seems contradictory. OS says we have CPU/IO capacity, however Oracle says we don't.

View 17 Replies View Related

Error While Using SQL Loader - Bad Datafile Datatype For Column RANGE

Apr 29, 2011

I am trying to load the data from .csv file into the table using SQL Loader.

The table has the following schema:
src_id : number,
dest_id : number,
range: intsys.interval_typ --- > a type containing (lower,upper)
payload : varchar2(100)

The loader.ctl file is :

load data
infile *
append
into table sb_packet
fields terminated by "," optionally enclosed by ' " '
(src_id,dest_id,range,payload)
BEGINDATA
3,32,intsys.interval_typ(10043,142703),"misc data"

When I use the following this ctl file to transfer the data, i get the following error:

SQL*Loader-418: Bad datafile datatype for column RANGE

View 2 Replies View Related

RMAN ASM Duplication Orphan Files?

Jun 10, 2011

I use the following script to duplicate a target to an auxiliary instance. This works fine once.

However if I run it a second time it will create a new set of datafiles leaving the original files in place taking up space.

Is there something that I can put in the script that will stop this happening.

I know I could probably put a "set newname for datafile" clause for each datafile in the target database, but this makes the script over complicated and I would like to keep it as generic as possible.

DUPLICATE TARGET DATABASE TO dupdb
until time "TO_DATE('07/06/2011 07:25','DD/MM/YYYY HH24:MI')"
LOGFILE GROUP 1 ('+DATA') SIZE 50M,
GROUP 2 ('+DATA') SIZE 50M,
GROUP 3 ('+DATA') SIZE 50M,
GROUP 4 ('+DATA') SIZE 50M;

View 2 Replies View Related

RMAN - Recover Files In Other Machine?

Dec 5, 2011

I have many backup sets of my database.

I need to recover a especific set of data, but where these data are. I thought of install oracle in a new machine and recover the backups one by one.

View 1 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

RMAN :: How To Remove Database Files And Backup From ASM

Oct 19, 2012

Oracle Database 11.2.0.3
OEL 5.7

We have a host for restore purposes. We execute monthly or quarterly restore operations to verify that I am able to restore a subset of the data in the given amount of time or to other purposes. I have a automated script to Clone the Database, but to Clone Database we need remove the old database from ASM before start this operation. I want remove only Database files and keep the configuration (such as oratab/network/ocr and so on).

Question: There is a easy way to remove these files without connect on ASM or by using DBCA?

View 2 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

Backup & Recovery :: RMAN 10g - Restore Files From Tapes

May 8, 2013

Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?

View 4 Replies View Related

Recovery Manager (RMAN) :: Taking Backup In 3 Files?

Mar 27, 2013

I took backup of Datafiles , archivelog files and controlfile through RMAN. Now, i want 3 backup file will created as a output of RMAN operation. It would be :

1 backupfile for all the datafiles
1 backupfile for all the archivelog files
1 backupfile for controlfile.

It have to be regardlessly whatevr my DB size is. It it possible to do so. How i can can write rman script to accomplish the task.

View 7 Replies View Related

RMAN :: Optimization - Ensure Skip Those Files Already Taken Backup

Feb 28, 2013

I would like to know that if I enable backup Optimization on then incremental full backup skip any files which was earlier backup? Because we may know that backup Optimization on ensure skip those files which are already taken backup.

Database : oracle 10g 10.2.0.3 .

View 4 Replies View Related

RMAN :: Change Database Name Control Files After Restore

Jul 12, 2012

I have restored database with the name DB to another database called DB01

it is in STARTED status (not mounted) and it seems I can not change the name if it is not mounts, and I can not mount it because of the name, how to solve this issue if possible? I have RMAN full backup from DB on my current server which hosting the database DB01 the initdb01.ora is ready and configured with DB01

what can I do next

ORA-01103: database name 'DB' in control file is not 'DB01'

View 5 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

Backup & Recovery :: Possible To Maintain Real Time Backup Using RMAN?

Mar 16, 2011

Is it Possible to Maintain real Time Backup using RMAN ?

View 39 Replies View Related

Moving Data From Datafile

Mar 7, 2011

In my Production DB. 5 Datafiles created in same tablespace. Datafile size is of 25GB. Data stored in all Datafile. Data is just 5GB in all datafile. I want to move data from 5 datafiles to single or couple of datafiles.

This is in Oracle 11g.

View 2 Replies View Related

Resize Online Redolog Files And Make RMAN Absolute Backups As Usable?

Jun 19, 2013

why can not we resize online redolog files instead of re-creating the same with large size and remove the older onces.2. How can we make RMAN obsolute backups as usable ?

View 8 Replies View Related

How Big SGA And PGA Sizes Set On Larger Database

Mar 22, 2012

what people have set for the SGA and PGA sizes for their larger usage, larger data, databases? I've been seeing one of our warehouses grow both in terms of tables (number and sizes) and users groups querying the database. We're at 96g sga and 10g pga, but was thinking in terms of 1/2 tB machine to pin some larger tables. I know we'll have SSD soon, but am seeing enourmous numbers of reports using windowing and analytic functions and in line sets being created. How big in general do you have your larger systems set to?

View 2 Replies View Related

Small Extent Sizes In 11.2.0.3

Aug 12, 2013

I did some google searches about large number of extents and ASSM. I see bits and pieces on the web. This is something I need to look at while testing an application. Not looking to go into 'why' I would use smaller extents, I just want to make sure I have what I need to look for during testing..Issues with massive numbers of extents: 

1. DBA_EXTENTS query is really slow.
2. issues truncating tables (due to having to read lots of extents)
3. issues splitting maxvalue partitions and with dropping partitions.
4. if I stay away from ASSM, would this reduce these issues?  Are there any other performance issues or other issues I need to know about to check when I do tests?

Any issues with query or insert wait time? The tables that would get smaller events would have thousands of partitions/sub-partitions . Most of these sub-partitions will be rather smaller.I  just want to test for a variety of different cases. The 'why' will come out during testing.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved