Home » RDBMS Server » Backup & Recovery » Hot backup using RMAN (Oracle 10g,11g , Linux 6)
Hot backup using RMAN [message #617862] Fri, 04 July 2014 02:05 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi ,

Can somebody confirm the below steps for hot backup is correct using RMAN ?

check if the database is in archive log made using below command.

select log_mode from v$database;

if not in archive log mode , change it to archive log mode
shutdown immediate 
startup mount 
alter database archivelog;
alter database open;

check the status of the db
select log_mode from v$database;

SQL> archive log list;

If it is in archivelog mode:
RMAN> TARGET SYS/<password>@<service_name> NOCATALOG

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;


Regards,
Suhas

[Updated on: Fri, 04 July 2014 02:05]

Report message to a moderator

Re: Hot backup using RMAN [message #617864 is a reply to message #617862] Fri, 04 July 2014 02:09 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
One problem,
c:\users\john>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Fri Jul 4 08:09:49 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

RMAN> target sys/oracle@orclz

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "target": expecting one of: "advise, allocate, alter, an
, begin, @, call, catalog, change, comment, commit, configure, connect, convert, copy, c
te script, create virtual, crosscheck, declare, delete, delete from, describe, describe
op catalog, drop database, duplicate, exit, explain plan, flashback, flashback table, gr
import, insert, list, lock, merge, mount, noaudit, open, print, purge, quit, recover, re
report, "
RMAN-01007: at line 1 column 1 file: standard input

RMAN>

[Updated on: Fri, 04 July 2014 02:10]

Report message to a moderator

Re: Hot backup using RMAN [message #617865 is a reply to message #617864] Fri, 04 July 2014 02:39 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi John,

How to correct this error ?
Re: Hot backup using RMAN [message #617866 is a reply to message #617865] Fri, 04 July 2014 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just have a look at the allowed commands in the message RMAN gave you.
Hint:
> sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Ven. Juil. 4 09:41:31 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> michel/michel
SP2-0734: unknown command beginning "michel/mic..." - rest of line ignored.
SQL>

[Updated on: Fri, 04 July 2014 02:42]

Report message to a moderator

Re: Hot backup using RMAN [message #617867 is a reply to message #617865] Fri, 04 July 2014 02:42 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Er.... There are any number of examples in the docs. Furthermore, the error message (which I showed) identified the problem and shows the solution.
I am not being awkward by not telling you the answer. I am trying to encourage you to develop your problem solving methodology.
Re: Hot backup using RMAN [message #617869 is a reply to message #617867] Fri, 04 July 2014 02:50 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Yes i found it. Smile

from OS prompt
RMAN TARGET SYS/<password>@<service_name> NOCATALOG

Thanks All

[Updated on: Fri, 04 July 2014 02:50]

Report message to a moderator

Re: Hot backup using RMAN [message #617872 is a reply to message #617869] Fri, 04 July 2014 02:55 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Sussed.

Or,
c:\users\john>
c:\users\john>rman

Recovery Manager: Release 12.1.0.1.0 - Production on Fri Jul 4 08:54:57 2014

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect target sys/oracle@orclz

connected to target database: ORCLZ (DBID=2069531690)

RMAN>
Re: Hot backup using RMAN [message #617873 is a reply to message #617872] Fri, 04 July 2014 03:00 Go to previous message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
sounds better

[Updated on: Fri, 04 July 2014 03:00]

Report message to a moderator

Previous Topic: Can you create new tablespace to existing .dbf file without overwriting the data?
Next Topic: RMAN duplicate
Goto Forum:
  


Current Time: Thu Mar 28 12:56:03 CDT 2024