We are trying to restore a backup from a database in another host. We created the same directories structure, we copied the init.ora and the current dump of the control file (cf_SID.bak) to its place. We started the database in nomount option and then we run RMAN to restore it:
% rman nocatalog
RMAN> connect target sys/pwd@xxx

run {
allocate channel 'dev_0' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=ORACLE8,OB2APPNAME=oss)';
allocate channel 'dev_1' type 'sbt_tape'
parms 'ENV=(OB2BARTYPE=ORACLE8,OB2APPNAME=oss)';
sql "alter database mount";
set until time = 'date_string';
restore database;
recover database;
sql "alter database open resetlogs";
sql "alter database open";
release channel 'dev_0';
release channel 'dev_1';
}

We got several errors during the compilation of restore like: no backup or copy of datafile xxx found to restore.

    Requires Free Membership to View

An exact error message would have been preferrable. But I'm assuming that your error is occurring simply because RMAN does not know which backup sets are required to restore a datafile. In this case, it doesn't know which backup sets are required to restore *any* datafile.

That is most likely because the backup of the control file that you are using doesn't contain this information. It would be best to use a current control file, not a backup control file for this operation.

If you have the source database still available, another method you may want to try is to duplicate the database with RMAN. The following chapter in the docs has all of the details: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmdupdb.htm#441628

This was first published in March 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: