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


ADVERTISEMENT

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

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

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

Backup & Recovery :: Restore With Archive Log Only

Aug 9, 2013

We have a 9.2.8.0 database in archive log mode. We want to restore that db to a specified point in time. What is the fastest way to do it ?

View 3 Replies View Related

Backup & Recovery :: Restore Archive Log

Aug 18, 2011

I need to restore few archivelog from one of stage database to refresh dev database.

Stage database got refreshd before try to restore the arch files.

Now stage database does not contain arch sequence information.

I tried to restore arch fiels from tape using catalog connection. Is there any way to restore

channel c1: sid=521 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 6.5 (2007071006)

Starting restore at 18-AUG-11
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 08/18/2011 09:20:21
RMAN-06004: ORACLE error from recovery catalog database:
RMAN-20242: specification does not match any archive log in the recovery catalog

View 3 Replies View Related

Backup & Recovery :: Difference Between Flashback Database And Incomplete Recover

Jul 23, 2012

What is difference between the flashback database(10g later) and incomplete recover?

View 5 Replies View Related

Backup & Recovery :: How To Recover Before 15 Minutes Table Data From Flashback

Mar 23, 2012

I delete some of the data from a table unfortunately and make commit on that on my production server.

getting back my all data of this table only of last 15 minutes.

View 6 Replies View Related

Data Guard :: Flashback Snapshot Standby Database Or New Primary Database After Failover?

Aug 30, 2013

If flashback is enable in physical standby database 1. If we failover at 11AM can I flash back NEW primary database to 6 AM ? 2. if I convert physically standby database to snapshot standby database at 11AM ,  Can I  flashback snapshot standby database to 6 AM and do some works on it (DML operations)  then   converting the snapshot standby database into physical standby database ?  

View 1 Replies View Related

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

Backup & Recovery :: Restore Database From Obsolete Backup Using RMAN

Dec 13, 2011

can we restore database from obsolete backup using rman

View 2 Replies View Related

Backup & Recovery :: Restore RMAN Backup Of Database To A New Database

Jan 25, 2011

I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed

*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
configure channel 2 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************

*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************

********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************

Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.

View 2 Replies View Related

Backup & Recovery :: Restore Backup Of Database A From Into B

Jun 16, 2013

I need to restore a backup of database A from into Database B. Both have the same names. Database B is already up and running.

I have a full rman backup of Database A ( it was taken with a recovery catalog which I don't have access to now as it was deleted ). I just have the full backup pieces including the control files. Is it possible to recover this database into Database B from this stand point.

I was thinking

2. Shutdown database B
3. Mount database B. It has same name as Database A.
4. With RMAN restore controlfile. Will a new controlfile be created from the backup directory I have the rman pieces for the full backup in ?

View 9 Replies View Related

Restore Database From Backup Using Emc Bcv Technology?

Oct 15, 2010

can we restore oracle database using backup using emc bcv technology? i dont have experience with bcv.

View 1 Replies View Related

To Restore Database From A Cold Backup

Feb 28, 2013

I've got a database I need to restore from a cold backup, but I don't have a copy of the multiplexed members of the redo groups - each group has 2 members, and we've only got a backup of the first.

I know this won't stop the database from starting, and I can recreate them, but for ease can you copy and rename a redo log file from a multiplexed copy to correct location like you can with a control file?

View 2 Replies View Related

RMAN :: Restore Backup In Different Database On Same RAC

Nov 6, 2013

We have 11gR2 2 node RAC on Linux. ASM and OMF is used for database. The database on it is backed up using RMAN. We want to test the RMAN backup by restoring it to a new database on same server.

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

Error While Backup And Restore Database To New Host?

Jul 22, 2011

I have 2 server install oracle : server 1 and server 2

server 1 run database DB01

i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .

At server 2 :

After start database with init.ora file and restore controlfile error :

RMAN-03002: failure of restore command at 07/22/2011 02:56:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

View 1 Replies View Related

Backup & Recovery :: Restore Oracle Database

Feb 12, 2012

I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?

View 1 Replies View Related

Backup & Recovery :: Restore Datafiles In Another Database

Jun 29, 2011

Can we restore a database if we have only the datafiles available? The database has been dropped but we have just the datafiles with NO system, sysaux,users and undo datafiles that were saved after taking the database offline and then dropping the database. I know this is strange but if possible, I want to see if we can retrieve some of the data from those datafiles to another database. BTW, There is no backup available for this database except the dbf files on OS.

View 3 Replies View Related

Backup & Recovery :: Partly Restore A Database?

Mar 21, 2012

I have a task which is to get an export of an account.Easy, you will say, use Data Pump but I have not the database only a complete RMAN backup of it (including control file and spfile). Easy once again, restore the database and export but I have not the space to restore the complete database.

all segments of the account are in a couple of tablespaces I know the name (and I know I have space enough to restore them).

Unfortunately, I don't know the other tablespace names (but of course SYSTEM and SYSAUX), in particular I don't know the name of the undo tablespace and, of course, I have no connection with the source database and no way to know these tablespace names.

So here's the question, how can I restore part of the database (SYSTEM, SYSAUX, undo tablespace and a couple of other ones) from a complete backup without knowing the name of the undo tablespace and of the tablespaces I don't need?

View 5 Replies View Related

Backup & Recovery :: How To Restore Database From Different Server

May 30, 2013

We have a database server running oracle 12G on linux which is the production then we have a DR using the same version of DB and linux, I want to restore from tape into the DR from the production backup. the UNIX admin has restored already from tape the rman backup, i would like to know what are the steps to restore the backup from tape, also the DR database server was created identical like production using the same spfile etc.

were do i copy restored file into on the DR server? also then in RMAN do i just start the DR database and run the command restore database? what else do i need?

View 7 Replies View Related

Backup & Recovery :: Restore Database From Another Server

Nov 14, 2011

I have taken cold back-up of a complete database using below rcv from a server.

RMAN>
connect target /
run{
set command id to 'bkp_EMCPROD_db';
allocate channel c1 type 'sbt_tape' parms="BLKSIZE=1048576, ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
backup database format 'db_t%t_T%T_d%d_s%s_p%p.db';
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
release channel c1;
}

I need to restore this back-up on another server of the same Database Name. Below is the rcv which my sr. dba asked me to look into for the restore.

/* From the new server to restore the back-up */
RMAN>
connect target "rman/xxxxx@emcprod"
connect auxiliary /
run {
set until time "to_date('Nov 03 2011 19:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel c1 type 'sbt_tape' parms="ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.sacsun8.opt)";
restore database;
}

View 3 Replies View Related

Restore Of RMAN Backup Into Duplicate Database

Oct 5, 2013

I am running into a strange issue with a restore of an RMAN backup into a duplicate database,. 

1). I restored the control file from a recent backup.
 2). restored the datafiles ( about 800) 

Now when doing a recover, its giving me an error of Future recovery of a datafile marked datafile marked 350.

View 1 Replies View Related

Backup & Recovery :: Restore A Database On Another Database With Another SID?

Aug 24, 2011

i need to restore a database on another database with another SID.

View 1 Replies View Related

Backup & Recovery :: Restore Database In Oracle 10g Enterprise?

Apr 13, 2011

I am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.

View 5 Replies View Related

Backup & Recovery :: Restore Database / Copied Archivelogs

Dec 14, 2011

Question: does oracle recover past the scn mentioned in the control file or do you need recover using backup control file for it? No specific scn,time specified.

Scenario: Restore database on new server + copy archivelogs from original to minimize data loss.
Backup : 5 AM
Archivelogs: 7 AM

New server:
Configure dummy instance
Restore spfile from tape
Restore controlfile from tape: SCN 5AM
Restore database (no scn specified) from tape: : SCN 5AM
Copy archivelogs from old server to archivelog new location: SCN 7AM.
Recover database
open database -> SCN 5AM or 7AM?

Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)

View 2 Replies View Related

Data Guard :: How To Restore Archive_log From Tape Backup

Aug 16, 2012

I got missed the archivelog from primary DB.now its got deleted. But now it is stored in Tape_backup. i don't know about tape backup. how to access and restore the archive_log from tape backup. My tape setup is Legato..ultrium.

os:Hp-ux
DB:Oracle9i

View 6 Replies View Related

Backup & Recovery :: Restore Database Using Control File Until Cancel

May 17, 2012

In order for the following command to work:

> recover database using backup control file until cancel;

what command must precede it, is it:

> alter database backup control file to trace;

View 4 Replies View Related

Backup & Recovery :: Restore And Recover Database Excluding Tablespace

Jul 27, 2011

I am doing some test, seeking your expert opinion.I have a database and have the following backup strategy.

1) Database running in archive log mode.
2) First I backup all the table space excluding one tablespace 'DP_TS_LOB'.

RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'DP_TS_LOBS';
RMAN> BACKUP DATABASE;

3) I take a separate Backup of DP_TS_LOB tablespace.

RMAN> BACKUP TABLESPACE DP_TS_LOB;

4) I backup all the archived redo logs.

RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> backup archivelog all delete input;

Now I wanted to restore the database from the backup excluding the DP_TS_LOB and bring it up and running. DP_TS_LOB is huge and used only on certain work flows. I don't want the database to be down until we restore DP_TS_LOB. I wanted to restore all the other tablespace and bring the database up operational and restore and recover the DP_TS_LOB tablespace datafile's in background taking the datafiles of DP_TS_LOB tablespace offline.I tried the following but unsuccessful.

RMAN> restore controlfile to 'g:ctl_bckctl_01' from autobackup;
RMAN> restore spfile to 'g:ctl_bckspfile' from autobackup;
RMAN> sql "create PFILE = ''G:ctl_bckPFILE'' from SPFILE = ''G:ctl_bckSPFILE''";

Update the new parameter with new control file name. Copied the control file and parameter file to corresponding location.

RMAN> startup nomount pfile=D:appdivaproduct11.1.0db_1databasepfile;
RMAN> restore database skip tablespace 'dp_ts_lob';
RMAN> alter database mount;
RMAN> sql 'alter database datafile 8 offline'; ==> datafile of DP_TS_LOB tablespace.

First I assumed "Recover Database" will only recover online database files. But got the following error.

RMAN> recover database;

Starting recover at 27-JUL-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:23:03
RMAN-06094: datafile 8 must be restored

Then I tried recovering data file separately, but same error.

RMAN> recover datafile 1;

Starting recover at 27-JUL-11
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:24:30
RMAN-06067: RECOVER DATABASE required with a backup or created control file

View 4 Replies View Related







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