Server Administration :: Flash Back Recovery Area

Mar 3, 2012

what is flash back recovery area? what is its main function and usage

View 1 Replies


ADVERTISEMENT

Server Administration :: How Much Flash Recovery Area Is Enough For Flashback

Aug 18, 2011

here's my settings

SYS@boston>SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;

ESTIMATED_FLASHBACK_SIZE
------------------------
45195264

SYS@boston>select name, value, issys_modifiable from v$parameter where name='db
_recovery_file_dest_size';

NAME
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
ISSYS_MOD
---------
db_recovery_file_dest_size
9663676416
IMMEDIATE

SYS@boston>select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
D:Ora102chicagooston_recover
9663676416 1671241216 1103842304 50

SYS@boston>select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG .04 0 1
ARCHIVELOG .16 .01 21
BACKUPPIECE 16.84 11.41 22
IMAGECOPY 0 0 0
FLASHBACKLOG .25 0 6

6 rows selected.

SYS@boston>

I have configured a flash recovery area of 9g yet the system keeps complaining that i have not enough flashback logs?

SPACE_RECLAIMABLE 1103842304
ESTIMATED_FLASHBACK_SIZE 45195264

the space_reclaimable is more than ESTIMATED_FLASHBACK_SIZE, so how is it possible the system always complain not enough space?

[URL].....

Quote:

SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;

it returns me 0, I try to flashback the now defunct former primary db chicago, the system complains. so how much is really enough?

from

[URL]......

Quote:
V$FLASHBACK_DATABASE_LOG

View 1 Replies View Related

Backup & Recovery :: Flash Recovery Area 9i

May 22, 2011

I want to change backup location for Oracle 9i Database. there is no flash recovery area in 9i, so i want the parameter which i can use to modify backup location to anywhere i want.

View 4 Replies View Related

Backup & Recovery :: Cannot Update Recovery Area Reclaimable File List

Oct 18, 2012

I just switched my STBDY DB to a PRIMARY DB and I am ran the following:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed

RMAN-08132: WARNING: cannot update recovery area reclaimable file list

RMAN> show all;

RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code]....

what causes this warning and how to get rid of it?

View 2 Replies View Related

Server Administration :: Back Track OS Processes To RDBMS

May 5, 2013

I have two Oracle databases (test1- 10gr2,test2 - 11gr2) on rhel 5.5. is it possible to find which particular oracle process belongs to which home from OS level. was trying to find which db processes are consuming more resources on my host.

View 4 Replies View Related

Recovery Area Cannot Be Used For Archive Log?

Sep 13, 2013

I`m using the the version 11.0.2.3 for testing.  I read a line as below from the OCP book.

If none of the LOG_ARCHIVE_DEST_n parameters have been set, then transitioning. the database to archivelog mode will internally set LOG_ARCHIVE_DEST_10 to the flash recovery area, if it has been configured. In my database the fast recovery already been set as below.

SQL> show parameter db_recovery
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FASTRECOVERY
db_recovery_file_dest_size           big integer 4248M

So I thought if I turn the database into archive log mode, then the log_archive_dest_10 will be set as the same value as db_recovery_dest.

SQL> alter database archivelog;
 
Database altered.
 
SQL> alter database open;
 
Database altered.
 
SQL> show parameter log_archive_dest
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string

See, after the database become archive, the log_archive_dest_10 still be empty.  So is there any thing wrong with my understanding?

View 5 Replies View Related

Creating DB With Flash Recovery (Pros And Cons)

Mar 8, 2011

I am moving an Oracle DB (10.2.0.1) to a new server, by creating a blank DB and importing the data by user. I chose to create the new database with Flash Recovery activated (I haven't previously used this), but I'm having a nightmare when importing the data.

I encountered issues with the DB_RECOVERY_FILE_DEST_SIZE which I resolved by increasing the size of this parameter.

Next the import crawled along because of redo.log file errors "Checkpoint cannot complete". I'm assuming that I need to add redo.log files to accommodate this?

View 3 Replies View Related

Backup & Recovery :: Create Online Back Up Of Database Using RMAN?

Dec 23, 2011

How can i create an oline back up of database using RMAN?

View 1 Replies View Related

Server Administration :: Roll Of Undo In Recovery?

Aug 4, 2011

what is the role of undo cache or undo tablespace in recovery?

View 3 Replies View Related

Server Administration :: ORA-01113 - File 1 Needs Media Recovery

Oct 27, 2012

I just installed Oracle XE on my local computer Windows 7. When I run STARTUP command I get this error:

SQL> startup;
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1384760 bytes
Variable Size 226496200 bytes
Database Buffers 301989888 bytes
Redo Buffers 5791744 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'D:ORACLEXEAPPORACLEORADATAXESYSTEM.DBF'

I try to fix it by recover but unsuccessfully:

SQL> recover datafile 'D:ORACLEXEAPPORACLEORADATAXESYSTEM.DBF'
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.

View 5 Replies View Related

Server Administration :: Transaction Recovery - Lock Conflict Caught And Ignored?

Apr 20, 2011

I am facing following message with alertlog file. It appearing much frequently and filling alertlog file.

Transaction recovery: lock conflict caught and ignored

View 2 Replies View Related

Server Administration :: ORA-00554 Initialization Of Internal Recovery Manager Package Failed

Apr 18, 2013

When I am issuing below command from auxiliary database, getting ORA-00554.My tnsping is okay from both the side, remote login is exclusion. Password file is also okay.I ran UTLRP.sql twice to compile invalid packages.

From Auxiliary Database
[ashish@localhost dbs]$ rman target sys/oracle@suman auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 11 19:04:03 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

View 8 Replies View Related

Backup & Recovery :: Recovery Of Database From Crashed Host Server?

Jul 20, 2012

Backgroud info:

host server crashed.

Database was not cleanly shutdown.

Database is not in archivelog mode.

Datafiles were saved.

My goal:I want to recover the database based on the available files.

My approach:

Install new database.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE.

shutdown database.

Place available dbf files in the location for new database, replacing existing files.

edit trace file to create new controlfile. Script is:

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "newdatabase" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292

[code]....

View 12 Replies View Related

Forms :: Flash Animation In Oracle 6i?

Apr 4, 2011

Is there any way to show Flash Movie file in Oracle Forms.

View 1 Replies View Related

Smart Flash Cache And Redo With SSD?

Oct 23, 2012

11.2.0.2.0
OEL.

Design stage of New SAN. I can put a lot of the database, including redo on SSD.

1. Hardware sub tiering enabled. Has anyone ever gauged performance with enabling 11g Smart flash cache using the SSD as the flash device even with the hardware subtiering on? ie, if the hardware subtiering is moving hotblocks to most performant disk, is there much significant benefit having the flash cache on. Im guessing yes as the flash cache is working at the SGA level.

2. To redo or not to redo on SSD. Many notes say not to so as to avoid log file sync waits. Is there a way to keep it on the SSD and avoid the waits? Is there any risk of enhanced degradation of the disks over time with having so much sequential writes from the redo if I leave it on there?

How to Minimise Waits for 'Log File Sync' [ID 857576.1] (discusses keeping redo off ssd but only generally)

[URL]

View 1 Replies View Related

Forms :: Play Flash Movie (SWF File) In 6i?

Mar 15, 2005

Could I play an flash .swf file in forms 6i?

View 13 Replies View Related

SQL & PL/SQL :: To Select IDs Which Have No IN Or PLANNING Status In AREA 9

Apr 23, 2012

I want to select the IDs which have no IN or PLANNING status in AREA 9

ID 1 has AREA 9 and STATUS IN so dont select
ID 2 SELECT
ID 3 has area 9 BUT STATUS is OUT so Select.

So if an ID has has IN or PLANNING status in AREA 9 i do not wish to see it!

CREATE TABLE DAN_T1
(
ID varchar(8),
AREA varchar(8),
UNIT varchar(8),
STATUS varchar(8)
)
INSERT INTO DAN_T1 (ID,AREA,UNIT,STATUS) VALUES (1,6,'AA','IN');
[code]......

ID AREA UNIT STATUS
16AAIN
17ABPLANNING
17ACOUT
19ADIN
25ACIN
25AAOUT
35BAPLANNING
36DAIN
35CAIN
39CGOUT

WANT:

ID
2
3

View 2 Replies View Related

Backup & Recovery :: 10g Recovery On A Different Server

Feb 29, 2012

I have a database ORADB1 running on UNIX server and I took a hot backup using a script and restored it on the same server as ORADB2 and opened the database to verify it comes up and then shut it down.

Now I have a requirement that I need to use the same datafile copy (ORADB2) and bring it up in another server as ORADB1 .

View 3 Replies View Related

Forms :: Import Flash Movie By Active Control

Feb 21, 2004

I want to play the flash movie on to my form....how i can use this facility... how i can import the flash movie in to my form.

View 6 Replies View Related

Application Express :: 4.2 - Where Is Flash Chart Region Source

Sep 4, 2012

I just noticed on apex.oracle.com (4.2) that I couldn't find the region source for flash charts. I expected to find it under the Region Definition tab.

Has this moved or will it be included in a later release?

View 12 Replies View Related

Exadata :: Dynamic Views For Flash Cache Usage?

Mar 19, 2013

Despite it being one of the major selling points of Exadata (especially from X3 onwards), I'm struggling to find much information on our usage of the Exadata Smart FlashCache (I'm running RDBMS 11.2.0.2 BP7 on a V2 quarter-rack).

I can verify usage of the FlashCache by checking whether the object has been 'pinned' to the FlashCache via DBA_SEGMENTS and I can check for FlashCache usage by querying gv$sysstat (and even v$mystat), but are there other views that I could use? It seems a bit strange for Oracle not to provide the DBA all that much insight into their usage of this feature...

View 2 Replies View Related

Enterprise Manager :: 11gR2 Grid Control - SVG Or Flash?

Sep 15, 2011

I'm trying to use 11gR2 Grid Control to manage several 10gR2 database targets. I'm unable to determine the correct mix of Adobe software plug-ins to use for displaying SQL execution plans in a more graphical style. My client OS is Windows 7 - I have tried to research plug-ins for Internet Explorer 8, I upgraded (and subsequently downgraded!) to IE 9; I installed Firefox 6.x, tried with Google Chrome and all with the same results.

I'm not seeing any relevant information from MyOracle support or on Google, but may not be asking the correct question. As far as I can determine, SVG 3.0 is needed, Adobe stopped development in 2009 and there is no variant available therefore for Windows 7.

View 2 Replies View Related

Forms :: Using A Java Program In Bean Area?

Jul 13, 2010

I want to use a java program in Bean Area.

But I can't understand the implement class and how it is implemented.

View 1 Replies View Related

Windows :: OUI-10133 / Invalid Staging Area

Oct 5, 2005

I have a prob installing Oracle 10g on Window 98 SE :

OUI-10133:Invalid staging area.

There are no top level components for Windows 98 available for installation in this staging area.

View 8 Replies View Related

Application Express :: Setting Up SSO In Work Area?

Jul 5, 2012

How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.

Have you able to run this script before?

apex_sso.sql, apex_verify.sql, apex_sso_server.sql

My output for this scripts are good.

View 0 Replies View Related

Performance Tuning :: Setting Flash Cache Initialization Parameters?

Aug 11, 2010

I have OEl 5.5 installed and patched. I have my SSD mounted..

but when i ran the command 'alter system set db_flash_cache_file ='/media/ssd/' scope=spfile;'

It wouldn't startup giving ORA-01078: failure in processing system parameters...

View 6 Replies View Related

JDeveloper, Java & XML :: Accomplish Animation With JavaScript Or Will Have To Turn Into Flash?

Dec 30, 2010

Can i accomplish animation with JavaScript or will i have to turn into Flash?

View -1 Replies View Related

Application Express :: Flash Chart Show Incorrect Data

Jun 3, 2013

The following query is used to generate a flash chart:

select null link
'Available' as "Available",
to_number(max_licenses - consumed_licenses)
from software_detail
where capture_date = trim(GET_CAPTURE_DATE)
and software_product = :p1
and software version = :p2
[code].....

But the 2d doughnut flash chart shows:

Available = 39
Consumed = 1

How is this possible?

Oracle 11.2.0.3 RAC on Windows 2008 R2
APEX 4.2.1.00.0 with Apex Listener 2.0 on Apache Tomcat 6.

View 4 Replies View Related

Application Express :: Customize Tooltip In Flash Chart / Graph

Dec 4, 2012

Is there any way I could customize tooltip (when you go over the bar in the report, small box with the value appears).I would like to display different values there.

View 0 Replies View Related

Application Express :: Flash Chart In 3.1 - How Many Labels Can Be Get Horizontally (Limitations)

Jun 22, 2012

I am trying to do a Flash Chart in APEX 3.1. Is there a limitation on how many labels I can get horizontally. No matter what I do the number of labels I get horizontally is 15. We are trying to show the amount of days in a month.... Can I do that? If so how?

View 5 Replies View Related







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