Recovery Area Cannot Be Used For Archive Log?
Sep 13, 2013
I`m using the the version 11.0.2.3 for testing. I read a line as below from the OCP book.
If none of the LOG_ARCHIVE_DEST_n parameters have been set, then transitioning. the database to archivelog mode will internally set LOG_ARCHIVE_DEST_10 to the flash recovery area, if it has been configured. In my database the fast recovery already been set as below.
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FASTRECOVERY
db_recovery_file_dest_size big integer 4248M
So I thought if I turn the database into archive log mode, then the log_archive_dest_10 will be set as the same value as db_recovery_dest.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> show parameter log_archive_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
See, after the database become archive, the log_archive_dest_10 still be empty. So is there any thing wrong with my understanding?
View 5 Replies
ADVERTISEMENT
Oct 18, 2012
I just switched my STBDY DB to a PRIMARY DB and I am ran the following:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
new RMAN configuration parameters are successfully stored
ORA-00245: control file backup operation failed
RMAN-08132: WARNING: cannot update recovery area reclaimable file list
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORARZULB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code]....
what causes this warning and how to get rid of it?
View 2 Replies
View Related
May 22, 2011
I want to change backup location for Oracle 9i Database. there is no flash recovery area in 9i, so i want the parameter which i can use to modify backup location to anywhere i want.
View 4 Replies
View Related
Mar 3, 2012
what is flash back recovery area? what is its main function and usage
View 1 Replies
View Related
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
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
Jun 6, 2012
after backup a full database ,the archive log need to keep all the time ?
View 3 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
May 30, 2012
How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies
View Related
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
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
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
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
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
Apr 23, 2012
I want to select the IDs which have no IN or PLANNING status in AREA 9
ID 1 has AREA 9 and STATUS IN so dont select
ID 2 SELECT
ID 3 has area 9 BUT STATUS is OUT so Select.
So if an ID has has IN or PLANNING status in AREA 9 i do not wish to see it!
CREATE TABLE DAN_T1
(
ID varchar(8),
AREA varchar(8),
UNIT varchar(8),
STATUS varchar(8)
)
INSERT INTO DAN_T1 (ID,AREA,UNIT,STATUS) VALUES (1,6,'AA','IN');
[code]......
ID AREA UNIT STATUS
16AAIN
17ABPLANNING
17ACOUT
19ADIN
25ACIN
25AAOUT
35BAPLANNING
36DAIN
35CAIN
39CGOUT
WANT:
ID
2
3
View 2 Replies
View Related
Jul 13, 2010
I want to use a java program in Bean Area.
But I can't understand the implement class and how it is implemented.
View 1 Replies
View Related
Oct 5, 2005
I have a prob installing Oracle 10g on Window 98 SE :
OUI-10133:Invalid staging area.
There are no top level components for Windows 98 available for installation in this staging area.
View 8 Replies
View Related
Jul 5, 2012
How to set up Apex SSO in your work area? I have been trying to set it up, but to no avail. I even tried asking support but still under oblivion.
Have you able to run this script before?
apex_sso.sql, apex_verify.sql, apex_sso_server.sql
My output for this scripts are good.
View 0 Replies
View Related
Sep 19, 2011
As I was observing the space issues on my db server. I found that there is lots of Trm and Trc file which is being created very much frequently. Due to this its consuming lots of space even the size of each files is not more than 1Mb.
For cleaning I am deleting all the trm and trc files mannully using DEL command Os level. How can i schedule the purging of trm and trc files.
View 3 Replies
View Related