Server Administration :: Why Archive Should Be Turned ON Before Turning On Flashback

Aug 5, 2010

I have read it in books that flashback uses undo data to create the flashback data or to flashback the database to a time in the past.Then, what is the role of archive files in flashback operation. Why it is mandatory to turn on archiving before turning on flashback. Also, if you remove the latest archive files, you can NOT flashback the data to a time in past (Oracle complains of missing archive files).

View 8 Replies


ADVERTISEMENT

Server Administration :: Flashback Data Archive

Aug 23, 2011

I need store history for two tables in my system. I thought that Flashback Data Archive will be the best option. There is also another ways to do this but don't focus on this. I need to to this by FDA (Flashback Data Archive);

So my prerequisite was to create tablespace and flash back archive, and alter table to be archived.

create tablespace audit_archive datafile 'd:oradata etaaudit_archive.ora' size 100M;

create flashback archive audit_flash_archive
tablespace audit_archive quota 10G retention 10 year;

alter table teta_admin.t_prac flashback archive audit_flash_archive;

and everything works fine but on sys user.
i can query this table using "as of timestamp" clause

select prac_id, imie, imie_2, nazwisko, nr_ew from teta_admin.t_prac as of timestamp to_timestamp('2011-08-23 08:20:00','yyyy-mm-dd hh24:mi:ss')

but final construction of idea was to create additional user (interface), grant select on teta_admin.t_prac object and query archive data from interface user. and this is point of my failure. this don't work on new user.

interface user have such sys privs:

SQL> SELECT * FROM dba_sys_privs
2 WHERE grantee = 'INTERFACE';
GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
INTERFACE CREATE SESSION NO

and table privs:

SQL> SELECT * FROM dba_tab_privs
2 WHERE grantee = 'INTERFACE';

GRANTEE OWNER TABLE_NAME GRANTOR PRIVILEGE
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------
INTERFACE TETA_ADMIN T_PRAC TETA_ADMIN INSERT
INTERFACE TETA_ADMIN T_PRAC TETA_ADMIN DELETE
INTERFACE TETA_ADMIN T_PRAC TETA_ADMIN ALTER
INTERFACE TETA_ADMIN T_PRAC TETA_ADMIN FLASHBACK
INTERFACE TETA_ADMIN T_PRAC TETA_ADMIN SELECT

what i need to do in order to query this flashback table from interface user. when i try to do this from this user oracle says ORA-00942.

View 9 Replies View Related

Flashback Data Archive?

Aug 27, 2012

I heard about flaskback data archive. can i get some short example to understand in practical way

View 11 Replies View Related

Backup Flashback Data Archive And Restore On New Database?

Oct 14, 2012

Is there anyway to backup Flashback Data Archive (FBDA) data and can be restore on new database. I cannot find Oracle's document or any document explain about backing up this data.

View 6 Replies View Related

Server Administration :: How To Delete Flashback Log And Release Space

Feb 15, 2012

How to delete flashback log and to release the space?

I guess that it maybe like archive log ,it can release the space using RMAN.But when i try a test ,it fail.

SQL> STARTUP MOUNT;
SQL> ALTER DATABASE FLASHBACK OFF;

View 6 Replies View Related

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

Server Administration :: Flashback Table Operation For The Sys User

Jun 7, 2010

Flashback table operations are not supported for the SYS user . I have found the above line in one of the article.

I don't know why the SYS user can not able to flash back the table.

View 5 Replies View Related

RAC/ASM Clusterware Installation :: Configuration Of Archive Logs And Backup Using Flashback

Jun 8, 2012

As per Client requirement, i need to configure archive log and backups in flashback.

View 3 Replies View Related

Server Administration :: Too Many Archive Log Generation?

Mar 16, 2012

on weekends we have too many archive logs generated .i have taken the data of a week and found that average archive log generated from monday to friday is 7 files per day but on satuarday and sunday the average is 60 files and FG1 gets full. on weekends we have all type of backups running like incremental,archival and logical backups and on sunday we have full physical backup

what is the reason of too many archive log files generations at weekends. is it due to hot and logical backups , if yes then how ?

View 9 Replies View Related

Server Administration :: Deleting Archive Log In DR

Mar 6, 2012

I have a small question to be clarified. Is there any way to find out the "Applied Archive log files" in DR and "Deleting them through .

View 1 Replies View Related

Server Administration :: Archive Log Every 30 Seconds?

Mar 1, 2012

Our database was generating archivelog(50MB) every 30seconds! I think this is not normal because what I did is open our database, I was the only one who is connected, I'm not running anything, but our database is still generating archivelogs!

Our redo logs: 6groups 3members.

This are the things I saw on our alert logs:
- advanced to log sequence
- cannot allocate new log, sequence
- checkpoint not complete
- private strand flush not complete

What I did is change the log mode of our database to noarchivelog then open the database, then returned it to archivelog mode then that fixed the problem. But the thing is after 6hours its abnormal behavior goes back again.

View 3 Replies View Related

Server Administration :: Archive Mode In Database

Dec 28, 2011

what is the techniques to set the archive mode in oracle database on???????

View 4 Replies View Related

Server Administration :: Archive Log File Generating?

Jan 10, 2011

I want to know how many archive log generating in One hour at the peak time. We have 6 nodes RAC multiplex 2.

Is there are any query through which I can achieve the above purpose.

Note: As this is a prod instance client is not happy to implement Log Miner utility.

View 9 Replies View Related

Server Administration :: Changing Archive Log Destination?

Jul 6, 2011

Just to validate from you experts if in case I change the destination file of my archive logs, does it require a restart of the database?

View 10 Replies View Related

Server Administration :: Sudden Increase In Archive Log Size

Mar 26, 2010

We had a database (DB A)that is having version 9.2.0.6.0.This DB is having multiple tables and volume of 6 million in individual tables.Another database is also 9.2.0.6.0 (DB B), this DB has Mviews pointing to DB A. Mviews are refreshed in every 15 mins, with fast refresh option in 90% cases and remaining having complete refresh.

Last weekend we have migrated DB 2 to version 10.2.0.4.0 - 64bi and on another server.After version upgrade and DB migration complete refresh was done once for all mviews.

Now DB A is generating huge amount of archive log and also it's UNDO space is getting fully consumed causing performance issue and DB hang.what has gone wrong and what we can do to improve response of DB A and also to reduce size of Archive log ?

View 3 Replies View Related

Server Administration :: How To Offline Datafile In No Archive Mode

Oct 31, 2011

I want to drop a datafile in my test db which is in no archive mode,at first, i want to offline the datafile,but it failed,is there any way to do it?

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 3237
[code].......

View 8 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;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------

CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 3.19 0 38
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0

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

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
logfile

[Code]....

View 14 Replies View Related

Server Administration :: Archive Log File Sequence Number Reduced

Mar 28, 2012

We are facing a different issue in our database. From yesterday night, the archive log generated with 5 digit. But it supposed to be 6 digit. Hence we are not able to apply the logs in DR Location.

View 4 Replies View Related

Server Administration :: Running Out Of Space For Archive File System

Apr 2, 2012

In normal days size of archives generated in a day is 14-15GB. But since yesterday morning, almost 150GB of archives have been generated and are still getting generated(200MB every 1-2 minutes).

There was a sudden reboot of server yesterday morning. At that time there was heavy load of transactions on database. Can it be a reason that smon is still doing recovery? (I am not sure on this). Also, Undo tablespace is increased from 18 GB to 50 GB since yesterday (autoextend on).

Now we are running out of space for archive file system (can't delete them also until they are transferred to DR) Size of redo log is 200MB. This database supports around 2500 users.

performance wise I don't see any hit. Also wait events are normal. (only few db file sequential read) finding the query/session which are causing this much huge amount of archives?

View 7 Replies View Related

Server Administration :: Archive Log Generation Time Interval Or Size Wise?

Oct 21, 2011

i am using oracle 10g on solaris 10 os.currently archived log is generated by size wise 52 mb.i want to know whar is the best practice for archive log generation . it should be time interval or size wise.

View 1 Replies View Related

Application Express :: Turned Out By Disabling Javascript Whole Login Region Disappeared

Nov 8, 2012

Application Express 4.1.1.00.23
Internet Explorer - 8
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

I am about to embark on my first APEX development and have got far as the login screen. I disabled JavaScript just to see what would happen if someone had it disable, it turned out by disabling javascript the whole login region dissapeared. I am wondering how to develop the application so it works when javascript is disabled. I am using the cloudy theme. Not sure how to develop the application as its got to work with JavaScript disabled.

View 11 Replies View Related

Turning Table Model Into DDL To Import Into APEX?

May 1, 2013

We use apex and my professor wants us to import a table model into apex. everytime i try and import my table it says "your export file is not supported". i asked my professor what to do and he said "You should gen a ddl file from designer. Then use that to upload into apex and then run.

View 1 Replies View Related

Turning Off Trace On Specific Deadlocks Events?

Jun 17, 2013

Can I disable tracing just on deadlocks events on 11gR2?One of our applications provoke several deadlocks. I've warned the developers team several times, but it's taking time to solve it. However, these deadlocks generate trace files of several sizes (from 300M to 3G ..)The Deadlock Graph on them are very useful but the PROCESS STATE section are too long, and until the developers team fix the problem they are just filling up my user dump dest.  Can I disable them or disable the PROCESS STATE section from them?

View 2 Replies View Related

Forms :: New Form For Oracle Apps Turning Fields In Other Forms Black

Sep 23, 2011

I created a new form for Oracle Apps, At first when I ran the form from the application all the fields backgrounds were black, so I changed the background in the property palette to white and foreground to black.

Now it shows fine but when I close this form and open another those fields are now blacked out. What should I do, I know the problem comes from the new form.

View 5 Replies View Related

Unable To Deleted Archive Log File On Windows Server?

Sep 20, 2010

version: 10.2.0.4
OS: windows server 2003

I am not able to delete one month old archive log file manually on windows which doesn't having info about the standby on v$archived_log view of primary database. the sequence were already applied to the standby database. It shows the status as deleted in v$archived_log. while deleting the file manually. it showing an error like another program or person is using it.

View 10 Replies View Related

Server Utilities :: Remove Current Archive Logs

Sep 12, 2011

Developer is importing some large volumes of data. As the filesystem was filling up fast, I removed the all the archive log files. Will this affect the functioning of database? It is a development environment.

View 6 Replies View Related

How To Use Flashback Table

Jun 11, 2012

I have used FLASHBACK TABLE option in my oracle 10g database.

It works successfully but the indexes got system generated name after flashback table option.

how i get all the indexes with same name which was before flashback.

View 1 Replies View Related

PL/SQL :: Using Flashback Technology In Application

Oct 5, 2012

Can I use flashback in application, especially DBMS_FLASHBACK.TRANSACTION_BACKOUT. I import some information (from files) in my database and after that I want to revert that transaction(delete imported data). I did some test I took xid of the transaction from v$transaction and then executed

DBMS_FLASHBACK.TRANSACTION_BACKOUT

with that XID for parameter. Everything is fine but that time there was only one transaction, when there are many transaction how can I get the exact XID. I can use dbms_transaction.local_transaction_id to get information for transaction which is running. And when i tried to use flashback that way a deadlock occur and db killed the other transaction.

View 0 Replies View Related

No Flashback For Pluggable Databases?

May 9, 2013

I've just found out that 12cR1 will not (in all likelihood) allow "flashback database" for pluggable DBs. Am I the only one disappointed by that ? I use flashback db (+replay) a lot to revert and replay automated tests and I had plans to consolidate tenths of test environments into PDBs.

View 3 Replies View Related







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