Backup & Recovery :: How To Apply Archive On Consistent Backup

Feb 15, 2011

Actually, i have test database open in read only and i want to apply archive files carry from production database at daily level.
When i'm going for recovery, since database is already in consistent state, it is not asking for recovery.

View 2 Replies


ADVERTISEMENT

Backup & Recovery :: Apply The Backup Command To Each Database?

Feb 14, 2012

I am admin of my actual server and I want to backup all databases for later use. For that this is my approach.

1 - List all databases on the system

2 - Apply the backup command to each database

View 2 Replies View Related

Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?

May 30, 2012

How can be identify a particular archive-log file have backup or not from rman catalog?

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

Backup & Recovery :: RMAN Hot Backup Plus Archive Log Files?

Jan 11, 2008

I had a production db with archive logging enabled

SQL> select name,status
2 from v$archived_log;

NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A

[code]...

So i need to restore archivelogs by using sequence

RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup

RMAN >backup database plus archivelog all delete input;

but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)

my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?

RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }

View 4 Replies View Related

Backup & Recovery :: ORA-01194 / File 1 Needs More Recovery To Be Consistent

May 16, 2012

I am trying to open the database bur gettinf following errors

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'C:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF'

SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 289406976 bytes

[code]....

View 1 Replies View Related

Backup & Recovery :: How To Extract Archive Log Backup Set

Jun 1, 2012

There is a archive log backupset,and the backup set contains many archive log file,and now i want extract to a directory,how can i do?

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 86.20M DISK 00:00:21 02-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120602T113622
Piece Name: /u02/rman_bak/20120602/archive_log_t784899382_s4_p1

View 6 Replies View Related

Backup & Recovery :: Backup Archive Log Files

Aug 4, 2011

I have one question to clarify regarding backup.

There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?

View 10 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 :: Keep Archive Log All The Time?

Jun 6, 2012

after backup a full database ,the archive log need to keep all the time ?

View 3 Replies View Related

Backup & Recovery :: Archive Log Format

Jun 9, 2012

The log_archive_format parameter is set to %t_%s_%r.dbf,but the archive log is generate as o1_mf_1_10_7x6lby27_.arc, why?

SQL> show parameters log_archive_format;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_format string %t_%s_%r.dbf

[oracle@hxl 2012_06_09]$ ls -lr
total 93468
-rw-r----- 1 oracle oinstall 51229184 Jun 9 10:00 o1_mf_1_9_7x5ckqbv_.arc
-rw-r----- 1 oracle oinstall 43131392 Jun 9 09:01 o1_mf_1_8_7x581vgo_.arc
-rw-r----- 1 oracle oinstall 74240 Jun 9 21:06 o1_mf_1_11_7x6lksyp_.arc
-rw-r----- 1 oracle oinstall 1131008 Jun 9 21:02 o1_mf_1_10_7x6lby27_.arc

View 4 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 :: Archive Log File Using RMAN

Feb 1, 2012

When we see archive log destination is full , in that case how to backup archive log files using RMAN ?

View 1 Replies View Related

Backup & Recovery :: Archive Log File Missed

Jan 30, 2012

Today we have taken a backup of the Live database, due to some issue, it got deleted before applying into the Disaster Recovery Location.

View 12 Replies View Related

Backup & Recovery :: Creating Archive Log In Network Drive?

Jul 29, 2011

create Oracle archived log to network drive instead of Local drive.

Is there anyway that i can get my archive log created on network drive instead of local drive.

As we want to save our storage space and want to keep archivelog on network.

Is there a way that if Archive log creation on Network drives falis, Oracle create Archivelog on Local drive.

We are running Data warehouse and on daily basis we have 22 to 25 Gig of Archive log created

View 14 Replies View Related

Backup & Recovery :: Change Archive Log Mode During DB Running?

Aug 24, 2011

changing archive mode during DB running.Before in 9.2, 'ALTER SYSTEM ARCHIVE LOG START/STOP' is available for this job. But, after 10g/11g, it cause 'archive log stop has been deprecated'.

However, for my practice, I need to estimate archived logs size before backup them, so I need to stop archive log for a while and enable it later during DB running.

I check Oracle documents, it only mentions changing archive log mode at DB mounted but not open.

View 12 Replies View Related

Backup & Recovery :: How To Change Archive Log Destination In Oracle 10g

Jan 11, 2013

I want to change my archive log destination currently my database its in archive mode and this archive log detail as under

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination F:archivelogs

[Code]...

this my f drive space is full so i want to change this my archive destination to my another g drive so how can i do this.and if i change this my archive destination does its affect any problem while recover my database in future.

View 1 Replies View Related

Backup & Recovery :: How To Check Archive Log Destination Utilization In Oracle 9i

Oct 24, 2011

Is there any view in oracle 9i like V$RECOVERY_FILE_DEST where we can check the archive destination space utilization from database end ?

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 :: SCN Based Backup Do RMAN Generate Backup From Archivelogs

Oct 18, 2012

understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???

View 1 Replies View Related

Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile

Jan 24, 2011

I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am

other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)

if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)

I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)

View 17 Replies View Related

Find Whether Backup Taken Consistent Or Not

Mar 22, 2011

i am given a database to recover. The person who gave me the database says that he has taken a full hot backup of the database on 19th march and i was also given the archives of the incremental backups until 21march now how can i check if the backup he has taken is consistent or not? after unzipping the available archivelogfiles on and after 19th(THE DATE on which full backup was taken) i tried to open the database using

>startup mount

>recover database using backup controlfile until cancel;

here i got an error and i found out that the archive log files after 13 march are missing.i queried select * from v$log and found that the last log was on 13 March. is this the correct way to say that, since this returned 13 MARCH the database is taken full backup on 13 March itself?

but the person who has taken full backup is saying that he has taken the full backup on 19th march.

how can i confirm whether the full backup taken on 19th was not consistent concretely? are there any other ways to find whether a backup taken is consistent or not i am not using RMAN backup i want to know the procedure when i have to do it manually

View 1 Replies View Related

Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup

Feb 10, 2011

We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?

We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.

View 11 Replies View Related

Server Utilities :: Data Pump - How To Take The Consistent Backup

Jun 22, 2010

In oracle 10g data pump (Logical backup) How to take the consistent backup. What parameter can we use?

View 2 Replies View Related

Backup & Recovery :: ORA-16004 / Backup Database Requires Recovery

Oct 20, 2011

Here is the details

[oracle@localhost dbs]$ export ORACLE_SID=stby
[oracle@localhost dbs]$ sqlplus '/as sysdba'
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Oct 20 09:47:34 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> !
[oracle@localhost dbs]$ pwd
/oraeng/app/oracle/product/10.2.0/dbs
[oracle@localhost dbs]$ exit
exit

[code].....

View 1 Replies View Related

Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window

Oct 18, 2011

I have problem on using "delete obsolete" in RMAN.

First, let describe my backup configuration.

1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog

The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.

In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.

I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.

I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.

The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.

View 6 Replies View Related

Backup & Recovery :: RMAN Duplicate Set Until Time Using Wrong Backup Piece Name To Restore?

Feb 26, 2012

We are doing RMAN Duplicate set until time to refresh daily our test database for our developers and it taking long time to finish. We noticed on the restore log that RMAN was using a day old old backup pieces to refresh the test database and don't immediately use the latest backup pieces instead.

For additional details here's the rman duplicate command we are using which we run daily(mon-sat) at 4am once daily full backup on production completed.

RMAN Duplicate commands:
run
{
set until time "to_date(to_char(sysdate,'Mon DD YYYY') || ' 04:00:00', 'Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel ch1 type disk;
duplicate target database to testdb;
}
exit

Is there a way on how to let RMAN use the latest backup pieces instead?

View 1 Replies View Related

Backup & Recovery :: ORA-01655 On CREATE USER (splitted From RMAN Backup Error)

Dec 22, 2012

I created a tablespace named 'data'.During create a new user with default tablespace 'data',I got following error message:

SQL> create user rman identified by rman default tablespace data
temporary tablespace temp

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01655: unable to extend cluster SYS.C_USER# by 2 in tablespace

OS:Windows XP
Oracle 10g

View 2 Replies View Related

Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?

Jan 28, 2011

I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...

brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap

The backup goes thru but i get this erro on the end...

BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28

[code]...

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42

[code]...

Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman

[code]...

I have check on the system .. There is not file like that but thwre on on the db i,e

eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1

View 13 Replies View Related

Backup & Recovery :: Error While Backup On Windows 7 Client Of Oracle 11gR2 Database

May 2, 2011

I have facing problem while taking backup on Windows 7 client of Oracle 11g R2 database. I have installed oracle 11gR2 for windows on windows 7 machine. I have created a directory like below in database.

On Database Server

SQL> create directory win_expdp_dir as 'd:expimp';

Directory created.

SQL> grant read, write on directory win_expdp_dir to lab;

Grant succeeded.

On Windows 7 machine (client machine)

D:appproduct11.2.0client_1BIN>expdp lab/lab@wbdata.wbh-db11g DIRECTORY=win_expdp_dir DUMPFILE=lab.dmp LOGFILE=lab.log
Export: Release 11.2.0.1.0 - Production on Mon May 2 12:51:44 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.

I have give all sharing rights on d:expimp directory. My main question is why i'm getting this error. Is there any thing missing in setup. how to take export on windows 7 client.

View 6 Replies View Related







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