Solved

RMAN daily cold backup

Posted on 2009-04-03
8
944 Views
Last Modified: 2012-05-06
We take RMAN cold backup daily.
we have the RMAN cold backup.(oracle 10g rel 10) on Unix env.
today is friday and we have to restore the development database from wednesdays cold backup.

How can we proceed with this task.

we have all the backups on disk.
0
Comment
Question by:ballioballi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
8 Comments
 
LVL 48

Accepted Solution

by:
schwertner earned 250 total points
ID: 24060664

The datapieces 03FCOI5E_1_1 and  04FCOIHE_1_1  
were transferred to the new host machine shvertner.
 
       
Transfer INIT.ORA file from the target to the cloning instance.
Change all data file locations mentioned in the INIT.ORA file.
 
Transfer the password file PWDmain.ora   file. (&\ora92\database)
 
 
RMAN is alias for connecting to the duplicate database. 
 
 
SQL> connect sys/reks@rman as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.
 
Total System Global Area  118562548 bytes
Fixed Size                   454388 bytes
Variable Size              83886080 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
SQL>
SQL>alter database mount
RMAN>connect   target sys/reks@rman
 
 
    run{ 
      allocate channel c1 type disk; 
      restore controlfile; 
    } 
 
 
 
Change the password file with the password file from the target database to avoid the error message:
 
SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-01991: invalid password file 'D:\oracle\ora92\DATABASE\PWDmain.ORA' 
 
Now you have to use the passwords from the old target database (in my case the MAIN instance from the main computer!
 
 
SQL> alter database mount;
 
 
RMAN> @restore.txt
 
 
    run {  
     allocate channel c1 type disk; 
     allocate channel c2 type disk; 
     allocate channel c3 type disk;  
     set newname for datafile         1  to 'D:\ORACLE\ORADATA\MAIN\SYSTEM01.DBF';
     set newname for datafile         2  to 'D:\ORACLE\ORADATA\MAIN\UNDOTBS01.DBF';
     set newname for datafile         3  to 'D:\ORACLE\ORADATA\MAIN\CWMLITE01.DBF';
     set newname for datafile         4  to 'D:\ORACLE\ORADATA\MAIN\DRSYS01.DBF';
     set newname for datafile         5  to 'D:\ORACLE\ORADATA\MAIN\EXAMPLE01.DBF';
     set newname for datafile         6  to 'D:\ORACLE\ORADATA\MAIN\INDX01.DBF';
     set newname for datafile         7  to 'D:\ORACLE\ORADATA\MAIN\ODM01.DBF';
     set newname for datafile         8  to 'D:\ORACLE\ORADATA\MAIN\TOOLS01.DBF';
     set newname for datafile         9  to 'D:\ORACLE\ORADATA\MAIN\USERS01.DBF';
     set newname for datafile        10  to 'D:\ORACLE\ORADATA\MAIN\XDB01.DBF';
     set newname for datafile        11  to 'D:\ORACLE\ORADATA\MAIN\TSDC00.DBF';
     set newname for datafile        12  to 'D:\ORACLE\ORADATA\MAIN\TSDCONTACTS00.DBF';
     set newname for datafile        13  to 'D:\ORACLE\ORADATA\MAIN\TSICONTACTS00.DBF';
     set newname for datafile        14  to 'D:\ORACLE\ORADATA\MAIN\TSDCONTAINER00.DBF';
     set newname for datafile        15  to 'D:\ORACLE\ORADATA\MAIN\TSICONTAINER00.DBF';
     set newname for datafile        16  to 'D:\ORACLE\ORADATA\MAIN\TSDDOCUMENTS00.DBF';
     set newname for datafile        17  to 'D:\ORACLE\ORADATA\MAIN\TSIDOCUMENTS00.DBF';
     set newname for datafile        18  to 'D:\ORACLE\ORADATA\MAIN\TSDIDMAP00.DBF';
     set newname for datafile        19  to 'D:\ORACLE\ORADATA\MAIN\TSIIDMAP00.DBF';
     set newname for datafile        20  to 'D:\ORACLE\ORADATA\MAIN\TSDMEDICAL00.DBF';
     set newname for datafile        21  to 'D:\ORACLE\ORADATA\MAIN\TSIMEDICAL00.DBF';
     set newname for datafile        22  to 'D:\ORACLE\ORADATA\MAIN\TSDSYSTEM00.DBF';
     set newname for datafile        23  to 'D:\ORACLE\ORADATA\MAIN\TSISYSTEM00.DBF';
     set newname for datafile        24  to 'D:\ORACLE\ORADATA\MAIN\TSDAUDIT00.DBF';
     set newname for datafile        25  to 'D:\ORACLE\ORADATA\MAIN\TSIAUDIT00.DBF';
     set newname for datafile        26  to 'D:\ORACLE\ORADATA\MAIN\TSROLLBACKSMALL00.DBF';
     set newname for datafile        27  to 'D:\ORACLE\ORADATA\MAIN\TSROLLBACKLARGE00.DBF';
     set newname for datafile        28  to 'D:\ORACLE\ORADATA\MAIN\TSIC00.DBF';
     set newname for datafile        29  to 'D:\ORACLE\ORADATA\MAIN\TSDT00.DBF';
     set newname for datafile        30  to 'D:\ORACLE\ORADATA\MAIN\TSIT00.DBF';
     set newname for datafile        31  to 'D:\ORACLE\ORADATA\MAIN\TSDD00.DBF';
     set newname for datafile        32  to 'D:\ORACLE\ORADATA\MAIN\TSID00.DBF';
     set newname for datafile        33  to 'D:\ORACLE\ORADATA\MAIN\TSDI00.DBF';
     set newname for datafile        34  to 'D:\ORACLE\ORADATA\MAIN\TSII00.DBF';
     set newname for datafile        35  to 'D:\ORACLE\ORADATA\MAIN\TSDM00.DBF';
     set newname for datafile        36  to 'D:\ORACLE\ORADATA\MAIN\TSIM00.DBF';
     set newname for datafile        37  to 'D:\ORACLE\ORADATA\MAIN\TSDS00.DBF';
     set newname for datafile        38  to 'D:\ORACLE\ORADATA\MAIN\TSIS00.DBF';
     set newname for datafile        39  to 'D:\ORACLE\ORADATA\MAIN\TSDA00.DBF';
     set newname for datafile        40  to 'D:\ORACLE\ORADATA\MAIN\TSIA00.DBF';
     set newname for datafile        41  to 'D:\ORACLE\ORADATA\MAIN\TSRS00.DBF';
     set newname for datafile        42  to 'D:\ORACLE\ORADATA\MAIN\TSRL00.DBF'; 
     restore database; 
    }
 
 
SQL> select name from v$datafile;
 
D:\ORACLE\ORADATA\MAIN\SYSTEM01.DBF
D:\ORACLE\ORADATA\MAIN\UNDOTBS01.DBF
D:\ORACLE\ORADATA\MAIN\CWMLITE01.DBF
D:\ORACLE\ORADATA\MAIN\DRSYS01.DBF
D:\ORACLE\ORADATA\MAIN\EXAMPLE01.DBF
D:\ORACLE\ORADATA\MAIN\INDX01.DBF
D:\ORACLE\ORADATA\MAIN\ODM01.DBF
D:\ORACLE\ORADATA\MAIN\TOOLS01.DBF
D:\ORACLE\ORADATA\MAIN\USERS01.DBF
D:\ORACLE\ORADATA\MAIN\XDB01.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDC00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDCONTACTS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSICONTACTS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDCONTAINER00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSICONTAINER00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDDOCUMENTS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIDOCUMENTS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDIDMAP00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIIDMAP00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDMEDICAL00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIMEDICAL00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDSYSTEM00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSISYSTEM00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDAUDIT00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIAUDIT00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSROLLBACKSMALL00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSROLLBACKLARGE00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIC00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDT00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIT00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDD00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSID00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDI00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSII00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDM00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIM00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDA00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIA00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSRS00.DBF
E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSRL00.DBF
 
42 rows selected.
===============================================================
 
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\SYSTEM01.DBF'   to 'D:\ORACLE\ORADATA\MAIN\SYSTEM01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\UNDOTBS01.DBF'  to 'D:\ORACLE\ORADATA\MAIN\UNDOTBS01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\CWMLITE01.DBF'  to 'D:\ORACLE\ORADATA\MAIN\CWMLITE01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\DRSYS01.DBF'    to 'D:\ORACLE\ORADATA\MAIN\DRSYS01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\EXAMPLE01.DBF'  to 'D:\ORACLE\ORADATA\MAIN\EXAMPLE01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\INDX01.DBF'     to 'D:\ORACLE\ORADATA\MAIN\INDX01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\ODM01.DBF'      to 'D:\ORACLE\ORADATA\MAIN\ODM01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TOOLS01.DBF'    to 'D:\ORACLE\ORADATA\MAIN\TOOLS01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\USERS01.DBF'  to 'D:\ORACLE\ORADATA\MAIN\USERS01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\XDB01.DBF'  to 'D:\ORACLE\ORADATA\MAIN\XDB01.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDC00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDC00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDCONTACTS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDCONTACTS00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSICONTACTS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSICONTACTS00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDCONTAINER00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDCONTAINER00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSICONTAINER00.DBF'  to 'D:\ORACLE\ORADATA\MAIN\TSICONTAINER00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDDOCUMENTS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDDOCUMENTS00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIDOCUMENTS00.DBF'  to 'D:\ORACLE\ORADATA\MAIN\TSIDOCUMENTS00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDIDMAP00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDIDMAP00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIIDMAP00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIIDMAP00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDMEDICAL00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDMEDICAL00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIMEDICAL00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIMEDICAL00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDSYSTEM00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDSYSTEM00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSISYSTEM00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSISYSTEM00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDAUDIT00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDAUDIT00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIAUDIT00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIAUDIT00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSROLLBACKSMALL00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSROLLBACKSMALL00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSROLLBACKLARGE00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSROLLBACKLARGE00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIC00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIC00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDT00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDT00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIT00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIT00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDD00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDD00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSID00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSID00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDI00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDI00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSII00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSII00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDM00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDM00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIM00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIM00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDS00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIS00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSDA00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSDA00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSIA00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSIA00.DBF';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSRS00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSRS00.DBF';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\TSRL00.DBF' to 'D:\ORACLE\ORADATA\MAIN\TSRL00.DBF'; 
 
 
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\REDO01.LOG' to 'D:\ORACLE\ORADATA\MAIN\REDO01.LOG';
alter database rename file 'E:\ORACLE_DB_MAIN\ORADATA\MAIN\REDO02.LOG' to 'D:\ORACLE\ORADATA\MAIN\REDO02.LOG';
alter database rename file  'E:\ORACLE_DB_MAIN\ORADATA\MAIN\REDO03.LOG' to 'D:\ORACLE\ORADATA\MAIN\REDO03.LOG';
 
SQL> select name from v$datafile;
 
NAME
------------------------------------------------------------
D:\ORACLE\ORADATA\MAIN\SYSTEM01.DBF
D:\ORACLE\ORADATA\MAIN\UNDOTBS01.DBF
D:\ORACLE\ORADATA\MAIN\CWMLITE01.DBF
D:\ORACLE\ORADATA\MAIN\DRSYS01.DBF
D:\ORACLE\ORADATA\MAIN\EXAMPLE01.DBF
D:\ORACLE\ORADATA\MAIN\INDX01.DBF
D:\ORACLE\ORADATA\MAIN\ODM01.DBF
D:\ORACLE\ORADATA\MAIN\TOOLS01.DBF
D:\ORACLE\ORADATA\MAIN\USERS01.DBF
D:\ORACLE\ORADATA\MAIN\XDB01.DBF
D:\ORACLE\ORADATA\MAIN\TSDC00.DBF
D:\ORACLE\ORADATA\MAIN\TSDCONTACTS00.DBF
D:\ORACLE\ORADATA\MAIN\TSICONTACTS00.DBF
D:\ORACLE\ORADATA\MAIN\TSDCONTAINER00.DBF
D:\ORACLE\ORADATA\MAIN\TSICONTAINER00.DBF
D:\ORACLE\ORADATA\MAIN\TSDDOCUMENTS00.DBF
D:\ORACLE\ORADATA\MAIN\TSIDOCUMENTS00.DBF
D:\ORACLE\ORADATA\MAIN\TSDIDMAP00.DBF
D:\ORACLE\ORADATA\MAIN\TSIIDMAP00.DBF
D:\ORACLE\ORADATA\MAIN\TSDMEDICAL00.DBF
D:\ORACLE\ORADATA\MAIN\TSIMEDICAL00.DBF
D:\ORACLE\ORADATA\MAIN\TSDSYSTEM00.DBF
D:\ORACLE\ORADATA\MAIN\TSISYSTEM00.DBF
D:\ORACLE\ORADATA\MAIN\TSDAUDIT00.DBF
D:\ORACLE\ORADATA\MAIN\TSIAUDIT00.DBF
D:\ORACLE\ORADATA\MAIN\TSROLLBACKSMALL00.DBF
D:\ORACLE\ORADATA\MAIN\TSROLLBACKLARGE00.DBF
D:\ORACLE\ORADATA\MAIN\TSIC00.DBF
D:\ORACLE\ORADATA\MAIN\TSDT00.DBF
D:\ORACLE\ORADATA\MAIN\TSIT00.DBF
D:\ORACLE\ORADATA\MAIN\TSDD00.DBF
D:\ORACLE\ORADATA\MAIN\TSID00.DBF
D:\ORACLE\ORADATA\MAIN\TSDI00.DBF
D:\ORACLE\ORADATA\MAIN\TSII00.DBF
D:\ORACLE\ORADATA\MAIN\TSDM00.DBF
D:\ORACLE\ORADATA\MAIN\TSIM00.DBF
D:\ORACLE\ORADATA\MAIN\TSDS00.DBF
D:\ORACLE\ORADATA\MAIN\TSIS00.DBF
D:\ORACLE\ORADATA\MAIN\TSDA00.DBF
D:\ORACLE\ORADATA\MAIN\TSIA00.DBF
D:\ORACLE\ORADATA\MAIN\TSRS00.DBF
D:\ORACLE\ORADATA\MAIN\TSRL00.DBF
 
42 rows selected.
 
===============================================================
 
SQL> alter database open resetlogs;
 
RESETLOGS Specify RESETLOGS to reset the current log sequence number to 1
and discards any redo information that was not applied during recovery, ensuring
that it will never be applied. This effectively discards all changes that are in the redo
log, but not in the database.
You must specify RESETLOGS to open the database after performing media
recovery with an incomplete recovery using the RECOVER clause or with a backup
control file. After opening the database with this clause, you should perform a
complete database backup.
 
 
THE DATABASE IS RESTORED AT THE DIFFERENT NODE (HOST)

Open in new window

0
 

Author Comment

by:ballioballi
ID: 24060829
Thanks for your prompt reply. Let me explain you the whole scenario
 

we already have the cold backup of wednesday and thursday.

Now, where I am  mentioning that we have to restorie the tuesday night's cold backup.

Please note today is friday and we ran two coldback's after the original backup we are talking here.


we have to restore from tuesday nights backup (we now have tuesday,wednesday and thursday's backup on the location).


Please advice.
0
 

Author Comment

by:ballioballi
ID: 24060916
I mean how the repository come to know about the 2 day's back
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 40

Expert Comment

by:mrjoltcola
ID: 24060965
use restore until time ... and recover until time ...

Or set the UNTIL TIME or SCN or SEQUENCE

RUN
{
  SET UNTIL SCN 1000;    
  # or
  # SET UNTIL TIME 'Mar 29 2009 05:00:00';
  RESTORE DATABASE;
  RECOVER DATABASE;
}

0
 

Author Comment

by:ballioballi
ID: 24063183

This is a cold backup.Does this incomplete recovery will work for the cold backup ?

Why I have to recover when I have the cold backup?
One more question:- How can I find the SCN for that cold backup ended two days ago ?

Thanks,
0
 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 250 total points
ID: 24063353
Right, you don't have to recover from cold backup.

And you can just specifiy the time, or the backupset as well. Do you know the specific backupset #? If so, specify that.

RMAN> list backupset;

I prefer to use TIME in most cases, but there are cases where someone may have corrupted something and you may know the exact SCN from log miner.

To preview the restore without actually performing it, say I wanted to restore until Apr 1.
Note, PREVIEW keyword is important, or it will start the restore.

RMAN> restore database until time '01-APR-09' preview;    

Review which backupset / pieces RMAN will choose.

Then if you are ready, reissue the command without the preview (with database closed of course).

0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question