rman offline

my database is in production..
my database name is orc
the following script is in c:
I exit from sql
went to command prompt c:\backup
type rman
form rman>rman target sys/sys@orcl @C:\offline_full_whole.rman
output has multiple errors.
may I know the reason

run{
shutdown immediate;
startup mount;
allocate channel d1 type disk;
backup as backupset database
format 'c:\backup\offline_full_whole.bus';
alter database open;
}
nobleitAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark GeerlingsDatabase AdministratorCommented:
Have you done RMAN backups successfully of this database in the past, and now you get errors?  Or, are you trying to get RMAN working for the first time?

The username and password do not look correct to me.  Usually the "sys" logon is not used for RMAN, because SYS usually requies the "as sysdba" extension to the logon syntax.
0
nobleitAuthor Commented:
I altered sys password to sys.
yes I am trying to get RMAN working for the first time...
0
tangchunfengCommented:

try  this  script :

connect target sys/oracle@inst1

run{
    allocate channel c1 type disk;
    allocate channel c2 type disk;
    allocate channel c3 type disk;
    backup incremental level 0 cumulative tag 'db0' format 'E:\oracle\product\10.2.0\flash_recovery_area\WZ\FLASHBACK/db0%u_%s_%p' database skip readonly;
    sql 'alter system archive log current';
    backup filesperset 3 format 'E:\oracle\product\10.2.0\flash_recovery_area\WZ\FLASHBACK/arch%u_%s_%p' archivelog all delete all input;
    release channel c1;
    release channel c2;
    release channel c3;
}
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
resync catalog;

0
nobleitAuthor Commented:
backup incremental level 0 cumulative tag 'db0' format 'E:\oracle\product\10.2.0\flash_recovery_area\WZ\FLASHBACK/db0%u_%s_%p'

db0%u_%s_%p
will be created automatically or we have to manually create..
please advice..
0
tangchunfengCommented:
rman will create these files automatically and the directory should exist before backup
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.