Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

backup in noarchivelog mode using RMAN

user494397Mar 13 2006 — edited Oct 8 2009
My DB is mounted and in noarchivelog mode.
I want to take a cold backup before putting DB in archivelog mode.
Can you please tell why I am getting the following error when I run.

run { ALLOCATE CHANNEL c1 TYPE DISK FORMAT='/mnt/ukfile002/oracle_exports/dev01rac/2006_03_13/dev_%d_%s_%p';
backup as backupset database ;
release channel c1;}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "backup": expecting one of: "backupset, copy, compressed"
RMAN-01007: at line 2 column 11 file: standard input

RMAN> run { ALLOCATE CHANNEL c1 TYPE DISK FORMAT='/mnt/ukfile002/oracle_exports/dev01rac/2006_03_09/dev_%d_%s_%p';
backup as backupset database ;
release channel c1;}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: c1
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input

RMAN>
Starting backup at 13-MAR-06
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=148 instance=dev01rac1 devtype=DISK
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/13/2006 12:55:04
ORA-01138: database must either be open in this instance or not at all
continuing other job steps, job failed will not be re-run
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/13/2006 12:55:04
ORA-01138: database must either be open in this instance or not at all

RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: c1
RMAN-01007: at line 1 column 17 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade, unregister, validate"
RMAN-01007: at line 1 column 19 file: standard input
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2009
Added on Mar 13 2006
6 comments
29,080 views