Home » RDBMS Server » Backup & Recovery » Example for using RMAN?
Example for using RMAN? [message #73022] Sun, 18 January 2004 11:21 Go to next message
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
Re: Example for using RMAN? [message #73024 is a reply to message #73022] Mon, 19 January 2004 01:36 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: Example for using RMAN? [message #73026 is a reply to message #73024] Mon, 19 January 2004 05:38 Go to previous messageGo to next message
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
Re: Example for using RMAN? [message #73041 is a reply to message #73022] Thu, 22 January 2004 18:52 Go to previous messageGo to next message
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.
Re: Example for using RMAN? [message #73064 is a reply to message #73026] Mon, 26 January 2004 22:51 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: Example for using RMAN? [message #73086 is a reply to message #73064] Sat, 31 January 2004 09:41 Go to previous message
Chris L
Messages: 7
Registered: January 2004
Junior Member
or try this archive log list
Previous Topic: rman server processes
Next Topic: BACKUP WITH RMAN
Goto Forum:
  


Current Time: Thu Mar 28 13:37:49 CDT 2024