RMAN would'n't work

[edwtsang]

I want to try out RMAN feature.

I created RMAN user and RMAN_TS tablespace in remote database.

I used RMAN to create catalog. However, I can't perform any action after catalog creation.

Following error were generated.

RMAN-03022: compiling command: catalog
RMAN-03023: executing command: catalog
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-07005: error during channel cleanup
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10032: unhandled exception during execution of job step 1:
RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.DEVICESTATUS
RMAN-03006: non-retryable error occurred during execution of command: catalog
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10032: unhandled exception during execution of job step 1:
RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.INSPECTDATAFILECOPY

I am using Oracle Enterprise 8.1.6 for Linux.

anyone can help on it ?

Regards,
Edward.

[rohitsn]

Hi,
This is Rohit Nirkhe,Oracle DBA,OCp from India.I will give u all the steps in preparing ur system to use RMAN for backup and recoveries.

Step 1: Create a tablespace for RMAN data
create tablespace RMAN_DATA
add datafile '/disk1/data/rmandata1.dbf' size 60M;

Step 2: Create a user in ur catalog database.
create user rman identified by rman
default tablespace RMAN_DATA
temporary tablespace TEMP
quota unlimited on RMAN_DATA;

Step 3: Grant the rman user sysdba and sysoper role
grant sysdba,sysoper to rman;
Also grant him connect,resource roles
grant connect,resource to rman;

Step 4: connect as rman and run the catrman script(if using
Oracle 8)
catrman.sql - will create dbms_rcvcat and
dbms_rcvman packages and
other views and tables

Step 5: Use the following command to run rman
rman target="sys/sys@bscs521"
rcvcat="rman/rman@test521"
In this case ,bscs database is the target database
(for whom we have to take the backup)
test database is the catalog database

Step 6: If u give the above command,it will display the foll
BSCS:connected to the target database
TEST:connected to recovery catalog

Step 7: Give the following command
RMAN> register database;
This command will register ur target database
information into the recovery catalog.The
information contains all the
tablespaces,datafiles etc inf
coming from the controlfile of the target
database.

If u perform all the above steps correctly,u can use RMAN for ur backups and recovery.If u have only one database then u create the recovery catalog in the same database.
In case of any doubts please be free to write to me at
rohitsn@hotmail.com

Regards,
Rohit Nirkhe,Oracle DBA,OCP









[QUOTE][i]Originally posted by edwtsang [/i]
[B]I want to try out RMAN feature.

I created RMAN user and RMAN_TS tablespace in remote database.

I used RMAN to create catalog. However, I can't perform any action after catalog creation.

Following error were generated.

RMAN-03022: compiling command: catalog
RMAN-03023: executing command: catalog
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-07005: error during channel cleanup
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10032: unhandled exception during execution of job step 1:
RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.DEVICESTATUS
RMAN-03006: non-retryable error occurred during execution of command: catalog
RMAN-07004: unhandled exception during command execution on channel default
RMAN-10032: unhandled exception during execution of job step 1:
RMAN-10031: ORA-65535 occurred during call to DBMS_BACKUP_RESTORE.INSPECTDATAFILECOPY

I am using Oracle Enterprise 8.1.6 for Linux.

anyone can help on it ?

Regards,
Edward. [/B][/QUOTE]