OraFAQ Forum: Backup & Recovery » About RMAN Backup.

Home » RDBMS Server » Backup & Recovery » About RMAN Backup.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

About RMAN Backup. [message #245533]

Mon, 18 June 2007 00:59

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I have made OS command to backup datafiles. Now how I can made it entry in RMAN Repository(I use Control file as repository instead of recovery catalog)?

Another topic is I have RMAN full database backup. Now I have created new database. And I want to import these full backup to new database. How I can do this. I know using expdp/impdp it is quite easy. But I want to know the way of RMAN..

Report message to a moderator

Re: About RMAN Backup. [message #245541 is a reply to message #245533]

Mon, 18 June 2007 01:27

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ Backup and Recovery Reference, CATALOG command
2/ There are many recovery scenarii in Database Backup and Recovery Advanced User's Guide

Regards
Michel

Report message to a moderator

Re: About RMAN Backup. [message #245705 is a reply to message #245541]

Mon, 18 June 2007 10:20

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

Now how I can made it entry in RMAN Repository(I use Control file as repository instead of recovery catalog)?

You dont need to make any entry for backup in Control file Oracle will write that.

Quote:

Another topic is I have RMAN full database backup. Now I have created new database. And I want to import these full backup to new database.

Its not possible to restore you one database data to another one,but you can make another database by existing backup.

If you have usermanaged backup means copy of all files (controlfile,datafiles,tempfiles,undo,redologs,pfile) then you can replace your new database by these files.

[Updated on: Mon, 18 June 2007 10:21]

Report message to a moderator

Re: About RMAN Backup. [message #245707 is a reply to message #245705]

Mon, 18 June 2007 10:28

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

You dont need to make any entry for backup in Control file Oracle will write that.

Good point, you need catalog against control only when you use a backup control file or recreate your control file.

Quote:

Its not possible to restore you one database data to another one,but you can make another database by existing backup.

Ha ah! You changed your message when I was writing mine. Good joke. Your previous sentence was not so well. Damn! I miss an opportunity to bite you on RMAN. Smile

Regards
Michel

Report message to a moderator

Re: About RMAN Backup. [message #245724 is a reply to message #245707]

Mon, 18 June 2007 12:09

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Haha;)

But you the leading one..I respect you.

Report message to a moderator

Re: About RMAN Backup. [message #245824 is a reply to message #245705]

Mon, 18 June 2007 22:44

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

DreamzZ wrote on Mon, 18 June 2007 21:20

Its not possible to restore you one database data to another one,but you can make another database by existing backup.

Please explain a bit.

Report message to a moderator

Re: About RMAN Backup. [message #245830 is a reply to message #245824]

Mon, 18 June 2007 23:38

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

He just wanted to say that you can't extract the data from the backup to insert them into another database but you can create a new database from the backup.

Regards
Michel

Report message to a moderator

Re: About RMAN Backup. [message #246030 is a reply to message #245830]

Tue, 19 June 2007 10:50

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Micheal explain mine answer Thanks micheal;

Quote:

but you can make another database by existing backup.

Move this backup to another machine.
make initfile.
connect to rman
startup database in nomount
restore controlfiles
then open database in mount
restore database
recover database
and then open your database.

Thats what i meant there.

[Updated on: Tue, 19 June 2007 10:51]

Report message to a moderator

Previous Topic:	difinition of oracle
Next Topic:	Re: Open Database Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 14:47:22 CDT 2024