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  |
 |
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  |
John Watson
Messages: 8805
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 #617866 is a reply to message #617865] |
Fri, 04 July 2014 02:42 |
 |
Michel Cadot
Messages: 68421
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 |
John Watson
Messages: 8805
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 #617872 is a reply to message #617869] |
Fri, 04 July 2014 02:55 |
John Watson
Messages: 8805
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> |
|
|
|
|
|
Goto Forum:
Current Time: Wed Mar 29 20:58:12 CDT 2023
|
] 
Search
Help
Members
Register
Login
Home
