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


ADVERTISEMENT

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

How To Change Default Destination Of Backup (archivelogs)

Jan 21, 2013

by default backup area is FRA, It can be change by db_recovery_file_dest FRA contains archivelog ,backupset,datafile,onlinelog folders..

NOW, i specially want to change backup dest. of archvelog to C: (suppose i have C , D, E, F , G) - (i know for archivelogs its log_archive_dest_N command can backup copies to other location but it also goes to default FRA )

backupset to D:
datafile to E:
onlinelog to F:
controlfile to G:
ALL SHOULD CONTAIN ONLY 1 DESTINATION NOT 2 FOR BACKUPS

View 12 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 :: 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 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 :: 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 :: Change Backup Datafile Name Into Its Original File Name?

Dec 16, 2011

how i can change backup datafile name into its original file name,bcoz at time backup datafile name is different and how i can change that name into its original datafile name so i apply recovery command in user managaed recovery..

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

Standby Archive Destination

Mar 14, 2013

My DB is in Max Protection mode. In case Standby archive destination gets full & oracle cannot archive standby redo log to standby archive destination, will the primary database shutdown?

View 1 Replies View Related

How To Find Archive Log Destination

May 8, 2013

I am unable to find out the location of my archive logs. The VALUE field is null.

SQL> show parameter log_archive_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  stringSQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2907
Next log sequence to archive   2908
Current log sequence           2909

When I do SQL>show parameter USE_DB_RECOVERY_FILE_DEST,I am not getting any result.
when I do *SQL>show parameter DB_RECOVERY_FILE_DEST, I am getting the result.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +BKUP_TSD1
db_recovery_file_dest_size           big integer 500GSo +BKUP_TSD1,

is this where my archive logs are present?

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

Standby Archive Destination Is Full?

Mar 29, 2013

If the standby archive destination is full, what will happen? Will the standby DB freeze? or will oracle stop redo transport from primary to standby?

DB Version: 11.2.0.2 running on RHEL5

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

Data Guard :: Setup/ Archive Destination Configuration

Mar 28, 2011

We have a request to configure data guard for databases on the production server. Here is my situation:

We have a backup strategy in place where the backups are being taken on a regular basis. Archive logs are deleted as soon as they are backed up.

My question now is , is there a way of configuring the Data guard in such a way that there would be no change to existing backup strategy (RMAN) and still duplicate the archive logs to another destination and not delete the archive logs by RMAN backup process on that destination while the first destination is deleted.

We will be deleting the logs in the second archive destination using a script which checks if the logs were applied.

View 2 Replies View Related

Backup & Recovery :: Block_change_tracking Change

Apr 3, 2013

SELECT filename, status, bytes
FROM v$block_change_tracking;

DISABLED

If we turn on block_change_tracking with RMAN, will it require a downtime?

View 10 Replies View Related

Backup & Recovery :: How To Determine The Rate Of Block Change

Aug 3, 2011

rdbms:oracle 10gr2
os:windows

with reference to

[URL]......

Quote:
A.2.2 Writing Backup Scripts for Disk and Tape Scenarios

As in the disk-only scenarios, the backup scripts in this section are categorized based on database workload. as stated very clearly it depends on the workload, more precisely the rate of block change. The size of the database can be found out based on formula from

[URL]....

so how would I know the rate of block change in order to know which script is suitable for me? I try to find out the rate of block change for the database based on change tracking file but based on

[URL].....

Quote:

The size of the change tracking file is proportional to the size of the database and the number of enabled threads of redo. The size is not related to the frequency of updates to the database. So how do I determine the rate of change? can the rate of block change based on size of archive logs?

I have the following information with me:

starting from 5/10/2011 0101
ending 5/18/2011 1114

this constitute to 9.5 days

F:
ecover_area>dir/w
1644 File(s) 27,942,770,176 bytes
2 Dir(s) 10,019,270,656 bytes free

average size of each file 27,942,770,176/1644
=16996818.841849148418491484184915

average size of each day's log = 27,942,770,176/9.5
=2941344229.0526315789473684210526
about 3G

If I have a database size of 92G, based on the archive log size of about 3G per day, can I conclude that a change of 3G/92G is considered as few block change?

View 1 Replies View Related

Backup & Recovery :: Block Change Tracking File

Sep 10, 2011

does, block change tracking file is read during incremental level 0 backup?

View 4 Replies View Related

Backup & Recovery :: Enabling Block Change Tracking?

Jun 20, 2012

i want to enable block change tracking as our incremental level1 backup take a lot of time but i have a worry which i found it on oracle support and tha is as follows Database Instance Hang at Database Checkpoint With Block Change Tracking Enabled. [ID 1326886.1]

View 2 Replies View Related

Backup & Recovery :: Block Change Tracking File When It Is Used

Oct 11, 2011

i did such commands

1. RMAN -> backup incremental level 0 database;

2. SQLPLUS -> alter database enable block change tracking using file '/home/oracle/block_change_tracking.tr';

3. RMAN -> backup incremental level 1 cumulative database;

4. RMAN -> backup incremental level 1 cumulative database;

5. RMAN -> backup incremental level 1 cumulative database;

and for such order i noticed that block change tracking file wasn't used for any cumulative backup. for each cumulative backup was done full scan over database.

it was used after i did incremental level 0 backup, and again incremental 1 cumulative.

if i want this feature to be usefull i should enable it before my incremental level 0, or i should do incremental level 0 immediately after i enable it?

View 6 Replies View Related

Storage Systems Used For Saving Archive And Backup Files Especially For Oracle Databases

Mar 5, 2013

what type of storage systems used for saving archive files and backup files "especially for oracle databases"

View 5 Replies View Related







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