How To Capture TXs From Archive Logs To Replay On 10g Database

Feb 12, 2013

I am looking for a way to capture a TXs from one database and create a script or use it with tool, so we can capture TXs close to production while testing changes being implemented in database.

Env:

OS: Redhat Linux 5.0
DB: 10.2.0.4

Actually Requirement: We have active-active Golden Gate setup done for one of our DB and once a quarter we make changes in the database using DDL (CREATE / ALTER - TABLES, FUNCTIONS, TRIGGERS, etc). We are 24/7 environment and hence no downtime is affordable. What I like to know is a way to capture all TXs from one of the DB and create a script so we can run them while we are testing new changes in the database. Something like DBMS_WORKLOAD_CAPTURE Package (Available only after 11gR1) or some tools available in the market.

I also tried looking into Load Runner but felt it works with App tier than DB, I may be wrong there.

View 7 Replies


ADVERTISEMENT

Data Guard :: App Archive Logs Which Come From Primary Database?

Feb 16, 2012

If my standby database is read only mode,does it can app the archive logs which come from primary database?

View 2 Replies View Related

RMAN :: How To Backup Archive Logs In Standby Database

Nov 15, 2013

I trying to backup archive logs using rman in standby database. I'm able to backup archive logs using simple command it get's successfully completed. rman > BACKUP  ARCHIVELOG ALL When i'm  trying to do with keep command it's getting failed.I'm trying to do on physical standby databaseBACKUP  ARCHIVELOG ALL KEEP UNTIL TIME 'SYSDATE+100' TAG = 'TEST'.

View 1 Replies View Related

SQL & PL/SQL :: Archive Logs Filtering

Mar 3, 2011

I am using Oracle 11.2.1.0 version.I want to restrict archiving for some tables. I think NOLOGGING will solve this problem. Is there any option for restricting archiving.

For example, I have three tables called A, B and C. I want to archive only 2 tables A and B but not C.

View 6 Replies View Related

SQL & PL/SQL :: Archive Logs Restriction

May 2, 2010

I have one requirement saying that " Can we restrict archive logs for some tables".

View 7 Replies View Related

Deleting Archive Logs From Disk

Feb 13, 2013

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE     11.2.0.3.0     Production"
TNS for 32-bit Windows: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

We are in the process of setting up our backup policy. After the Archived Logs have been backed up, we need to delete them after 7 days. Also the actual files on disk.

RMAN does not delete the Archived Logs from disk.

View 6 Replies View Related

Resetting DB Backup Including Archive-logs?

May 10, 2011

My supervisor wants to remove all the archivelogs since it was just a test for 1 year the DB is not actually YET been used. Problem is they want it to be used as soon as possible w/o recreating again the database and just removing some data on tables and removed archive logs. how to safely removed the existing archived logs and create a full backup with archived fresh to sequence 1.

View 2 Replies View Related

RAC & Failsafe :: Archive Logs Are Missing In Hot Backup

Dec 9, 2012

We are using the following commands to take hot backup of our RAC database. Hot backup is fired by "backup" user on Linux system.

=======================
rman target / nocatalog <<EOF
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$backup_dir/$date/%F';
run {
allocate channel oem_backup_disk1 type disk format '$backup_dir/$date/%U';
#--Switch archive logs for all threads
[code]......
=======================
Due to which after command (used 2 times) "sql 'alter system archive log current';" I see the following lines in alert log 2 times. Because of this all the online logs are not getting archived (Missing 2 logs per day), the backup taken is unusable when restoring. I am worried about this. I there any to avoid this situation.
=======================
Errors in file /u01/oracle/admin/rac/udump/rac1_ora_3546.trc:
ORA-19504: failed to create file "+DATA/rac/1_32309_632680691.dbf"
ORA-17502: ksfdcre:4 Failed to create file +DATA/rac/1_32309_632680691.dbf
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
=======================

View 1 Replies View Related

Real Application Clusters :: Using FRA For Archive Logs?

Jan 21, 2013

Trying to find a best practices document from Oracle regarding the use of ASM to store the archivelogs in RAC. Most of the DBA's I know create a non-ASM location to store the archivelogs. Are there any considerations if you are also using dataguard?

View 5 Replies View Related

RMAN :: Delete Archive Logs On Standby

Aug 30, 2012

My oracle database is 11.2.0.2 RAC RDBMS on RHEL 5.6

We recently created physical standby database. How do we delete standby archive logs from physical standby?

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

Data Guard :: Redo Archive Logs Missing

Apr 23, 2013

While Configuring Data Guard for ORacle 10g (10.2.0.4) 64 bits on Windows 2007 Server 64 bits.I got few questions

1. What is the Default mode of Standby Database?

2. Should we Always Start Physical Standby Database to Recover Missing Redo Archive Log?

SQL> startup mount;
ORACLE instance started.

Total System Global Area 591396864 bytes
Fixed Size 2067496 bytes
Variable Size 163578840 bytes
Database Buffers 419430400 bytes
Redo Buffers 6320128 bytes
Database mounted.

SQL> alter database recover managed standby database disconnect from session;
Database altered.

3. When there are missing Redo Log Archives e.g.

----On Standby Database--------

SQL> SELECT RESETLOGS_ID,SEQUENCE#,STATUS,ARCHIVED FROM V$ARCHIVED_LOG
2 ORDER BY RESETLOGS_ID,SEQUENCE#;

RESETLOGS_ID SEQUENCE# S ARC
------------ ---------- - ---
812980008 15 A YES
812980008 16 A YES
812980008 17 A YES
812980008 18 A YES
[code]....

65 rows selected. Log 8, 9, 10, 11, 12, 13, 14, 15 are missing.

How to Apply / Recover These Logs on Standby Database?

View 11 Replies View Related

Recovery Manager (RMAN) :: Not Deleting Archive Logs

Aug 6, 2012

I have Oracle 10gR2 database on a windows server, I have scheduled rman backup for this database from Solaris server

set echo onrun {
crosscheck archivelog all;
backup check logical database plus archivelog;
delete noprompt obsolete device type DISK;
}
exit;

It is deleting the obsolete backup pieces but it is not deleting old archive logs (obsolete archive logs) and it is not even showing old archives as obsolete when I check thru report obsolete

View 7 Replies View Related

Data Guard :: Archive Logs Are Being Shipped But Not Applied

Jun 27, 2013

Currently I am at the point where the configuration has been completed, and I just need to sync the standby database to the primary one. I can see in the log files that the archive logs are being shipped, but they are not applied on the standby system. 

If I run "recover standby database;" manually in sqlplus I can see that it is trying to apply an archive log which is way too old (ORA-00279: change 9656498443 generated at 04/29/2008 08:45:08 needed for thread 1). I

n the alert log I can also see this error: Warning: Recovery target destination is in a sibling branch of the controlfile checkpoint. Recovery will only recover changes to datafiles. 

At this point I was thinking that the standby database might be on a different incarnation compared to the primary, but this is not the case, they are both in incarnation 6:6  6  MVF  4023175798 CURRENT 48493546257 13-06-21 

View 5 Replies View Related

Active Rollback Segments Generating Archive Logs?

Oct 25, 2012

I have a active rollback segments. I am not able to drop the undo tablespace of this segment and archive logs are getting created.

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

Recovery Manager (RMAN) :: Archive Logs Group By Dates

Apr 30, 2013

10.2.0.4
SLES 11

This is the folder groupings of our archivelog folder:

oracle@sdb51:/u01/app/oracle/flash_recovery_area/PROD/archivelog> ls -lt
total 32
drwxr-x--- 2 oracle oinstall 4096 2013-04-30 12:42 2013_04_30
drwxr-x--- 2 oracle oinstall 4096 2013-04-29 12:35 2013_04_29
drwxr-x--- 2 oracle oinstall 4096 2013-04-28 23:42 2013_04_28
drwxr-x--- 2 oracle oinstall 4096 2013-04-24 12:20 2013_04_24
drwxr-x--- 2 oracle oinstall 4096 2013-04-23 22:00 2013_04_23
drwxr-x--- 2 oracle oinstall 4096 2013-04-21 02:01 2013_04_21
drwxr-x--- 2 oracle oinstall 4096 2013-04-19 22:00 2013_04_19
drwxr-x--- 2 oracle oinstall 4096 2013-04-18 18:46 2013_04_18

Are there supposedly complete folder by dates each day? So I am missing archivelogs of 27th, 26th,25th, etc?

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

Backup & Recovery :: How To Get All Archive Logs In Backup Piece

Nov 8, 2008

Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece:

****
SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type,
s.controlfile_included from v$backup_set s, v$backup_piece p where
s.set_stamp=p.set_stamp and s.set_count=p.set_count and
p.handle='5mjv4do0_1_1';

[code]....

View 27 Replies View Related

PL/SQL :: Logs Of Modified Database Objects

Jul 25, 2012

i have a sequence for one of my table that this sequence's current value was 3000 yesterday but today when i checked current value of it, i surprised because the value changed to 50, can i check who changed my sequence? is exists any data dictionary that shows logs of modified database objects.

View 3 Replies View Related

How To Back Up Database Call Without Archived Logs

May 11, 2011

here i have an question with oracle database backup strategy.my question is

how to backup my oracle database call DB11G without archived logs while the database is open for user activity and also this should be the base for an incremental backup strategy?

View 5 Replies View Related

Backup Entire Database Without Archived Logs?

May 13, 2011

Backup your entire database, without archived logs, while the database is open for user activity. This backup should be the base for an incremental backup strategy

View 1 Replies View Related

Data Guard :: Logs Are Not Getting Applied In Standby Database

Sep 5, 2012

I have created a physical standby database and in it the logs are not getting applied.following is an extract of the standby alert log

Wed Sep 05 07:53:59 2012
Media Recovery Log /u01/oracle/oradata/ABC/archives/1_37638_765704228.arc
Error opening /u01/oracle/oradata/ABC/archives/1_37638_765704228.arc
Attempting refetch
Media Recovery Waiting for thread 1 sequence 37638
Fetching gap sequence in thread 1, gap sequence 37638-37643
Wed Sep 05 07:53:59 2012
RFS[46]: Assigned to RFS process 3081
RFS[46]: Allowing overwrite of partial archivelog for thread 1 sequence 37638
RFS[46]: Opened log for thread 1 sequence *37638* dbid 1723205832 branch 765704228
Wed Sep 05 07:55:34 2012
RFS[42]: Possible network disconnect with primary database

However, the archived files are getting copied to the standby server.I tried registering and recovering the logs but it also failed..Follows some of the information,

Primary
Oralce 11R2 EE
SQL> select max(sequence#) from v$log where archived='YES';
MAX(SEQUENCE#)
--------------
37668
[code]...

troubleshoot this and get the standby in sync.

View 12 Replies View Related

Data Guard :: Logs Get Shipped But Not Applied - Due To Primary Database Reset

Jul 22, 2013

I have a Sap Primry Database and also a standby db that was working perfectly.. We migrated the primary db from windows 2003 to windows 2008 and brought the primary db up.. I had to create a controlfile and do a system copy and had to reset the logs on the Primary.. All came up and when i checked the standby it was receiving the logs but after a month. i see that it was not applying the logs as I think because of the sequence number .. it stopped.

I did the ffg as per the attachement...My logs have been shipped across but not applied, But What worrries me is the log sequence number on my Primary

SQL> select max(sequence#),thread# from gv$archived_log group by thread#;

MAX(SEQUENCE#) THREAD#
-------------- ----------
27727 1

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

DataGuard - Archive Log Apply Gap In Physical Standby Database

Nov 23, 2010

1) The Primary Database is UP. The Physical Stand By Database is DOWN. The Current Archive Log Sequence is 99 in Primary.

We have to apply Archive Log from 51 to 99 to the Standby Database. But Unfortunately, there is no backup of those Archivelogs and the ArchiveLogs from 51 to 98 have got deleted at Primary end.

Now how will you apply these Archive Logs from Primary Database to Physical Standby Database?

Note : The Physical StandBy Database is DOWN.

View 2 Replies View Related

Data Guard :: Transfer Of Archive Log On Standby Database

Dec 9, 2010

I successfully created the standby database and the archive logs were properly moving on both the primary and the standby databases. For the proper transfer of the archive logs on the STANDBY database I used "FAL_CLIENT AND FAL_SERVER" in the pfile of the primary database specifying the location of the primary and the Standby respectively.

When I removed both the parameters from the pfile of the primary database still there was the transfer of the archive logs however there should not be "If I am not wrong" as I have removed both the parameters.

why there is still the transfer of the archive logs on the standby database.

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

Data Guard :: Archive To Complete Recovery On Standby Database

Oct 22, 2013

i have found an issue regarding log archiving on dest1. yesterday one sequence number 76871 not archive to dest1.alert logfile content as follow. i configure standby and ship archive manually with window copy command. i need this archive to complete recovery on standby database.

Mon Oct 21 09:29:28 2013
ARC2: Completed archiving log# 3 seq# 76869
Mon Oct 21 09:39:28 2013
Thread 1 advanced to log sequence 76871
Current log# 2 seq# 76871 mem# 0: D:ORACLEORADATAORC1REDO02.LOG
[code]....

View 7 Replies View Related

Data Guard :: Find Archive Log Gap From Primary Database Site?

Mar 23, 2013

I am new to Oracle and a beginner in Data Guard.

1) How to find archive log gap from Primary Database site?
2) Do I need the DB_UNIQUE_NAME when setting the LOG_ARCHIVE_DEST_2 ? What is the purpose of DB_UNIQUE_NAME in LOG_ARCHIVE_DEST parameter?
3) If archivelog gap happens standby db goes out of sync with the primary database. What does out of sync actually mean?
4) Primary DB knows where to transport redo data based on the location mentioned in LOG_ARCHIVE_DEST_n of Primary DB. Am I correct in my understanding?

View 3 Replies View Related







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