-
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.
-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|