Home » RDBMS Server » Backup & Recovery » RMAN Syntax (Oracle 10g , Solaris)
RMAN Syntax [message #277128] Mon, 29 October 2007 01:12 Go to next message
panchpan
Messages: 34
Registered: October 2007
Member
Hello - I am very new to Oracle and solaris both.

I am just curious to know how do we take backup of database. I went through the books/google etc and there is huge information and tough to catch them quickly. I found RMAN is one of the best way to take backup.
I have created a db using dbca 'dev102ee' and ran below commands from rman

#ORACLE_SID=dev102ee
#rman TARGET=SYS

RMAN> run
{
shutdown immediate;
startup mount;
backup database;
sql 'alter database open';
backup current controlfile;
sql 'alter database backup controlfile to TRACE';
}

The command is finished successfully with some messages. My questions
1) Where can I find now that backup is lying?
2) Could you please share the quick commands used for backup and restoration with syntax. Reading books is really tough to figure out correctly what they say.
3) I read many places about OEM. Where can I see it on solaris?

Many Thanks!
Re: RMAN Syntax [message #277129 is a reply to message #277128] Mon, 29 October 2007 01:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/toc.htm
Re: RMAN Syntax [message #277146 is a reply to message #277128] Mon, 29 October 2007 02:01 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Reading books is really tough to figure out correctly what they say.

Oracle is not a toy you have to read and understand the concepts even if you use OEM.
In this latter, you also have to read EM documentation.

In addition, read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: flashback table to timestamp
Next Topic: rman charecter set to we8mswin1252
Goto Forum:
  


Current Time: Mon May 20 12:09:56 CDT 2024