Backup & Recovery :: Flash Recovery Area 9i

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


ADVERTISEMENT

Server Administration :: Flash Back Recovery Area

Mar 3, 2012

what is flash back recovery area? what is its main function and usage

View 1 Replies View Related

Server Administration :: How Much Flash Recovery Area Is Enough For Flashback

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

Backup & Recovery :: Cannot Update Recovery Area Reclaimable File List

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

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

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

Creating DB With Flash Recovery (Pros And Cons)

Mar 8, 2011

I am moving an Oracle DB (10.2.0.1) to a new server, by creating a blank DB and importing the data by user. I chose to create the new database with Flash Recovery activated (I haven't previously used this), but I'm having a nightmare when importing the data.

I encountered issues with the DB_RECOVERY_FILE_DEST_SIZE which I resolved by increasing the size of this parameter.

Next the import crawled along because of redo.log file errors "Checkpoint cannot complete". I'm assuming that I need to add redo.log files to accommodate this?

View 3 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 :: ORA-01139 / RESETLOGS Option Only Valid After Incomplete Database Recovery

Jan 25, 2011

SQL> alter database mount;
Database altered.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery

View 5 Replies View Related

Backup & Recovery :: RMAN Restore / Recovery To Previous Cold Backups

Aug 13, 2013

My scenario is: database is in archivelog mode.

I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also. What is the correct procedure to restore back to an old cold backup. Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.

I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database

( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)

Next tried to :

recover database archivelog tag 'DLYTUE'
( same outcome )

What is the correct rman procedure including should I remove old archive logs from working OS directory ? Also need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require i.e. : weds..

I have read about using the set until time option but how to I get absolute time from when cold backup completed if this is the correct procedure.

View 9 Replies View Related

Backup & Recovery :: ORA-00265 / Instance Recovery Required - Cannot Set ARCHIVELOG Mode

May 28, 2008

I need to make my database to ARCHIVELOG mode when i try it it gives below following error

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

View 9 Replies View Related

Backup & Recovery :: Initialization Of Internal Recovery Manager Package Failed

Sep 28, 2011

I have a database in Archivelog mode and Flashback mode. I am trying to connect to RMAN. But am getting the error

SQL> select name,log_mode,flashback_on from v$database
2 /

NAME LOG_MODE FLA
--------- ------------ ---
ORCL ARCHIVELOG YES

SQL> show user
USER is "SYS"
SQL> host rman target /
[code]....

View 16 Replies View Related

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed?

Feb 11, 2011

I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.

oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

[code]...

View 11 Replies View Related

Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed

Jun 25, 2013

While connecting to target database from stand database. I am getting below error.

calhost dbs]$ sqlplus system/oracle@proddb

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013

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

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

View 7 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

how to duplicate it on oracle 11g xe windows 2003

i have read from documentation but getting some error.

in last

E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe

[code]...

Backup-Based Duplication Without a Target and a Recovery Catalog Connection?

View 6 Replies View Related

Backup & Recovery :: Incomplete Recovery Shows RMAN-20207

Jan 4, 2012

when i performed incomplete recovery i try to set until time but it shows RMAN-20207:until time or recovery window shoubld be before resetlogs.

View 3 Replies View Related

Backup & Recovery :: Recovery Of Database From Crashed Host Server?

Jul 20, 2012

Backgroud info:

host server crashed.

Database was not cleanly shutdown.

Database is not in archivelog mode.

Datafiles were saved.

My goal:I want to recover the database based on the available files.

My approach:

Install new database.

ALTER DATABASE BACKUP CONTROLFILE TO TRACE.

shutdown database.

Place available dbf files in the location for new database, replacing existing files.

edit trace file to create new controlfile. Script is:

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "newdatabase" RESETLOGS NOARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292

[code]....

View 12 Replies View Related

Backup & Recovery :: Oracle11gR2 Not Allow To Open Database After Complete Recovery?

Feb 24, 2012

My database is in NOARCHIVELOG mode.I took whole DB backup ( cold).Then just after half an hour I ran following script.

RMAN> RUN { RESTORE DATABASE;RECOVER DATABASE;alter database open;}

Starting restore at 24-FEB-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=133 device type=DISK
channel ORA_DISK_1: starting datafile backup set restore

[code]...

Starting recover at 24-FEB-12
using channel ORA_DISK_1

starting media recovery archived log for thread 1 with sequence 2 is already on disk as file /u01/app/oracle/oradata/PROD/redo02.log
archived log file name=/u01/app/oracle/oradata/PROD/redo02.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:01

[code]...

Why do I need to specify an option at the first place?As my redo is intact, it is not incomplete recovery and, I do not want to generate new incarnation of my database.Why oracle simply not opening my database?

View 12 Replies View Related

Backup & Recovery :: RMAN-06428 / Recovery Catalog Is Not Installed

Jan 1, 2012

REGISTER DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/01/2012 11:02:40
RMAN-06428: recovery catalog is not installed

View 4 Replies View Related

Backup & Recovery :: Finding Rman Restore And Recovery Process?

Feb 7, 2011

I have a doubt regarding the process the RMAN follows for restore and recovery of the database.

My Level 0 full backup completes on Saturdays at around 11 am after taking 8 hours (It starts at 3am).On Sunday, I ask RMAN to restore (on a different box) till Saturday 11:30 am.Then, after the restore is successful, I recover it till 11:45 am.

The recovery also goes fine and Iam able to clone to test box.

Till what time is the database restored? I assume its till 11 am since the L0 backup finishes at 11 am though I have asked it to restore till 11:30 am

During the recovery, ONLY the archives generated between Saturday 3 am and till the time i asked for recovery (Saturday 11:45 am ) are required. But, checking the recovery log file, i was surprised to see that RMAN has restored archive files starting from Friday 9:30 pm (Much before the time the Level 0 backup even started).

why does RMAN require the old archive log files.

View 4 Replies View Related

Backup & Recovery :: ORA-00283 - Recovery Session Canceled Due To Errors

Dec 1, 2011

I have problem when i am trying to recover database

i am getting above error.

View 16 Replies View Related

Backup & Recovery :: ORA-19809 / Limit Exceeded For Recovery Files

Mar 22, 2012

while opening my database i got this error i already increase my db_recovery_file_dest_size but still i got this error

E:oracleproduct10.2.0db_1BIN>SET ORACLE_SID=LIVEDB
E:oracleproduct10.2.0db_1BIN>SQLPLUS
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 22 11:14:47 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Enter user-name: SYS AS SYSDBA
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[code].....

View 8 Replies View Related

Backup & Recovery :: Database Recovery With Missing One Of The Archivelog

Feb 10, 2011

I want to do the recovery of my database using the archive log files but one of the archive log in between is missing,

View 17 Replies View Related

Backup & Recovery :: ORA-19573 / Flashing During RMAN Recovery

May 5, 2011

I was trying to backup my database via RMAN and I had deleted a datafile from the database while it was still in open mode.Since I can't return back to mount stage again,I tried to bring the tablespace pertaining to that datafile offline and then restore backup of the tablespace but it's falshing error during recovery.

When I try to restore entire database,it is not even able to restore.

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 :: RAC - RMAN Restore And Recovery To New Hosts?

Mar 13, 2012

1. My RAC (old RAC) had got a failures from one node, then there was only one existing node now.

2. I configured a RAC (new RAC) on 2 other servers, both of them (old-RAC and new-RAC) has got same OS version, platform and Oracle version release.

3. I took a full backup yesterday plus archivelog in the node of old-Rac, configure NFS in new-Rac to make the backup within remote-share NFS.

The only problem still now that I've restore/recovery/duplicated single instance, not Rac. So, may you guide me to do it?

Information:

Old-Rac & New-Rac:
+ Cluster 11g: CFS
+ Database: 2 nodes with same instance name (cbs1-cbs2)
+ Location for CRS_HOME and ORACLE_HOME: Same to be.
+ Location of archivelog: Same to be (+ARCHIVE)

View 1 Replies View Related

Backup & Recovery :: ORA-01113 - File 5 Needs Media Recovery

May 11, 2012

I am trying to move my data files from one location to other as i ran out of space.

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATA.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATA.DBF';
Database Altered

SQL> alter database rename file 'C:oracleproduct10.2.0oradataSPF433SPF433ADW_DATATEMP.DBF' to 'D:OracleDatafilesSPF433SPF433ADW_DATATEMP.DBF'
Database Altered

Now when i am trying to run Alter Database open I get ORA-01113: file 5 needs media recovery error

View 11 Replies View Related

Recovery Manager (RMAN) :: Schema Recovery Using Backup?

May 2, 2013

Is this possible to recover a schema using RMAN bckup

View 5 Replies View Related

Backup & Recovery :: Restore Time Based Recovery

Apr 28, 2011

How can i take a cancel based recovery and time based recovery using rman. ?

View 3 Replies View Related







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