مشكلة تواجهنى فى الRMAN

[ayman_tamim]

رت مرحلة تجهيز ال RMAN بسهولة
و عند البدء فى اول BACKUP
حدثت المشاكل الاتية

علما باننى وجدت ال RMANموجود فى قاعدة البانات لكنة مغلق فقمت بتنشيطة للعمل بتغيير كلمة السر و و اضفت DBA لخواصة

Microsoft Windows 2000 [Version 5.00.2195]
© Copyright 1985-2000 Microsoft Corp.

D:\Documents and Settings\Administrator>cd\

D:\>rman target scott/target@orclitc  catalog rman/rman@orclitc

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright © 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ORCLITC (DBID=3784926879)
connected to recovery catalog database

RMAN>  shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN>  startup mount;

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area     135338868 bytes

Fixed Size                      453492 bytes
Variable Size                109051904 bytes
Database Buffers              25165824 bytes
Redo Buffers                    667648 bytes

RMAN> list backup;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of list command at 02/08/2005 10:55:37
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN> run {
2>         allocate channel ch1 type 'sbt_tape';
3>         backup database
4>         tag = 'weekly_backup';   # gives the backup a tag identifier
5>         }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 02/08/2005 10:59:23
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN> run {
2>         allocate channel ch1 type 'sbt_tape';
3>         backup database
4>         tag = 'weekly_backup';
5>         }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 02/08/2005 11:01:01
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN> run {allocate channel ch1 type disk;
2>      backup database
3>      format 'd:\oracle\backup\WholeBackup_%s.bak';
4>      backup current controlfile tag = 'database backup';}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 02/08/2005 11:02:13
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN> run {allocate channel ch1 type disk;
2>      backup database
3>      backup current controlfile tag = 'database backup';}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "current": expecting one of: "controlfile"
RMAN-01007: at line 3 column 8 file: standard input

RMAN> run {
2>         allocate channel ch1 type disk;
3> backup database
4>         tag = 'weekly_backup';
5>         }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 02/08/2005 11:03:59
RMAN-06004: ORACLE error from recovery catalog database: ORA-03114: not connecte
d to ORACLE

RMAN>

ما المشكلة فى رايكم؟ :angry:

تم تعديل 8 فبراير 2005 بواسطة ayman_tamim

[mojtaba]

السلام عليكم

لماذا هذا التعقيد !؟؟؟؟؟
استخدم rman من على الواجهه اسهل بكثير
هل قمت بدعم لRecovery catalog بالنسبه لقاعدة البيانات !؟؟؟
هذا فرق ادوات الواجهات من الCommand line
فالcommand line تفترض بان مستخدم على علم بكافة الParameters التى ينبغى تمريرها لتنفيذ الامر.

1- تاكد من حصول المستخدم على صلاحيات Login as batch job
2- استخدم مستخدم النظام ويندوز فى تشغيل الRMAN
3- قم بضبط الCredental ليناسب نفس مستخدم الوندوز

اخيرا قم بتنفيذ عملية تصدير عادية لاى جدول وليس عملية نسخ كامل لقاعدة البيانات تحتاج لحوالى 300 ميجا او اكثر

بالمناسبه توجد كميات ضخمه من الParameters التى ينبغى على الفرد الالمام بها اذا اراد العمل بالاوامر الخطيه Command line مثلا اذا اردت ان اقوم بعملية استراد اخمسه جداول من 4 مستخدمين مختلفين فى ثلاث ايام فى الاسبوع كيف يمكننى تنفيذ هذه العمليه عن طريق الاوامر !!!
هذه العمليه بسيطه اكثر مما تتخيل عن طريق اداة rman بواجهه :angry:

سلام