OraFAQ Forum: Backup & Recovery » Example for using RMAN?

Home » RDBMS Server » Backup & Recovery » Example for using RMAN?

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

Example for using RMAN? [message #73022]

Sun, 18 January 2004 11:21

Andrew
Messages: 144
Registered: March 1999

Senior Member

I need to back up an Oracle Database without stopping it, can RMAN be used for this?

If so, could someone give an example of how to do this?

Regards

Report message to a moderator

Re: Example for using RMAN? [message #73024 is a reply to message #73022]

Mon, 19 January 2004 01:36

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Yes, you can use RMAN to perform on-line database backups if and only if your database is in ARCHIVELOG mode. See the Oracle backup and Recover FAQ (www.orafaq.com/faqdbabr.htm) for more details and examples.

Best regards.

Frank

Report message to a moderator

Re: Example for using RMAN? [message #73026 is a reply to message #73024]

Mon, 19 January 2004 05:38

Andrew
Messages: 144
Registered: March 1999

Senior Member

Thanks for the reply Frank.

Is there a way to see if a database is in ARCHIVELOG mode through SQLPlusW or SQL Navigator?

Regards,

Andrew

Report message to a moderator

Re: Example for using RMAN? [message #73041 is a reply to message #73022]

Thu, 22 January 2004 18:52

Guru
Messages: 17
Registered: December 1999

Junior Member

Hi Frank,

You can backup the database without shutting down the database with the help of RMAN. Mail me to have the scripts.

Thanks,
Guru.

Report message to a moderator

Re: Example for using RMAN? [message #73064 is a reply to message #73026]

Mon, 26 January 2004 22:51

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Hi,

Do a select from v$database. Example:

SQL> SELECT log_mode FROM v$database;

LOG_MODE
------------
ARCHIVELOG

Best regards.

Frank

Report message to a moderator

Re: Example for using RMAN? [message #73086 is a reply to message #73064]

Sat, 31 January 2004 09:41

Chris L
Messages: 7
Registered: January 2004

Junior Member

or try this archive log list

Report message to a moderator

Previous Topic:	rman server processes
Next Topic:	BACKUP WITH RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 22:48:02 CST 2024