Thinking Out Loud

October 26, 2013

You don’t need set echo on for RMAN

Filed under: RMAN — mdinh @ 11:36 pm

So there I was, reading on the internet about having set echo on for RMAN and started to incorporate it into RMAN scripts.

It was a waste of time since it is not needed according to my test cases.

Lesson learned is that don’t trust what is provided to you without a complete test case.

Here’s the test case.

[oracle@lax:db01]/home/oracle
$ cat bk.rman
connect target;
run {
allocate channel d4 device type disk format '/tmp/%d_%I_%T_%U' maxopenfiles 1;
backup tablespace system;
}
exit

$ nohup rman @bk.rman > rman.log 2>&1 &
[1] 3115
[oracle@lax:db01]/home/oracle
$
[1]+  Done                    nohup rman @bk.rman > rman.log 2>&1

[oracle@lax:db01]/home/oracle
$ cat rman.log

nohup: ignoring input

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Oct 26 16:21:51 2013

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

RMAN> connect target;
2> run {
3> allocate channel d4 device type disk format '/tmp/%d_%I_%T_%U' maxopenfiles 1;
4> backup tablespace system;
5> }
6> exit
connected to target database: DB01 (DBID=1452485914)

using target database control file instead of recovery catalog
allocated channel: d4
channel d4: SID=44 device type=DISK

Starting backup at 26-oct-2013 16:21:52
channel d4: starting compressed full datafile backup set
channel d4: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf
channel d4: starting piece 1 at 26-oct-2013 16:21:53
channel d4: finished piece 1 at 26-oct-2013 16:22:08
piece handle=/tmp/DB01_1452485914_20131026_k5oncr11_1_1 tag=TAG20131026T162152 comment=NONE
channel d4: backup set complete, elapsed time: 00:00:15
Finished backup at 26-oct-2013 16:22:08

Starting Control File and SPFILE Autobackup at 26-oct-2013 16:22:08
piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_10_26/o1_mf_s_829844528_96rmo452_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 26-oct-2013 16:22:23
released channel: d4

Recovery Manager complete.

[oracle@lax:db01]/home/oracle
$ rman @bk.rman > rman.log

[oracle@lax:db01]/home/oracle
$ cat rman.log

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Oct 26 16:23:00 2013

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

RMAN> connect target;
2> run {
3> allocate channel d4 device type disk format '/tmp/%d_%I_%T_%U' maxopenfiles 1;
4> backup tablespace system;
5> }
6> exit
connected to target database: DB01 (DBID=1452485914)

using target database control file instead of recovery catalog
allocated channel: d4
channel d4: SID=41 device type=DISK

Starting backup at 26-oct-2013 16:23:01
channel d4: starting compressed full datafile backup set
channel d4: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/oradata/LAX_DB01/datafile/o1_mf_system_8ymzrcgk_.dbf
channel d4: starting piece 1 at 26-oct-2013 16:23:02
channel d4: finished piece 1 at 26-oct-2013 16:23:17
piece handle=/tmp/DB01_1452485914_20131026_k7oncr36_1_1 tag=TAG20131026T162302 comment=NONE
channel d4: backup set complete, elapsed time: 00:00:15
Finished backup at 26-oct-2013 16:23:17

Starting Control File and SPFILE Autobackup at 26-oct-2013 16:23:17
piece handle=/oracle/flashrecovery/LAX_DB01/autobackup/2013_10_26/o1_mf_s_829844597_96rmq960_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 26-oct-2013 16:23:24
released channel: d4

Recovery Manager complete.
[oracle@lax:db01]/home/oracle
$
About these ads

1 Comment »

  1. That “echo” is a result of using the shell … its echoing the script not rman.
    Similar results with sqlplus
    sqlplus u/p << EOF
    select * from dual;
    quit
    EOF

    Comment by Daryl — October 27, 2013 @ 1:04 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

The Rubric Theme. Create a free website or blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 318 other followers

%d bloggers like this: