Home » RDBMS Server » Backup & Recovery » restore whole backup with RMAN. help me!!!!!!
restore whole backup with RMAN. help me!!!!!! [message #159276] Fri, 17 February 2006 02:19 Go to next message
quytc
Messages: 81
Registered: November 2005
Location: Viet Nam
Member

Hi All,

My database name is A.
I make a whole backup by command:
run{
allocate channel d1 type disk;
setlimit channel d1 kbytes 2097150 maxopenfiles 32 readrate 200;
set maxcorrupt for datafile 1,2,3 to 0;
backup
full
skip inaccessible
tag b_db_full
filesperset 6
format 'D:/backup/df_t%t_s%s_p%p'
database;
release channel d1;
}

Then I delete Database A and recreate database the same A,then i run command
D:\oradim -NEW -sid A -startmode auto pfile 'd:\oradata\pfile\initC27.ora'

I using Rman so that restore and recover database.

D:\rman target sys/change_on_install nocatalog
run {
startup mount pfile='d:\hoan\pfile\initC27.ora';

allocate channel d1 type disk;

restore database;
recover database;

release channel d1;
}

But i getting error at this command.

Can anybody tell me why????

thanks,

Re: restore whole backup with RMAN. help me!!!!!! [message #159321 is a reply to message #159276] Fri, 17 February 2006 06:13 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> But i getting error at this command.
What error it may be?
Re: restore whole backup with RMAN. help me!!!!!! [message #159341 is a reply to message #159276] Fri, 17 February 2006 08:41 Go to previous message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
Have you create all the necessary directories and password file?

Furthur more, you'd better set dbid before restore db.
Previous Topic: how to recover truncated table using import mode
Next Topic: Other way of backup??
Goto Forum:
  


Current Time: Fri Apr 26 19:17:13 CDT 2024