Recovery Manager (RMAN) :: To Restore 11gr2 Database To Point In Time
Dec 15, 2012
I am trying to restore 11gr2 database to point in time. using following steps:
Control files are fine, that are not restored.
RMAN> run
{
set until time "to_time('2012-12-13 12:12:00','YYYY-MM-DD HH24:MI:SS')";
}
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
Here my problem is it is restore complete data what ever i was having, but i don't was it, i has to restore up to specified time only.
My dev application team iwant to test their application, and once that is done they want to recover to point in time. In my case they would do that after 9.0Am and once that is done they want the state of the database back to 9.0Am
What i am planning to do is:create a restore point at 9.0Am and once application testing is done recover until restore point. ..But i was suggested not to do that way instead my Lead want me to use just recover until timestampI asked what is the difference in doing in my way,the answer i got is by using recover until restore point, the recover process cannot apply incremental level 1 backups and it just restores to a point of incremental level 0, it looked strange to me.
i have the performed level 0 rman backup on 15th feb 2013, and after that i have incremental 1 and archives and controlfile backup. Before this no backup is the database.
Now i want to restore it to 12th feb 2013.so is there any ways to restore the database to that point time.can we restore controlfile to point in time.
How to restore database if rman catalog corrupted and we we dont have bacup of catalog db ..all the backup info are stored in catalog db for prod databases.
I need to recover a tablespace called "SBSECD01_MDS" (point-in-time).I need to determine and resolve dependencies.
select obj1_owner, obj1_name, obj1_type, ts1_name, ts2_name from sys.ts_pitr_check where (ts1_name = 'SBSECD01_MDS' and ts2_name != 'SBSECD01_MDS') or (ts1_name != 'SBSECD01_MDS' and ts2_name = 'SBSECD01_MDS');
i am now facing Tablespace Point-in-time subject. Doing some tests, the following problem appeared:
sql statement: alter database datafile 1 online sql statement: alter database datafile 3 online sql statement: alter database datafile 2 online sql statement: alter database datafile 10 online [code]....
ORA-01516: nonexistent log file, data file, or temporary file "10"I am using the following command to restore one of my tablespaces:
RMAN> run { 2> recover tablespace tbs_testes_pitr until time "to_date('25/07/2012 19:50:00','dd/mm/yyyy hh24:mi:ss')" 3> auxiliary destination '+DATA'; 4> }The error described at the begin of this thread only appears at the end of the operation. I did some research, and the error ORA-01516 indicates that the datafile is not known by the database. When this error appears, i have to do a media recovery on datafile 10, which in fact exists, and is the datafile atached to the tablespace that i am trying to recover
We want to keep the Guaranteed restore point for week but unfortunately we don't have enough flash space in the server. Is it possible to backup the flashback log(restore point logs) through rman and send bkp file to tape? how to restore the database in new server until Guaranteed restore point.
I am getting error when i try to restore one tablespace using RMAN.
RMAN> restore tablespace test;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "test": expecting one of: "double-quoted-string, identifier, single-quoted-string" RMAN-01007: at line 1 column 20 file: standard input
But it's working for other tablespace
RMAN> restore tablespace users;
Starting restore at 10-OCT-12 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/product/11.2.0/db_1/dbs/TEST/users01.dbf
7 of days ago Full backup has been taken to disk due to issues with tape devices.3 days ago tape devices have been fixed and we switched to CommVault managed tape backups. CommVault calls RMAN with following command:
These backups done successfully.Then archivelog backup taken similar way.But when I issue RESTORE DATABASE PREVIEW SUMMARY; RMAN starts with Full backup set, though newer Incremental Level 0 ones are available.Why it does not use these newer ones?
But on my o.s I have archivelogs from log sequence 104 - 206 (I have not deleted them for long 1 month). It is not showing form 104 - 178. Since control file record time is 7 days it doesnt keep old archivelogs history.(i.e from 104-206) Hence it is showing only from 179 - 206
My question is
1)If we use rman recovery catalog will these info is maintained forever until deleted. And can i see them in list command. (i.e from 104-206) 2)If i use rman catalog then from where did rman get the information of archives and backup (for list and restore command) from catalog or from control file.
I am using RMAN with a recovery catalog option on a separate Database. My question is
When we use catalog does RMAN keep the information in Control file of the Target Database as well or only in recovery catalog? I am asking this in case We lost the database which contains the recovery catalog what to do?
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?
Can I register a database say MYDB in datacenter1 with two different catalogs i.e., I have one rman catalog a datacenter1 location and another rman catalog in datacenter2 location. So, can I register MYDB to rman catalogs at datacenter1 and datacenter2. If, so how can we keep rman catalogs at datacenter1 and datacenter2 in sync. For MYDB rman backups I just want to use local rman catalog which is datacenter1. But I just want to keep a redundant copy of the rman catalog.
===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of register command at 08/15/2013 19:48:59RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of full resync command on default channel at 08/15/2013 19:48:59ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.fORA- [code][....
Can't start the Database and can't backup What is happening now. My database connection is not stable so can't do the backup.I spent two days trying unsuccessfully.
check the following print screen : [test@localhost ~]$ xhost +access control disabled, clients can connect from any host[test@localhost ~]$ [test@localhost ~]$ [test@localhost ~]$ su - rootPassword: [root@localhost ~]# [root@localhost ~]# [root@localhost ~]# su - oracle[oracle@localhost ~]$ [oracle@localhost ~]$ export ORACLE_SID=db11gr2[oracle@localhost ~]$ [oracle@localhost ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1[oracle@localhost ~]$
I have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
I like to duplicate the database DATABASEA to DATABASEB and need to be run in same server. I tried to bounce the listener & databaseb instance multiple times but no lucky.
Step 1 : The instance DATABASEB is in Nomount stage
Step 2 :
==> tnsping DATABASEB TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-SEP-2012 07:36:54 Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = client )(PORT = 1521)) (CONNECT_DATA = ( SERVER = DEDICATED) (SERVICE_NAME = DATABASEB)(UR=A))) OK (10 msec)
Step 3 :
==> rman target sys/*****@DATABASEA auxiliary sys/********@DATABASEB Recovery Manager: Release 11.2.0.2.0 - Production on Tue Sep 11 07:37:50 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: DATABASEA (DBID=1723462779) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
I have four Oracle 8i databases that can not be removed because of client requirements. These 8i databases have there own RMAN catalog which is 10G (Originally there were Oracle 8i, 9i and 10g databases using it but are now moved to 11g catalog). Databases are backing up fine. However, all the other databases are using the RMAN 11g Catalog. I want to point the Oracle 8i databases to point to the RMAN 11g recovery catalog. I created an 8i schema, however, i'm getting the following error message: RMAN-06429: RCVCAT database is not compatible with this version of RMAN. however, I wanted to put the question out there to see if there are any work arounds.
I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?
Can i keep the database name as ASMDB in another Machine ?
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.
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).