Home » RDBMS Server » Backup & Recovery » About RMAN Backup.
About RMAN Backup. [message #245533] Mon, 18 June 2007 00:59 Go to next message
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..
Re: About RMAN Backup. [message #245541 is a reply to message #245533] Mon, 18 June 2007 01:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: About RMAN Backup. [message #245705 is a reply to message #245541] Mon, 18 June 2007 10:20 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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

Re: About RMAN Backup. [message #245724 is a reply to message #245707] Mon, 18 June 2007 12:09 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Haha;)

But you the leading one..I respect you.
Re: About RMAN Backup. [message #245824 is a reply to message #245705] Mon, 18 June 2007 22:44 Go to previous messageGo to next message
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.
Re: About RMAN Backup. [message #245830 is a reply to message #245824] Mon, 18 June 2007 23:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: About RMAN Backup. [message #246030 is a reply to message #245830] Tue, 19 June 2007 10:50 Go to previous message
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:
  


Current Time: Wed Dec 07 22:28:53 CST 2016

Total time taken to generate the page: 0.10070 seconds