Home » RDBMS Server » Backup & Recovery » RMAN BACK UP (ORACLE 10.2.0/Solaris 5)
RMAN BACK UP [message #343198] Tue, 26 August 2008 11:05 Go to next message
glanson
Messages: 11
Registered: August 2008
Junior Member

Can any one help me to do simple back using RMAN. I am new to Oracle. I got the rman prompt. what should i do to start a backup?

Report message to a moderator

Re: RMAN BACK UP [message #343201 is a reply to message #343198] Tue, 26 August 2008 11:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

I am sorry to see that GOOGLE & the Search function of this forum are broken for you.
Repairs are underway.
Please be patient.
Additional information will be available once repairs have been completed.

Report message to a moderator

Re: RMAN BACK UP [message #343202 is a reply to message #343198] Tue, 26 August 2008 11:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-BAC

Regards
Michel

Report message to a moderator

Re: RMAN BACK UP [message #343203 is a reply to message #343198] Tue, 26 August 2008 11:15 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just google/search documentation available at otn.oracle.com

Search this forum/wiki.
http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ#RMAN_backup_and_recovery

Report message to a moderator

Re: RMAN BACK UP [message #343206 is a reply to message #343198] Tue, 26 August 2008 11:25 Go to previous messageGo to next message
glanson
Messages: 11
Registered: August 2008
Junior Member
When i connect to target it shows the following error

RMAN> CONNECT TARGET /

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12162: TNS:net service name is incorrectly specified

how do i verify the net service name ?

Report message to a moderator

Re: RMAN BACK UP [message #343210 is a reply to message #343198] Tue, 26 August 2008 11:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from
env | sort

Report message to a moderator

Re: RMAN BACK UP [message #343212 is a reply to message #343198] Tue, 26 August 2008 11:33 Go to previous messageGo to next message
glanson
Messages: 11
Registered: August 2008
Junior Member
ORACL_SID=TEST

Still what should i need?

Report message to a moderator

Re: RMAN BACK UP [message #343218 is a reply to message #343198] Tue, 26 August 2008 12:01 Go to previous messageGo to next message
glanson
Messages: 11
Registered: August 2008
Junior Member
My evironmental variable are correclty set. Still it shows the error

RMAN> connect target;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12162: TNS:net service name is incorrectly specified

Report message to a moderator

Re: RMAN BACK UP [message #343220 is a reply to message #343198] Tue, 26 August 2008 12:06 Go to previous messageGo to next message
glanson
Messages: 11
Registered: August 2008
Junior Member
got it my ORACLE_SID was wrong in mentioned ORCAL_SID

Report message to a moderator

Re: RMAN BACK UP [message #343297 is a reply to message #343220] Tue, 26 August 2008 19:43 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member
hi,
so now another thing to consider.

Is your database running in archive log mode?

from an sql prompt logged in as sysdba, type the command

archive log list;

this will tell you whether you are running in archive log mode or not.
This is important because you can only use RMAN to do an offline backup if archiving is NOT enabled.

an offline backup
RMAN> run {
shutdown immediate;
startup mount;
backup database;
alter database open;
}


Online backups can be more complicated dependent on your company policy of Business Continuity and Business Recovery, but simply you could write a command such as this

RMAN> run {
backup database include current controlfile;
backup (archivelog all delete input);
}



regards

Alan

Report message to a moderator

Re: RMAN BACK UP [message #343304 is a reply to message #343198] Tue, 26 August 2008 21:23 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>This is important because you can only use RMAN to do an offline backup if archiving is NOT enabled.
As far as I know, the statement above is NOT correct.
RMAN can be used for both hot & cold backups; and with cold backups can be used regardless of archive mode or not.

Report message to a moderator

Previous Topic: RMAN Implementation.
Next Topic: Restore fails with ORA-19870 ORA-19587, ORA-27091, ORA-27067
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 12:39:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.