I've got a database I need to restore from a cold backup, but I don't have a copy of the multiplexed members of the redo groups - each group has 2 members, and we've only got a backup of the first.
I know this won't stop the database from starting, and I can recreate them, but for ease can you copy and rename a redo log file from a multiplexed copy to correct location like you can with a control file?
oracle 10.2.1 under windows 7 , today my friend format the server , but he have backup cold backup actually he take backup for all c:\ drive and i found that there is a oradata dir in this backup , so now i install new operating system win 7 and then i will create a database with the same name and then should i do a NID and restore the backup (cold)
how to do that ? i mean if i have database 10g under windows and this o.s is formatted we have backup of all c:\ drive which contain all oradata dir ? how can i restore this database
the database size is 3GB and contain the same default tablespace system,sysaux,undo,temp,users?
Difference between cold backup and cold cloning?
View 2 Replies View RelatedMy 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.
I have an oracle 8i recovery scenario. I have database cold backups of MONDAY and WEDNESDAY evenings. backup contains control files, data files, redo files
Database runs in Archive log mode and all archives of the month are available. Hard disk crashed on SATURDAY
all archive logs are still available at different location. Control files are not backed up to trace or file name or automatically means no backup control file (except ones in cold backups described above)
restoring all files from cold backup of either MONDAY or WEDNESDAY (I recovered to Wednesday) leaves nothing to recover. Querying V$RECOVER_FILE returns nothing. All log sequences higher to the number nnn displayed as result of ARCHIVE LOG LIST are present at correct location in correct format
My question is how do i ROLL Forward the Database from WEDNESDAY to SATURDAY in the above scenario.
we have scheduled cold backup for our database. is there any solution to resolve below mentioned errors other than RMAN hot backup or shutdown abort ?
Sat Jan 26 00:20:55 2013
Active call for process 3939 user 'oracle' program 'oracle@proddb.fgho.com'
SHUTDOWN: waiting for active calls to complete.
Sat Jan 26 01:15:59 2013
SHUTDOWN: Active sessions prevent database close operation
Instance shutdown aborted
We are having 10gR2 DR setup,
We are planning for the cold backup of primary database on every sunday,
Does it going to affect DR sync if primary database is not availabe at the time of cold backup.
can we restore database from obsolete backup using rman
View 2 Replies View RelatedDoes the full cold backup of rman include online redologs?
So that at the time of recovery when i restore the database the online redologs also restored to that point?
I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed
*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
configure channel 2 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************
*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************
********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************
Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.
I need to restore a backup of database A from into Database B. Both have the same names. Database B is already up and running.
I have a full rman backup of Database A ( it was taken with a recovery catalog which I don't have access to now as it was deleted ). I just have the full backup pieces including the control files. Is it possible to recover this database into Database B from this stand point.
I was thinking
2. Shutdown database B
3. Mount database B. It has same name as Database A.
4. With RMAN restore controlfile. Will a new controlfile be created from the backup directory I have the rman pieces for the full backup in ?
can we restore oracle database using backup using emc bcv technology? i dont have experience with bcv.
View 1 Replies View RelatedWe have 11gR2 2 node RAC on Linux. ASM and OMF is used for database. The database on it is backed up using RMAN. We want to test the RMAN backup by restoring it to a new database on same server.
View 5 Replies View Related I have 2 server install oracle : server 1 and server 2
server 1 run database DB01
i use rman backup DB01 ( this command : BACKUP FULL DATABASE PLUS ARCHIVELOG DELETE INPUT; ) and move ( The database backup pieces , Controlfile backup piece, The parameter file i.e init.ora file) to server 2 .
At server 2 :
After start database with init.ora file and restore controlfile error :
RMAN-03002: failure of restore command at 07/22/2011 02:56:04
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
I would like to know is there any way i can create a Backup of Oracle Db and Restore it Like SQL has?
View 1 Replies View RelatedCan we restore a database if we have only the datafiles available? The database has been dropped but we have just the datafiles with NO system, sysaux,users and undo datafiles that were saved after taking the database offline and then dropping the database. I know this is strange but if possible, I want to see if we can retrieve some of the data from those datafiles to another database. BTW, There is no backup available for this database except the dbf files on OS.
View 3 Replies View RelatedI have a task which is to get an export of an account.Easy, you will say, use Data Pump but I have not the database only a complete RMAN backup of it (including control file and spfile). Easy once again, restore the database and export but I have not the space to restore the complete database.
all segments of the account are in a couple of tablespaces I know the name (and I know I have space enough to restore them).
Unfortunately, I don't know the other tablespace names (but of course SYSTEM and SYSAUX), in particular I don't know the name of the undo tablespace and, of course, I have no connection with the source database and no way to know these tablespace names.
So here's the question, how can I restore part of the database (SYSTEM, SYSAUX, undo tablespace and a couple of other ones) from a complete backup without knowing the name of the undo tablespace and of the tablespaces I don't need?
We have a database server running oracle 12G on linux which is the production then we have a DR using the same version of DB and linux, I want to restore from tape into the DR from the production backup. the UNIX admin has restored already from tape the rman backup, i would like to know what are the steps to restore the backup from tape, also the DR database server was created identical like production using the same spfile etc.
were do i copy restored file into on the DR server? also then in RMAN do i just start the DR database and run the command restore database? what else do i need?
I have taken cold back-up of a complete database using below rcv from a server.
RMAN>
connect target /
run{
set command id to 'bkp_EMCPROD_db';
allocate channel c1 type 'sbt_tape' parms="BLKSIZE=1048576, ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.opt)";
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
backup database format 'db_t%t_T%T_d%d_s%s_p%p.db';
backup current controlfile format 'ct_t%t_T%T_d%d_s%s.ctl';
release channel c1;
}
I need to restore this back-up on another server of the same Database Name. Below is the rcv which my sr. dba asked me to look into for the restore.
/* From the new server to restore the back-up */
RMAN>
connect target "rman/xxxxx@emcprod"
connect auxiliary /
run {
set until time "to_date('Nov 03 2011 19:00:00','Mon DD YYYY HH24:MI:SS')";
allocate auxiliary channel c1 type 'sbt_tape' parms="ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin64/tdpo.sacsun8.opt)";
restore database;
}
I am running into a strange issue with a restore of an RMAN backup into a duplicate database,.
1). I restored the control file from a recent backup.
2). restored the datafiles ( about 800)
Now when doing a recover, its giving me an error of Future recovery of a datafile marked datafile marked 350.
There is schedule cold backup was not taken successfully due to some DBF files are skipped and it would not copied to destination location? destination location is same server itself not for another remote server.
Total - 35 DBF files,
skipped - 4 DBF files
what could be issues? what are the points should be troubleshooting?
i need to restore a database on another database with another SID.
View 1 Replies View RelatedI am new in oracle. I want to restore my database in oracle 10g enterprise. Actually i have a backup file(.bkp file) from oracle 10g xe and now i wanna restore in oracle 10g enterprise.
View 5 Replies View RelatedQuestion: does oracle recover past the scn mentioned in the control file or do you need recover using backup control file for it? No specific scn,time specified.
Scenario: Restore database on new server + copy archivelogs from original to minimize data loss.
Backup : 5 AM
Archivelogs: 7 AM
New server:
Configure dummy instance
Restore spfile from tape
Restore controlfile from tape: SCN 5AM
Restore database (no scn specified) from tape: : SCN 5AM
Copy archivelogs from old server to archivelog new location: SCN 7AM.
Recover database
open database -> SCN 5AM or 7AM?
Does it recover till SCN 5AM (controlfile) or SCN 7AM (latest scn in copied archivelog)
Is there anyway to backup Flashback Data Archive (FBDA) data and can be restore on new database. I cannot find Oracle's document or any document explain about backing up this data.
View 6 Replies View RelatedIn order for the following command to work:
> recover database using backup control file until cancel;
what command must precede it, is it:
> alter database backup control file to trace;
I am doing some test, seeking your expert opinion.I have a database and have the following backup strategy.
1) Database running in archive log mode.
2) First I backup all the table space excluding one tablespace 'DP_TS_LOB'.
RMAN> CONFIGURE EXCLUDE FOR TABLESPACE 'DP_TS_LOBS';
RMAN> BACKUP DATABASE;
3) I take a separate Backup of DP_TS_LOB tablespace.
RMAN> BACKUP TABLESPACE DP_TS_LOB;
4) I backup all the archived redo logs.
RMAN> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
RMAN> backup archivelog all delete input;
Now I wanted to restore the database from the backup excluding the DP_TS_LOB and bring it up and running. DP_TS_LOB is huge and used only on certain work flows. I don't want the database to be down until we restore DP_TS_LOB. I wanted to restore all the other tablespace and bring the database up operational and restore and recover the DP_TS_LOB tablespace datafile's in background taking the datafiles of DP_TS_LOB tablespace offline.I tried the following but unsuccessful.
RMAN> restore controlfile to 'g:ctl_bckctl_01' from autobackup;
RMAN> restore spfile to 'g:ctl_bckspfile' from autobackup;
RMAN> sql "create PFILE = ''G:ctl_bckPFILE'' from SPFILE = ''G:ctl_bckSPFILE''";
Update the new parameter with new control file name. Copied the control file and parameter file to corresponding location.
RMAN> startup nomount pfile=D:appdivaproduct11.1.0db_1databasepfile;
RMAN> restore database skip tablespace 'dp_ts_lob';
RMAN> alter database mount;
RMAN> sql 'alter database datafile 8 offline'; ==> datafile of DP_TS_LOB tablespace.
First I assumed "Recover Database" will only recover online database files. But got the following error.
RMAN> recover database;
Starting recover at 27-JUL-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:23:03
RMAN-06094: datafile 8 must be restored
Then I tried recovering data file separately, but same error.
RMAN> recover datafile 1;
Starting recover at 27-JUL-11
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/27/2011 18:24:30
RMAN-06067: RECOVER DATABASE required with a backup or created control file
URL....I'm practicing for the OCP test and one of the questions is that there is a backup from yesterday and the last archived logs are from the day before yesterday not mentioned if it's cold or hot backup.
If its a cold backup - cant we recover it? is it a must to have the archived redo logs also when recovering a cold backup? That sounds not logical since those logs are made only for a hot backup. URL.....
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.
View 1 Replies View Relatedrestored from tape a backup then issued rman command
RMAN> restore database;
Starting restore at 21-MAY-13
Finished restore at 21-MAY-13
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 05/21/2013 15:36:15
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u02/oradata/system01.dbf'
[code]....