Steps to take backup in oracle 10g.
C:\oracle>rman target\
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 3 14:36:55 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
target database Password:
connected to target database (not started)
This is because the target database is not set to oracle_SID
How to do
RMAN> exit
Recovery Manager complete.
C:\oracle>set oracle_sid=test
C:\oracle>sqlplus/nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Nov 3 14:37:50 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> startup
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 1250452 bytes
Variable Size 180357996 bytes
Database Buffers 427819008 bytes
Redo Buffers 2940928 bytes
Database mounted.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options
C:\oracle>rman target/
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Nov 3 14:40:55 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: TEST (DBID=2340673584, not open)
RMAN> BACKUP DATABASE;
